drawdb-io/drawdbPublic

Free, simple, and intuitive online database diagram editor and SQL generator.

AI summary: A free, simple, and highly intuitive browser-based database schema editor and SQL generator.

Stars: 39.4K; +18 today
Forks: 3.2K
Watchers: 149
Open issues: 131
Open PRs: 107
Contributors: ~150
Commits: 1.2K
Branches: 8

JavaScriptAGPL-3.0Created Jul 16, 2023Last push 4d ago+46 stars this week+627 this month

Star history

since Mar 31, 2024

39.4K stars as of Sep 9, 2026, tracked back to Mar 31, 2024. Historical curve reconstructed from public GitHub event archives, calibrated to the current total.

Contribution activity

commits per day, last 52 weeks

207 commits in the last yearLessMore

Signals and awards

derived from tracked data

Widely adopted
39,378 stars
Community-driven
~150 contributors
Continuous integration
Automated checks passing
Repeat trending
6 trending appearances

What drawdb does

DrawDB is a robust, open-source entity-relationship diagram editor that runs entirely within the web browser. It allows developers to visually architect complex database schemas, define tables, and configure relationships using a fluid drag-and-drop interface, without requiring a backend server or complex installations. Crucially, the tool can instantly translate visual designs into raw, deployable SQL export scripts tailored for major database systems. This drastically streamlines the initial database architecture phase, enabling rapid prototyping and seamless team collaboration. Everything runs completely client-side in the browser, ensuring data privacy and zero setup overhead.

Software engineers, database administrators, and technical architects who need a fast, accessible, and visual way to design relational databases and generate deployment scripts.

Visual Schema Editor: Provide a responsive, drag-and-drop canvas for designing complex relational database architectures.
Multi-Dialect Export: Automatically generate accurate DDL SQL scripts tailored for MySQL, PostgreSQL, SQLite, and SQL Server.
Relationship Mapping: Enable users to easily define and visualize complex foreign key constraints and table relationships.
Browser-Based Execution: Operate entirely client-side, ensuring user privacy and eliminating the need for complex server deployments.
Template Utilization: Offer a variety of pre-built schema templates to kickstart architecture for common application types.

Where teams use it

Database Prototyping

Developers rapidly sketch out and iterate on initial database architectures visually before writing any application code.

SQL Generation

Engineers quickly build a schema visually and export the necessary DDL scripts to instantly provision their development database.

Schema Documentation

Technical architects create clear, visually appealing entity-relationship diagrams to include in project documentation.

Migration Planning

Teams visually map out complex structural changes when planning significant database migrations or refactors.

Getting started: git clone https://github.com/drawdb-io/drawdb && cd drawdb && npm install && npm run dev

README

main branch

drawDB

Free, simple, and intuitive database schema editor and SQL generator.

DrawDB is a robust and user-friendly database entity relationship diagram (ERD) editor right in your browser. Build diagrams with a few clicks, export and import SQL scripts, generate migrations, customize your editor, and more without creating an account. See the full set of features on here.

Getting Started

Local Development

git clone https://github.com/drawdb-io/drawdb
cd drawdb
npm install
npm run dev

Build

git clone https://github.com/drawdb-io/drawdb
cd drawdb
npm install
npm run build

Docker Build

docker build -t drawdb .
docker run -p 3000:80 drawdb

If you want to enable sharing, set up the server and environment variables according to .env.sample. This is optional unless you need to share files.

Contributing

Please see CONTRIBUTING.md for guidelines on how to contribute to this project.

Support

Join discussions: Discord

View on GitHub

Recent activity

commits and pull requests

