ChartDB

ChartDB is an open-source database diagram editor that helps developers and data teams visualise and design database schemas. Understanding an existing database can be difficult when documentation is out of date or absent, and traditional modelling tools often require lengthy set-up, direct database connections or manual recreation of tables and relationships. ChartDB addresses this with a distinctive approach: users run a single provided query against their database, which returns the schema as JSON, and then paste the result into ChartDB to generate an entity-relationship diagram instantly. Its core approach is to remove friction from schema visualisation, avoiding the need to share database credentials with the tool while giving teams an accurate, interactive picture of their data structures that can be edited, discussed and exported for design work and documentation. This makes it useful for onboarding new team members and documenting legacy systems.

Key features include automatic diagram generation for PostgreSQL, MySQL, SQL Server, MariaDB, SQLite, Oracle, CockroachDB and ClickHouse, as well as cloud databases such as Supabase and Amazon Aurora. Users can edit tables, columns and relationships visually, arrange diagrams, add notes and areas, and export schemas as DDL scripts for different database dialects, which is useful for migrations between platforms. AI-assisted features can help generate or convert DDL, and diagrams can be shared with colleagues for collaboration. Because the project is open source, it can be self-hosted, for example using Docker, while a hosted cloud version offers additional collaboration capabilities. The interface runs in a web browser and requires no installation for the hosted edition. ChartDB is aimed at software developers, database administrators, data engineers and technical teams documenting or planning database designs. Pricing starts from around USD 19 with a free trial, and a free version is also available, including the self-hosted open-source edition.