ChartDB – Open-Source Database Diagrams | Self-Hosted Alternative to dbdiagram.io & DrawSQL
from johnnyfish@lemmy.world to selfhosted@lemmy.world on 07 Apr 14:11
https://lemmy.world/post/27895786

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!

ChartDB - Free and open-source database diagrams editor

#selfhosted

threaded - newest

nevodavid@lemmy.world on 07 Apr 14:34 next collapse

Nice db visualization, will try it out

julianwgs@discuss.tchncs.de on 07 Apr 15:11 next collapse

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

norgate@lemmy.dbzer0.com on 07 Apr 18:49 next collapse

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

neidu3@sh.itjust.works on 07 Apr 19:33 next collapse

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 on 07 Apr 20:18 collapse

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 on 08 Apr 13:28 next collapse

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 on 09 Apr 08:27 collapse

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!

AnotherPenguin@programming.dev on 09 Apr 19:37 next collapse

Saving this one for later

couch1potato@lemmy.dbzer0.com on 10 Apr 03:54 collapse

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?