OpenSource-Hub
C

ChartDB

22.1k stars·Developer Tools·SHA-256 checksum verified

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)

Troubleshooting
How 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.

GitHub Issue #609

Tags

databasediagrameditorvisualizationAIschema

Getting Started

1

Download installer

Click the button above to download the installer for your system

2

Install the software

Double-click the downloaded installer and follow the prompts

3

Step 1: Visit https://app.chartdb.io or run locally via Docker

4

Step 2: Select your database type, copy the provided 'magic query' and run it in your database client

5

Step 3: Paste the resulting JSON into ChartDB to instantly see your database diagram; start editing

Install Guide
  1. Step 1: Visit https://app.chartdb.io or run locally via Docker
  2. Step 2: Select your database type, copy the provided 'magic query' and run it in your database client
  3. Step 3: Paste the resulting JSON into ChartDB to instantly see your database diagram; start editing
File Integrity

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 Source
Environment Guide

Uninstall 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.

Project Info
LicenseAGPL-3.0
Last Updated2026-06-27 07:00:09
GitHub RepositoryOfficial Website

Having issues? Check the FAQ below

1 FAQ

Similar Projects