ChartDB

ChartDB is a web‑based editor for visualizing and designing database schemas. It retrieves a complete schema with a single “Smart Query” that returns JSON, allowing users to generate ER diagrams instantly for documentation, discussion, or analysis. The interface supports interactive editing, annotations, and exporting of DDL scripts in the target SQL dialect, with an optional AI‑driven export feature for migration between database engines.

The tool is available as a self‑hosted, open‑source application under the AGPL‑3.0 license, and can also be run in the cloud. It supports a range of databases including PostgreSQL (and Supabase/Timescale), MySQL, SQL Server, MariaDB, SQLite (including Cloudflare D1), CockroachDB, and ClickHouse. Deployment options include Docker containers, npm scripts, and a hosted demo, with optional integration of OpenAI or custom LLM endpoints for AI capabilities.

ChartDB targets developers, database administrators, and teams that need a quick, collaborative way to view, edit, and export database structures without requiring direct database access or password storage. Its focus on a single‑query import, interactive diagramming, and open‑source self‑hosting makes it suitable for environments where control over data and custom setup are important.