ChartDB

An open-source database schema editor and ER diagram generator. Paste a single query, get an interactive visual diagram of your entire schema — no direct database connection required.

Available as a self-hosted open-source tool (20k+ GitHub stars) or as a cloud-hosted SaaS.

Features

Instant Import

Run a single SQL query against your database and ChartDB generates a complete ER diagram in seconds. Supports direct DB connections or SQL script import.

Visual Schema Editor

Drag-and-drop ER diagram editor for designing and documenting schemas. Supports table colors, sticky notes, and area grouping for large, complex schemas.

DBML Editor

Interactive DBML (Database Markup Language) editor that stays in sync with the visual diagram. Edit the schema as code or visually — your choice.

AI ER Diagram Generator

Describe your data model in plain English and let the AI assistant generate the schema. Also assists with migrations and understanding existing schemas.

Database Sync

Keep diagrams automatically in sync with your live database. Detect schema drift and apply changes with a visual diff.

Real-Time Collaboration

Invite teammates to edit diagrams together. Changes are reflected live across all connected users (Teams plan).

Export & Embed

Export diagrams as PNG or SQL. Embed live diagrams in Notion, Confluence, Miro, or any tool that supports iframes.

Migration & Versioning

Track schema changes over time with a built-in changelog. Generate migration SQL between schema versions.

Supported Databases

• PostgreSQL, CockroachDB
• MySQL, MariaDB
• SQLite
• Microsoft SQL Server
• Oracle
• ClickHouse
• Snowflake, BigQuery (Teams Scale plan)

Pricing

Plan	Price	Users	Databases	Diagrams
Free (self-hosted/cloud)		1	1	2 (10 tables each)
Pro	$25/month	1	1	Unlimited
Teams	$59/month	Up to 3	Up to 5	Unlimited
Custom	Contact sales	Custom	Custom	Unlimited

The self-hosted version is free and open-source under AGPL. Yearly billing saves up to 40%.