Open-source erwin Data Modeler 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.

Liam ERD turns an existing database schema into a clear, interactive entity relationship diagram. It is meant for developers and teams who need to understand or document a database without drawing the diagram manually, and it works with both public and private repositories.

The interface supports panning, zooming and filtering so even complex schemas stay readable, and it reverse-engineers diagrams directly from your schema with little setup. Repository topics list PostgreSQL, Prisma, Ruby on Rails, tbls and SQL as input sources, with React Flow used for rendering. A command-line package is published for generating diagrams locally, and the project provides documentation and a roadmap.

Liam is written in TypeScript and licensed under Apache-2.0. You can run the CLI yourself, and the project's website also offers a hosted way to view diagrams. It suits engineering teams who want schema documentation that stays in sync with the code.