drawDB
Schema design with no account and a few clicks: drawDB is the browser-based
entity-relationship diagram editor and SQL generator - an AGPL-3.0 React project with over
37,000 GitHub stars. Draw tables with columns, data types, defaults, and constraints; connect
fields to create foreign-key relationships; group tables into labeled subject areas; and
annotate with notes. When the design is ready, one export produces CREATE TABLE DDL - with
constraints, indexes, and foreign keys - targeted at MySQL, PostgreSQL, SQLite, MariaDB, SQL
Server, or Oracle. Diagrams can be database-specific, unlocking every native type plus dialect
features like PostgreSQL enums and composite custom types, or generic for portability across
all supported flavors. The reverse direction works too: paste existing DDL into the import
dialog and drawDB renders your live schema as a navigable diagram - the fastest way to
document an inherited database. Versioning and migration-script generation track schema
evolution, full editor ergonomics (undo/redo, copy/paste, duplicate, themes) keep iteration
fast, and diagrams export as PNG, SVG, or shareable JSON. Everything runs client-side against
browser storage - no backend database connection needed - so the self-hosted Docker deployment
is a featherweight static app that keeps proprietary schema designs entirely on your
infrastructure.
Deploy