drawDB

AGPL-3.0
Platform
Web Docker
Licence
AGPL-3.0 Open source
Website
drawdb.app
drawDB

Overview

drawDB is a free, browser-based database diagram editor: you lay out tables on a canvas, connect them with relationships, and the editor keeps a matching SQL schema in step with what you draw. It is aimed at the moment before code exists — sketching a schema, explaining it to someone else, or checking that an existing database still matches the diagram in the wiki. No account is required to start working, and diagrams can be exported as SQL scripts for MySQL, PostgreSQL, SQLite, MariaDB, MSSQL or Oracle SQL.

What it does

  • Entity-relationship editing — draw tables, add columns with types, mark primary and foreign keys, and connect tables with one-to-many, one-to-one or many-to-many relationships. The canvas can be auto-arranged when a diagram gets tangled.
  • Import and export SQL — paste or upload CREATE TABLE statements to turn an existing schema into a diagram, then export the diagram back to SQL for whichever database you target.
  • Migration-style output — the editor can produce SQL that reflects changes to the diagram, which is useful for keeping a schema and its documentation from drifting apart.
  • Structure and code panels side by side — the same diagram is readable as a visual model, as table definitions or as SQL, and problems such as unconnected or incomplete tables are surfaced in the editor.
  • Optional sharing — a separate server component adds shareable diagrams and gist-style export. Without it the editor works entirely in the browser.

Running your own copy

drawDB ships as a Docker image, so a self-hosted instance is one command: docker run -p 3000:80 ghcr.io/drawdb-io/drawdb. Building from source needs Node.js and npm (npm install, then npm run build). If you want sharing, run the companion server and pass its address to the image with the VITE_BACKEND_URL environment variable — no rebuild is needed. The self-hosted copy is the same static editor the public site serves, so a local instance keeps every diagram on your own machine.

Where it fits

drawDB is a design tool rather than a database client: it does not connect to a live server or run queries, so it complements rather than replaces tools like DBeaver or pgAdmin, which are for browsing and querying a running database. Use drawDB to agree on the shape of a schema first, then open the exported SQL in your database of choice.

Explore More Categories

Sign In

Register

Reset Password

Please enter your username or email address, you will receive a link to create a new password via email.