drawDB

drawDB is a database schema editor and SQL generator that runs entirely in a browser tab. Sketching a data model usually means either a heavy desktop modelling tool or a diagram app that knows nothing about SQL, and this sits between the two.

Diagrams are built in a few clicks, and the result is a real entity relationship diagram editor rather than a drawing surface with table shapes on it. No account is needed to use it, so a schema can be sketched and discarded without leaving anything behind.

The parts that matter are the ones connecting a diagram to real SQL.

• SQL export: turn a finished diagram into a script for your database.
• SQL import: bring an existing schema in and get a diagram back from it.
• Migrations: generate migration scripts as the model changes.
• Editor customization: adjust the workspace to match how you work.
• Sharing: optional, and it needs the separate drawDB server plus environment variables set from the sample file.

Running it yourself takes a clone, an npm install and either a dev server or a production build. A Dockerfile is included, so a container build and a port mapping are enough to serve it on a local network. Everything except sharing works from the static build alone, which makes it cheap to keep an instance around for occasional schema work.