Repolode
drawdb-io

drawdb-io/drawdb

Free browser-based database schema editor that draws ER diagrams and generates SQL scripts, with no account required.

Open-source alternative to:dbdiagram.ioLucidchart

Stars
40,088
Forks
3,326
Open issues
245
Last commit
4 days ago

What is it?

drawDB is an entity relationship diagram (ERD) editor that runs entirely in the browser. You build tables and relationships by clicking and dragging, then export the schema as SQL or import existing SQL scripts to turn them back into diagrams. It also supports generating migrations and customizing the editor's appearance.

The project covers several database dialects, including PostgreSQL, MySQL/MariaDB, SQLite, SQL Server and Oracle, and includes DBML and MCP-related topics among its tags. No account is needed to use the editor. Work is kept in the browser, and file sharing is optional: it requires a separate drawDB server to be configured.

The app can be run locally with npm, built for static hosting, or started as a Docker container. The Docker image accepts a backend URL at runtime, so it does not need rebuilding to point at a different sharing server.

Key features

  • 01Drag-and-drop ERD editing for tables and relationships in the browser.
  • 02Export schemas to SQL and import existing SQL scripts into diagrams.
  • 03Generate migration scripts from schema changes.
  • 04Supports multiple database dialects such as PostgreSQL, MySQL, SQLite, SQL Server and Oracle.
  • 05No account required; optional file sharing via a separate server.
  • 06Docker image with a runtime-configurable backend URL.

Use cases

  • Designing a new database schema visually before writing migrations.
  • Reverse-engineering an existing SQL dump into a readable diagram.
  • Sharing a schema diagram with a team through a shared link.
  • Quickly sketching data models without installing desktop software.

Quick start

  1. 1

    Clone the repository

    git clone https://github.com/drawdb-io/drawdb
  2. 2

    Enter the project folder

    cd drawdb
  3. 3

    Install dependencies

    npm install
  4. 4

    Start the development server

    npm run dev

Things to know

  • Sharing features require a separate drawdb-server setup, which is optional.

Topics

FAQ

What is drawdb?
Free browser-based database schema editor that draws ER diagrams and generates SQL scripts, with no account required. drawDB is an entity relationship diagram (ERD) editor that runs entirely in the browser. You build tables and relationships by clicking and dragging, then export the schema as SQL or import existing SQL scripts to turn them back into diagrams. It also supports generating migrations and customizing the editor's appearance.
Is drawdb free to use? What license does it have?
drawdb is open source under the AGPL-3.0 license. Check the license terms before using it in commercial products.
Is drawdb still maintained?
Actively maintained. The last commit to drawdb was on Oct 15, 2026.
What can I use drawdb for?
Designing a new database schema visually before writing migrations. Reverse-engineering an existing SQL dump into a readable diagram. Sharing a schema diagram with a team through a shared link. Quickly sketching data models without installing desktop software.
How do I install drawdb?
Clone the repository: git clone https://github.com/drawdb-io/drawdb Enter the project folder: cd drawdb Install dependencies: npm install Start the development server: npm run dev
Where can I get drawdb?
The source code and installation instructions are on GitHub: https://github.com/drawdb-io/drawdb

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects