# chartdb/chartdb

Database diagrams editor that allows you to visualize and design your DB with a single query.

Repository: https://github.com/chartdb/chartdb
Canonical: https://ross.abutalabs.com/products/chartdb
Homepage: https://chartdb.io
Language: TypeScript
License: AGPL-3.0
License Family: copyleft
Topics: database, db, db-migration, editor, erd, mariadb, mssql, mysql, postgresql, react, schema-migrations, sql, sqlite, typescript, visualization, react-flow, xyflow
Last push: 2026-08-20T08:34:25+00:00

## Health v2 (maintenance only)
Score: 82/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 98, release rhythm 78, longevity 54
- inputs: {"age_days": 758, "days_push": 13, "days_rel": 148, "gap_med": 11.5, "n_releases_24m": 31}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 22806, forks 1474 (observed 2026-08-28T04:11:34.139555+00:00)

## What it is
ChartDB is an open-source, web-based database diagram editor that visualizes database schemas as ER diagrams from a single 'smart query', with interactive editing and SQL DDL export in multiple dialects. It supports PostgreSQL, MySQL, SQLite, MariaDB, and SQL Server, and can be used in the cloud or self-hosted via Docker or npm.

## Use cases
- visualize my database schema as an ER diagram
- design database diagrams without connecting to the database
- generate DDL scripts to migrate from MySQL to PostgreSQL
- document database schema for team discussions
- draw ER diagrams from a text prompt using AI
- keep database diagrams in sync with schema changes
- embed interactive database diagrams in documentation

## When to choose
- you need fast, no-credential schema visualization via a single query
- you want an open-source, self-hosted diagramming tool with no table limits
- you need cross-dialect SQL export for schema migrations
- you want AI-assisted ER diagram generation and schema suggestions

## When to avoid
- you need built-in user management and versioning in a self-hosted setup (cloud-only features)
- you require full database administration or query execution, not just diagramming
- you need offline desktop tooling rather than a web app

## Facets
- artifact type: application
- maturity: active
- function: data-visualization, developer-tools, editor, web-framework
- domain: databases, developer-tools, web-development, data-visualization
- platform: self-hosted, cross-platform
- tags: er-diagrams, database-design, schema-visualization, sql-export, schema-migration, react-flow, data-modeling, ai-diagram-generator, web-server, docker, nodejs

## Member repositories
- chartdb/chartdb (main) score 82

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:11:34.139555+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T16:56:54.912601+00:00, confidence not recorded.
  - readme: https://github.com/chartdb/chartdb (fetched 2026-08-28T04:11:34.139555+00:00, sha 186b02b52fae)
  - homepage: https://chartdb.io (fetched 2026-08-29T07:55:20.473402+00:00, sha 4a5365ea6f69)
  - site_page: https://docs.chartdb.io/docs/cloud-vs-self-hosted (fetched 2026-08-29T07:55:20.482659+00:00, sha 428da0b796ea)
  - site_page: https://chartdb.io/features/ai-er-diagram-generator (fetched 2026-08-29T07:55:20.484623+00:00, sha c8145b99e263)
  - site_page: https://chartdb.io/features/sync-database-to-diagram (fetched 2026-08-29T07:55:20.486396+00:00, sha f1616b5467f1)
  - site_page: https://chartdb.io/features/team-collaboration (fetched 2026-08-29T07:55:20.487965+00:00, sha 95fb61394881)
  - site_page: https://chartdb.io/features/embed (fetched 2026-08-29T07:55:20.489626+00:00, sha c4faacf6c00e)
  - site_page: https://chartdb.io/features/auto-save-changes (fetched 2026-08-29T07:55:20.491178+00:00, sha 68b43ae6c6b5)
- Data as of 2026-08-30T08:39:29.467469+00:00.