ChartDB
A web-based database diagram editor that imports your schema with one query, lets you edit entity-relationship diagrams and exports SQL, with no account required.
- GitHub stars
- 23k
- Last commit
- 20 days ago
- Latest release
- v1.20.1
- Licence
- AGPL-3.0
- Self-hosted
- Yes
- Hosted version
- Available
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.
Key features
- One-query schema import as JSON
- Interactive ER diagram editing
- AI-assisted DDL export across SQL dialects
- No installation or database password required
- Supports MySQL, PostgreSQL, SQLite and SQL Server
- No account needed
Pricing: A free plan covers one user. Pro is $25 per month for one person and Teams starts at $59 on its Basic tier; yearly billing is up to 40% cheaper and the Custom plan is quoted by sales.
