ChartDB
Open-source web-based database diagram editor. Instantly visualize your schema with a single smart query, no installation or password needed.
Smart Download
Visit Project Homepage
No installer available yet — head to the source repository
Instantly visualize any database schema with one query; free, no installation, AI-powered migration.
Core Features
- One-click smart import: run a single SQL in your database to export the full schema as JSON, paste it in to get an instant diagram
- AI-powered DDL export: generate migration scripts in any dialect (e.g., MySQL to PostgreSQL) with AI assistance
- Interactive editing: drag-and-drop tables, add annotations, and auto-sync changes on a live diagram canvas
- Zero setup: use the cloud version or self-host via Docker; no account required
- Wide database support: PostgreSQL (+Supabase/Timescale), MySQL, SQL Server, MariaDB, SQLite, CockroachDB, ClickHouse
What It Can't Do
- •Caveats: ① AI features require an OpenAI API key or a custom inference endpoint (e.g., local vLLM) – without it, export scripts lack AI assistance. ② Privacy-focused Fathom analytics are enabled by default; disable with `-e DISABLE_ANALYTICS=true`. ③ ChartDB is currently in public beta – evaluate in non-production environments. ④ Key differentiator: unlike traditional tools (e.g., dbdiagram.io) that require manual modeling, ChartDB imports your existing schema with one query, and the AI dialect export is unique for cross-DB migrations.
Use Cases
- Document existing databases with visual ER diagrams for team reference
- Plan database migrations by previewing schema differences and generating target-dialect DDL
- Collaborate on schema design: edit tables, share link, discuss with teammates
- Reverse-engineer complex databases to understand table relationships
Detailed Introduction
ChartDB is a powerful, web-based database diagramming editor that lets you instantly visualize your database schema with a single "Smart Query." It retrieves your schema as JSON, which you can paste into the editor to generate interactive diagrams. You can customize diagrams, export SQL scripts in any dialect (e.g., migrate MySQL to PostgreSQL) using AI, and collaborate without signing up. Supports PostgreSQL, MySQL, SQL Server, MariaDB, SQLite, CockroachDB, ClickHouse, and more. Currently in public beta, it's free, open-source (AGPL-3.0), and can be self-hosted via Docker or used on the cloud.
Troubleshooting & FAQ (1)
TroubleshootingHow to enable data persistence in ChartDB self-hosted version?
Data persistence is not supported in the self-hosted version. Diagrams are stored in the browser's IndexedDB, so they remain available only on the same device and browser. For cross-device access, use the cloud version. A community pull request (#889) may enable volume-based persistence; you can test it by checking out that branch and mounting a Docker volume for data storage.
Tags
Getting Started
Download installer
Click the button above to download the installer for your system
Install the software
Double-click the downloaded installer and follow the prompts
Step 1: Visit https://app.chartdb.io or run locally via Docker
Step 2: Select your database type, copy the provided 'magic query' and run it in your database client
Step 3: Paste the resulting JSON into ChartDB to instantly see your database diagram; start editing
- Step 1: Visit https://app.chartdb.io or run locally via Docker
- Step 2: Select your database type, copy the provided 'magic query' and run it in your database client
- Step 3: Paste the resulting JSON into ChartDB to instantly see your database diagram; start editing
Checksum not available
This project has not published a SHA-256 checksum on its GitHub Release page
SHA256 Checksum
No checksum available
Download directly from GitHub Releases and verify file integrity yourself
All SHA-256 checksums on this platform are extracted from the project's official GitHub Release page, without any modification. You can independently verify them on the GitHub Releases page.
Open Source Transparency
View GitHub SourceUninstall Info
Uninstall: For cloud version, just close the tab. For Docker, run `docker stop chartdb && docker rm chartdb`. For local npm install, delete the project folder and node_modules.
No Extra Dependencies
Ready to use after download. No additional runtime required.
Having issues? Check the FAQ below
1 FAQ
Similar Projects
pocketbase
PocketBase is an open source Go backend that includes embedded SQLite with realtime subscriptions, built-in file & user management, admin dashboard UI, and simple REST API. Can be used as standalone app or Go framework.
Visual Studio Code (Code - OSS)
A free, open-source code editor by Microsoft with rich extensions, debugging, and Git integration. The most popular developer tool worldwide.
scrcpy
Display and control your Android device from your computer via USB or TCP/IP. No root required, high performance, low latency, supports audio and video mirroring.