Selfhosted

46304 readers

621 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:

Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
No spam posting.
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.
Don't duplicate the full text of your blog or github here. Just post the link for folks to click.
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
No trolling.

Resources:

selfh.st Newsletter and index of selfhosted software and apps
awesome-selfhosted software
awesome-sysadmin resources
Self-Hosted Podcast from Jupiter Broadcasting

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

Questions? DM the mods!

founded 2 years ago

MODERATORS

HybridSarcasm@lemmy.world

HybridSarcasm@lemmy.hybridsarcasm.xyz

266

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

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

9 comments fedilink hide all child comments

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 7 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 (1 children)

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) (1 children)

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?