overview for johnnyfish

ChartDB (v1.7.0) - open-source database diagram visualization tool in c/selfhosted

[–] johnnyfish 3 points 6 hours ago (1 children)

Lol, love that! Even one person can change the world! 😄🌍

Regarding OpenAI - yes, it’s going to stay OpenAI-compatible, but I’m actually about to add a PR that will allow you to choose the LLM host, so local models will be an option soon! Stay tuned. 🚀

ChartDB (v1.7.0) - open-source database diagram visualization tool in c/selfhosted

[–] johnnyfish 2 points 6 hours ago

Give ours a try! I’d love to hear your feedback - hopefully, it’ll be an even better experience lol

31

ChartDB (v1.7.0) - open-source database diagram visualization tool (lemmy.world)

submitted 7 hours ago by johnnyfish to c/selfhosted

8 comments fedilink

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

A few months ago, I introduced ChartDB to this community and received an amazing response - tons of positive feedback and feature requests. Thank you for the incredible support!

Recap: 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 Databases - 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.7.0 (2025-02-03)

🚀 New Features

CockroachDB Support - Now fully supports CockroachDB.
ClickHouse Enhancements - Improved ClickHouse integration.
DBML Editor - Added a built-in DBML editor in the side panel.
Import DBML - Now you can import DBML files directly into ChartDB.
Drag & Drop Table Ordering - Easily reorder tables in the side panel.
Mini Map Toggle - Added a toggle option for mini-map visibility.

🛠 Bug Fixes & Improvements

Docker Build - OPENAI_API_KEY is now optional when using Docker.
Canvas Editing - You can now edit table names directly on the canvas.
Dark Mode Fixes - Improved UI for the empty state in dark mode.
Power User Shortcuts - Added new keyboard shortcuts and key bindings.
Performance Boost - Optimized bundle size for faster loading.

What’s Next?

AI - Tables Relationships finder - AI-powered tool to detect table relationships.
CLI/API Diagram Updates - Option to update diagrams via CLI, API, or a JSON input file.
Git Integration for Versioning - Manage and track diagram changes with Git version control.
More database support & DBML improvements.
Enhanced collaboration & sharing features.
Additional performance optimizations.

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! ❤️

ChartDB - open-source database diagram visualization tool in c/selfhosted

[–] johnnyfish 2 points 2 months ago

Thanks for the kind words and great feedback! Query capabilities are on our radar, and your input reinforces its importance. The mouse wheel suggestion for zooming is a great idea - I’ll note it for future updates. Glad to hear you'll give ChartDB a try alongside DBeaver - let us know if you have more ideas or feedback! (give a look to our next innovation - https://buckle.dev Would love to chat. feel free to DM me somehow :)

ChartDB (v1.2.0) - open-source database diagram visualization tool in c/selfhosted

[–] johnnyfish 3 points 2 months ago

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!

ChartDB (v1.2.0) - open-source database diagram visualization tool in c/selfhosted

[–] johnnyfish 8 points 2 months ago (1 children)

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!

149

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

submitted 2 months ago by johnnyfish to c/selfhosted

7 comments fedilink

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!

ChartDB - open-source database diagram visualization tool in c/selfhosted

[–] johnnyfish 2 points 3 months ago

Thanks for the thoughtful feedback, Daniel! You bring up a great point about the complexity of the current approach with the SQL script and the reliance on pbcopy. We’ll definitely consider simplifying it by providing just the raw SQL query, so users can run it in whatever way works best for them. As for the cloud version, we’re leaning towards using LocalStorage for data storage on the client side to keep everything local to the user’s machine, ensuring privacy and control. We’ll make this clearer in the UI and documentation. Appreciate the suggestions - they’re super helpful as we continue refining ChartDB!

ChartDB - open-source database diagram visualization tool in c/selfhosted

[–] johnnyfish 1 points 3 months ago

Thanks a ton! Glad you like the design - keeping it and user-friendly is what we’re all about. We’ll be here whenever you’re ready to give it a spin!

ChartDB - open-source database diagram visualization tool in c/selfhosted

[–] johnnyfish 5 points 3 months ago* (last edited 3 months ago)

Great question! You don’t have to send anything to a third party - exporting SQL scripts tailored to a specific dialect is optional. By default, we offer a generic SQL export, and only when you need precise, dialect-specific scripts does AI come into play. In the self-hosted version, you’d provide your own OpenAI token, so data stays entirely in your control. Hope that clears it up!

ChartDB - open-source database diagram visualization tool in c/selfhosted

[–] johnnyfish 1 points 3 months ago (2 children)

That’s awesome to hear! Thanks for giving ChartDB a shot! We’d love to know how it stacks up for you and if there are any features you think would make it even better. Feel free to reach out here or join our Discord if you have questions or feedback along the way.

ChartDB - open-source database diagram visualization tool in c/selfhosted

[–] johnnyfish 5 points 3 months ago

Hey! I get the AI hesitation - it’s everywhere, and I totally understand if you’re wary of buzzwords! With ChartDB, our focus is on making database diagramming simpler, faster, and visually intuitive without the bloat you sometimes find in other tools. The AI component is there mainly to speed up migrations and adapt the tool to specific SQL dialects, so it’s helpful but not in your face.

As for why it might work better for you than DBeaver, ChartDB shines if you’re looking for a minimal, open-source way to visualize schemas quickly without needing a full database management suite. It’s lightweight, community-driven, and designed to do one thing really well: diagram and share schemas with simplicity. Plus, we’re always open to feedback and building features that our community finds valuable!

ChartDB - open-source database diagram visualization tool in c/selfhosted

[–] johnnyfish 3 points 3 months ago

Lmk how was it pls :) Thank you!

ChartDB - open-source database diagram visualization tool in c/selfhosted

[–] johnnyfish 3 points 3 months ago

So happy to read that! Hope you will enjoy and find it as useful as you imagine! Thanks for sharing :)

131

ChartDB - open-source database diagram visualization tool (lemmy.world)

submitted 3 months ago* (last edited 3 months ago) by johnnyfish to c/selfhosted

16 comments fedilink

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

ChartDB to simplify database design and visualization, providing a powerful, intuitive tool that’s fully open-source. 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