ChartDB – Open-Source Database Diagrams | Self-Hosted Alternative to dbdiagram.io & DrawSQL

Hi everyone! πŸ‘‹

We’re excited to share the latest updates to ChartDB, our self-hosted, open-source tool for visualizing and designing database diagrams - built as a free and flexible alternative to tools like dbdiagram[.]io, DrawSQL, and DBeaver's diagram feature.

Why ChartDB?

βœ… Self-hosted – Full control, deployable anywhere via Docker
βœ… Open-source – Actively developed and maintained by the community
βœ… No AI/API required – Deterministic SQL export with no external dependencies
βœ… Modern & Fast – Built with React + Monaco Editor, optimized for performance
βœ… Multi-DB support – PostgreSQL, MySQL, MSSQL, SQLite, ClickHouse, and now Cloudflare D1

Latest Updates (v1.8.0 β†’ v1.10.0)

πŸ†• Cloudflare D1 Support - Import schemas via Wrangler CLI
πŸ†• Deterministic DDL Export - Replaced AI-based export with native SQL generation
πŸ†• Sidebar for Diagram Objects - Quickly navigate tables, fields, indexes, and FKs
πŸ†• Better Canvas UX - Right-click to create FKs, table drag-and-drop, better visibility controls
πŸ†• Internationalization - Added full French & Ukrainian support

What’s Next

  • Git integration for diagram versioning
  • SQL import support for PostgreSQL (via DDL script)
  • AI-powered table relationship detection
  • More database support and collaboration tools

πŸ”— GitHub: https://github.com/chartdb/chartdb
πŸ”— Docs: https://docs.chartdb.io/

We’d love your feedback, contributions, or just to hear how you’re using it. Thanks!

269 points · 10 comments · view on lemmy.world

10 Comments

julianwgs@discuss.tchncs.de · 7 pts · 1y

This is really cool and I will definitely try it out! Am I missing something or is there really no contributors license agreement?

neidu3@sh.itjust.works · 5 pts · 1y (1 reply)

Any way of having this study an existing database (or dump thereof) and build the graph? I have an oracle database that nobody understands, built by someone else, and I thought something like this could help..

vk6flab@lemmy.radio · 5 pts · 1y

I've never used the tool, but I'm guessing that your Oracle database can create an SQL dump of its schema which presumably is how this tool ingests a database to chart.

jogai_san@lemmy.world · 4 pts · 1y (1 reply)

Deterministic DDL Export - Replaced AI-based export with native SQL generation

Much better. Now it works for my case, which it didn't before.

johnnyfish@lemmy.world · 2 pts · 1y

Awesome, glad to hear it's working for you now! πŸŽ‰ We realized native SQL generation was the right move for reliability and consistency. Appreciate you sticking with it - let us know if you run into anything else!

nevodavid@lemmy.world · 3 pts · 1y

Nice db visualization, will try it out

norgate@lemmy.dbzer0.com · 3 pts · 1y (1 reply)

I gave it a quick look, it's neat. I will definitely be using it for future/existing projects.

johnnyfish@lemmy.world · 1 pts · 1y

That means a lot - thank you! πŸ™Œ Super excited to hear you'll be using it in your projects. If you ever have feedback, ideas, or run into anything, feel free to reach out!

couch1potato@lemmy.dbzer0.com · 1 pts · 1y

This looks really cool. Anyone know if there is a way to make something like this ingest a gedcom file and put out a visual like this?

AnotherPenguin@programming.dev · 1 pts · 1y

Saving this one for later