Logo
Deploy Now

SaaS Alternative

Lucidchart dbdiagram.io Vertabelo SqlDBM

Categories

Self-Hosted Open Source Developer Tools Database Design Diagramming Data Modeling

Stars

38116

Forks

3092

Watchers

138

Developer links

Last Updated: 07-17-2026 08:46 PM (UTC)

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.

drawDB
drawDB

Benefits

  • Design to DDL in One Click
  • The diagram is the source of truth - export runnable CREATE TABLE scripts with constraints and indexes for your exact dialect.
  • Document Inherited Databases
  • Paste existing DDL and get a navigable diagram of a schema nobody ever drew - reverse engineering in seconds.
  • Schemas Stay Confidential
  • Client-side operation and self-hosting keep proprietary data models off third-party diagram services.
  • Six Dialects, One Diagram
  • Generic diagrams export to MySQL, PostgreSQL, SQLite, MariaDB, MSSQL, or Oracle; specific ones unlock native types.

Features

  • Visual Table Designer
  • Columns, types, defaults, constraints, and drag-to-connect foreign-key relationships.
  • SQL Export and Import
  • Generate DDL for six databases or reverse-engineer diagrams from pasted scripts.
  • Dialect-Aware Types
  • PostgreSQL enums, composite custom types, and database-specific features per diagram.
  • Versioning and Migrations
  • Track diagram versions and generate migration scripts to evolve live databases.
  • Subject Areas and Notes
  • Visually group tables and annotate designs for navigable large schemas.
  • Zero-Backend Architecture
  • Runs entirely in the browser with local storage; self-hosts as a lightweight static Docker app.