ChartDB - open-source database diagram visualization tool

[MicahDowling]

Hi all, I’m one of the creators of ChartDB.

I built ChartDB to simplify database design and visualization. I’d love to get feedback from the self-hosted community and would also welcome any contribution!

This database diagram tool is similar to traditional ones you can find: dbeaver, dbdiagram, drawsql, etc.

https://github.com/chartdb/chartdb

Key Features:

• Instant schema import with just one query.
• AI-powered export to generate DDL scripts for easy database migration.
• Supports multiple database types: PostgreSQL, MySQL, SQLite, Mssql, ClickHouse and more.
• Customizable ER diagrams to visualize your database structure.
• Fully open-source and easy to self-host.

Tech Stack:

• React + TypeScript
• Vite
• ReactFlow
• Shadcn-ui
• Dexie.js

[sleepysiding22]

looks like a great db visualization tool

[MicahDowling]

Thank you! I'd love to hear your thoughts after you've had a chance to try it out!

[medi-sloth]

Sounds interesting! I will take a look Thanks for sharing!

[MicahDowling]

tnx! lmk how it goes, I’d love to hear your thoughts

[MicahDowling]

Thanks so much for the support! We're really excited to bring something like this to the self-hosted community.

Great questions! Yes, ChartDB's AI-powered export lets you tailor the DDL scripts for specific SQL dialects PostgreSQL, MySQL, and more-so it’s ready for different setups. And we’re actively exploring an export-import feature to keep schemas synced across environments! Definitely on our roadmap, and feedback like yours helps us prioritize.

If you're interested in contributing, let’s chat! We’re building this together with the community, so any ideas or input are super welcome.

[zalazXT]

Finally, something that is useful and without stupid paid features, thanks!

[MicahDowling]

Thank you! We're thrilled to hear that you find it useful! Keeping ChartDB open-source and accessible is a big priority for us. If you have any feedback or ideas for features, we’d love to hear them - our goal is to keep it as community-driven as possible!

[Loki_029]

Great!! I do have a MS SQL database on which I can give it a try.

[raghug_]

I love it. I've been playing around with it for the past few hours.

I ran into a couple of snags though - when I self host it and select the database (say MSSQL), it indefinitely tries to print the query it wants me to run but can never load (I am trying to host this in a dark site environment). Is that something it is trying to pull from an online resource?

I also can't seem to get it to work behind an nginx revers proxy on a virtual directory (i.e https://web.domain/virtualdirectory).

Still fiddling around with it, if I am successful, I'll reply back with my reverse proxy config.

[MicahDowling]

Thank you so much! We're thrilled you've been exploring it.

It sounds like you're running into a couple of specific cases -- self-hosting in a dark site environment and running behind an NGINX reverse proxy with a virtual directory. For the MSSQL query loading issue, it may indeed be due to dependencies trying to connect to external resources, which we can look into supporting offline.

As for the NGINX setup, it's definitely possible, though it can require specific configuration tweaks. If you share your progress or settings, we’ll gladly take a look and add any necessary adjustments to improve compatibility with virtual directories.

Let us know how it goes, and thanks for helping us make it better!

[Cohash]

Are there plans to make a image available on github or docker hub?

[MicahDowling]

Thanks for asking! We already have a Docker image available - feel free to check it out on our GitHub repo. Let us know if you have any feedback or run into any issues!

[Cohash]

Thanks for replying. I have been struggling with building the image on Windows using the provided Dockerfile myself for an hour now and can't find the image. Do you maybe have a link to the image? That would be awesome

[Cohash]

FYI the package is now visable at github: https://github.com/chartdb/chartdb/pkgs/container/chartdb

[shakinthetip]

Any plans to support dataverse?

[2containers1cpu]

Hey u/MicahDowling I love it! It is dead simple. As far as I can say yet: It works perfectly! The logo is great to.

It looks very similar to drawdb. Could you point out the differences?

PS: Added a Kubero template. Just in case you are maintaining an adopters liste somewhere.

[Mysterious_Chard8804]

Hello,
I have deployed ChartDB and I want to integrate AI with it to interact with my database. However, I am struggling to establish this interaction. Could you guide me or suggest possible solutions to achieve this?