Open-source ER/Studio alternatives

drawDB is a free, browser-based database schema editor and SQL generator. You build entity-relationship diagrams with a few clicks, and it works without creating an account, which makes it quick to sketch a data model before writing any code.

Diagrams can be exported to and imported from SQL scripts, and the tool can generate migrations. Topics show support for dialects including MySQL-family databases such as MariaDB, PostgreSQL, SQL Server, SQLite and Oracle, and diagrams are kept in the browser using IndexedDB. The editor is customizable, and the app is written in JavaScript.

drawDB is AGPL-3.0 licensed. The public version runs at drawdb.app, and you can also build it locally or with Docker to host it yourself. Sharing diagrams is optional and requires setting up a small server using the provided environment sample; with the Docker image you pass the server URL at startup, with no rebuild needed. It suits developers and students designing relational schemas.

ChartDB is an open-source database diagramming editor that runs in the browser. Its signature feature is a Smart Query: you run one query against your database, paste the resulting JSON schema into ChartDB, and your tables and relationships are visualized instantly, with no installation and no database password shared with the tool.

From there you can edit the diagram interactively and export it, and an AI-powered export generates DDL scripts in the SQL dialect of your choice, which helps when moving between engines, such as MySQL to PostgreSQL or SQLite to MariaDB. The diagrams are useful for documentation, team discussions and understanding an unfamiliar database. Topics show support for MySQL, PostgreSQL, SQLite, SQL Server and MariaDB, and the app is built with React and TypeScript.

ChartDB is AGPL-3.0 licensed. You can use the hosted editor at chartdb.io, which works without an account, or self-host the open-source code. It suits developers, data engineers and students who need quick schema visualizations and migration scripts without setting up heavy modeling software.