Full-stack database exploration tool for designing, navigating, documenting and analyzing schemas, with ERD diagrams for large, messy databases.
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.io
Lucidchart
- 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
Clone the repository
git clone https://github.com/drawdb-io/drawdb - 2
Enter the project folder
cd drawdb - 3
Install dependencies
npm install - 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
Free multi-platform desktop SQL client and database tool supporting 100+ databases via JDBC and ODBC drivers.
Native database IDE for macOS, Windows and Linux supporting PostgreSQL, MySQL, SQLite, Redis, MongoDB, SQL Server and ClickHouse, with a built-in MCP server and AI chat.
AI-powered database client and MCP server for desktop and web, supporting Postgres, MySQL, MariaDB, SQL Server, ClickHouse and SQLite.
A free, local-first, AI-assisted database client and SQL workspace supporting 40+ databases across desktop, web, Docker and CLI.
Cross-platform SQL editor and database manager for Linux, macOS, and Windows, supporting MySQL, PostgreSQL, SQLite, SQL Server and many more.