drawdb-io/drawdb

drawDB is a free, browser-based tool for visually designing database schemas and automatically generating the SQL code that creates them. A database schema is the blueprint of a database, it defines which tables exist, what columns each table has, and how tables relate to each other. The problem drawDB solves is that drawing this structure by hand and then writing the corresponding SQL create statements is tedious and error-prone; drawDB lets you drag and drop tables, define columns, draw relationships between tables, and produces the SQL for you. The tool is built entirely in JavaScript and runs in the browser, meaning there is no server required and no account needed to get started. You create tables visually on a canvas, specify column names and data types, and draw lines between tables to define foreign key relationships (links between records in different tables). Once your diagram is ready, you can export it as SQL, the code used to create the tables in a real database system, or import an existing SQL script to reverse-engineer a diagram from it. You can also generate migration scripts to describe changes between two versions of a schema. You would use drawDB when starting a new project and planning what your database will look like, when documenting an existing database for a team, or when preparing for a job interview that requires designing a database on a whiteboard. It supports multiple database dialects including MySQL, MariaDB, and others. The tech stack is JavaScript, and the project can be run locally with npm or deployed via Docker. An optional server component handles file sharing, but the core editor works offline.