fix: center relationship labels vertically across browsers (Firefox + Chrome)Closed
#1121 by Apageoflove · updated 8d ago
fix: shift+scroll horizontal pan not working on macOSClosed
#1127 by Apageoflove · updated 8d ago
fix(canvas): read deltaX so shift + wheel scrolls horizontally in ChromeOpen
#1133 by ntdatt812 · updated 10d ago
Add color to relationshipsMerged
#1131 by 1ilit · updated 12d ago
Add color to relationships (#1131)
1ilit committed 5efc5fd · 12d ago
BUG: TYPO in mermaid.jsMerged
#1130 by Surajshivam-123 · updated 12d ago
Fix type in mermaid export (#1130)
Surajshivam-123 committed 240d566 · 12d ago
Add panning with arrowsMerged
#1129 by 1ilit · updated 12d ago
Remove warpMerged
#1123 by 1ilit · updated 12d ago
Add panning with arrows (#1129)
1ilit committed 1a1a416 · 12d ago
Fix vertical alignment of relationship labels (#1045)Closed
#1106 by Apageoflove · updated 15d ago
Escape single quotes in ENUM/SET values (#1126)
NgoQuocViet2001 committed 031aef1 · 17d ago

Recent open issues

view all

[BUG] Double bug report
#1132 · 11d ago · by TiagoGouvea

Discussions

all 22

Is there a way to export the schema diagram as an image file directly, or is SQL the only export option currently?
Q&A · 1mo ago · 2 comments
Two different JSON shapes for the same diagram. Why?
Q&A · 1mo ago · 1 comments
Is there a name for the JSON export format?
Q&A · 1mo ago · 1 comments
How to add a varchar/text field without a fixed length?
Q&A · 2y ago · 1 comments
Automatically generate references to foreign keys
Ideas · 2mo ago · 1 comments

Code frequency

additions and deletions

+16K lines added, -6.2K removed over the last year.

Commits per week

last 52 weeks

207 commits in the last 52 weeks.

When work happens

weekday and hour

Commit volume by weekday and hour (UTC). Larger dots mean more commits.

Date	List	Rank	Stars gained
Aug 15, 2026	weekly	#7	+693
Aug 14, 2026	weekly	#7	+693
Aug 13, 2026	weekly	#8	+665
Aug 12, 2026	weekly	#10	+597
Aug 11, 2026	weekly	#8	+503
Aug 10, 2026	weekly	#10	+331

freeCodeCamp/freeCodeCamp
freeCodeCamp.org's open-source codebase and curriculum. Learn math, programming, and computer science for free.
455.3K stars · TypeScript
practical-tutorials/project-based-learning
Curated list of project-based tutorials
282.9K stars · Python
affaan-m/ECC
The agent harness performance optimization system. Skills, instincts, memory, security, and research-first development for Claude Code, Codex, Opencode, Cursor and beyond.
255.9K stars · JavaScript
react/react
The library for web and native user interfaces.
249.9K stars · JavaScript
affaan-m/ECC
The agent harness performance optimization system. Skills, instincts, memory, security, and research-first development for Claude Code, Codex, Opencode, Cursor and beyond.
234.7K stars · JavaScript
vercel/next.js
The React Framework
142.2K stars · JavaScript

About

License: AGPL-3.0
First commit: Sep 19, 2023
Age: 3y 1m
Default branch: main
Tags: 11
Closed issues: 239
Merged PRs: 445
Owner type: Organization

Community health75%

✓Contributing guide
—Code of conduct
—Issue templates
—Security policy

Continuous integration

Buildsuccess

Source

21 top-level entries

Browse the full source tree

Languages

JavaScript 99.1%
CSS 0.7%
HTML 0.1%
Dockerfile 0.0%

Direct dependencies

package.json

@dagrejs/dagre@dbml/core@dnd-kit/core@dnd-kit/sortable@dnd-kit/utilities@douyinfe/semi-ui@lexical/react@monaco-editor/react@vercel/analyticsaxiosdexiedexie-react-hooksfile-saverframer-motionhtml-to-imagei18nexti18next-browser-languagedetectorjsonschemajspdfjsziplexicallodashluxonnanoid

Full dependency graph