261
submitted 2 weeks ago* (last edited 2 weeks ago) by johnnyfish@lemmy.world to c/selfhosted@lemmy.world

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!

top 9 comments
sorted by: hot top controversial new old
[-] julianwgs@discuss.tchncs.de 6 points 2 weeks ago

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 points 2 weeks ago

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 points 2 weeks ago

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 points 2 weeks ago* (last edited 2 weeks ago)

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 points 2 weeks ago

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 points 2 weeks ago

Nice db visualization, will try it out

[-] norgate@lemmy.dbzer0.com 3 points 2 weeks ago

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

[-] AnotherPenguin@programming.dev 1 points 2 weeks ago

Saving this one for later

[-] couch1potato@lemmy.dbzer0.com 1 points 2 weeks ago

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?

this post was submitted on 07 Apr 2025
261 points (99.6% liked)

Selfhosted

46305 readers
281 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

  1. Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.

  2. No spam posting.

  3. Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.

  4. Don't duplicate the full text of your blog or github here. Just post the link for folks to click.

  5. Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).

  6. No trolling.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 2 years ago
MODERATORS