Selfhosted @lemmy.world ChartDB @lemmy.world 1w ago

ChartDB (v1.2.0) - open-source database diagram visualization tool

Hey all!

About three weeks ago, I introduced ChartDB to this community and received a great response with tons of positive feedback and feature requests. Thank you for the amazing support!

recap of ChartDB: For those new to ChartDB, it simplifies database design and visualization, similar to tools like DBeaver, dbdiagram, and DrawSQL, but is completely open-source and self-hosted.

https://github.com/chartdb/chartdb

Key features:

Instant Schema Import - Import your database schema with just one query.
AI-Powered DDL Export - Generate scripts for easy database migration.
Broad Database Support - Works with PostgreSQL, MySQL, SQLite, MSSQL, ClickHouse, and more.
Customizable ER Diagrams - Visualize your database structure as needed.
Open-Source & Self-Hostable - Free, flexible, and transparent.

What’s New in v1.20 (2024-11-17)

Sharing Capabilities - Import and export diagrams easily for better collaboration.
Duplicate table: duplicate table from the canvas and sidebar.
Snap to Grid - Toggle or hold shift to precisely position elements.
New Templates Added - Now includes templates for Laravel, Django, Twitter, and more.
Docker Build Support - Includes OpenAI key support for Docker builds.

Bug Fixes & Improvements:

Optimized Bundle Size - Leaner builds for faster loading times.
Internationalization (i18n) - Added support for Korean, Simplified Chinese, Russian, French, and more.
Improved UX - Better interactions for editing diagram titles and smoother SQL export.

What’s Next?

More sharing and collaboration enhancements.
Expanded templates and language support.
New deployment options and compatibility for more databases.

We’re building ChartDB hand-in-hand with this community and contributors. Your feedback drives our progress, and we’d love to hear more! Thank you to everybody who contributed!

7 comments

Looks really cool!
- Thank you! 😊 Really appreciate it! We’re excited to keep improving and adding new features. If you have any feedback or ideas, feel free to share!
Nice, I was looking for something like this a few years ago on another project, at the time I settled for DBeaver, but this looks like it might be better fit for the job.

Hi @OP. I tried the demo, and I get this:

+-------------------------+
| metadata_json_to_import |
+-------------------------+
| NULL                    |
+-------------------------+
1 row in set (0.015 sec)

This is done on an actual working DB. Not sure what this about? Do you want me to open an issue on GitHub? This is on MariaDB and I seem some of the code posts like this:

WITH fk_info as (
":    ->   (SELECT (@fk_info:=NULL),

     ->               (SELECT (0)
    ->                FROM (SELECT kcu.table_schema,
m    ->                 kcu.table_name,
      ->                 kcu.column_name as fk_column,
    ->                 kcu.constraint_name as foreign_key_name,
    ->                 kcu.referenced_table_schema as reference_schema,
o    ->                 kcu.referenced_table_name as reference_table,
     ->                 kcu.referenced_column_name as reference_column,
    ->                 CONCAT('FOREIGN KEY (', kcu.column_name, ') REFERENCES ',
      ->                        kcu.referenced_table_name, '(', kcu.referenced_column_name, ') ',
    ->                        'ON UPDATE ', rc.update_rule,
    ->                        ' ON DELETE ', rc.delete_rule) AS fk_def

So the formatting seems to screw up the query, or am I wrong?

My idea is to incorporate your tool into my GitLab pipelines eventually, so thank you VERY much for this project.

Looks really nice!

But to be honest, what I and many devs I speak with need these days is some data explorer tool, like Jailer data browser, that gives you kind of the diagram that you do, but with a subset of concrete rows in the database and how they link together.
Interesting project. I wonder though how a repo that's merely a few months old and has only seen 117 issues in total does accumulate 9.8k stars? Seems a bit fishy to me.
- Thanks for your interest! I appreciate the curiosity about ChartDB's growth. We’ve been fortunate to receive a lot of positive engagement from the open-source community since launch, especially after being featured on the front page of Hacker News twice, which brought significant visibility. Our goal has always been to build an open-source tool that resonates with developers, and we’re humbled by the interest so far.
  
  Happy to share more about our journey, the challenges, and how the community has driven our development if you’re interested. Transparency and genuine community engagement have always been important to us!
  
  Thanks for your response! It wasn't my intention to sound overly critical. Congratulations on your spectacular growth and good luck for the future! I'll definitly keep an eye on ChartDB.

7 comments