johnnyfish

joined 1 year ago
[–] johnnyfish@lemmy.world 2 points 1 month ago

Thanks! Glad you like it 🙌 We don’t have a forum yet, but we do have a Discord where users share feedback and ask questionsl, you’re more than welcome to join: https://discord.com/invite/QeFwyWSKwC

[–] johnnyfish@lemmy.world 4 points 1 month ago

Thanks! DuckDB is definitely on our radar, a few others have asked for it too in this GitHub issue: #865. I’d suggest dropping a 👍 there so we can keep track of interest!

[–] johnnyfish@lemmy.world 2 points 1 month ago

Awesome, thanks! Hope you’ll like it, would love to hear what you think once you’ve played with it a bit.

[–] johnnyfish@lemmy.world 4 points 1 month ago (1 children)

Hey! We actually support some of these already, for example, in PostgreSQL we handle jsonb and array-like types pretty well. Curious, which database are you referring to?

 

Hi everyone! 👋

Back again with a fresh update on ChartDB - a self-hosted, open-source tool for visualizing and designing your database schemas.

Since our last post, we’ve shipped v1.16 and v1.17, focusing on better canvas interactions, smarter imports, and improved database coverage. Here’s what’s new 👇

Why ChartDB?

✅ Self-hosted - Full control, deploy via Docker
✅ Open-source - Community-driven and actively maintained
✅ No AI/API required - Deterministic SQL export, no external calls
✅ Modern & Fast - Built with React + Monaco Editor
✅ Multi-DB Support - PostgreSQL, MySQL, MSSQL, SQLite, ClickHouse, Oracle, Cloudflare D1

🔥 New in v1.16 & v1.17

  • Canvas Editing Upgrades - Create tables, open table editors, and define relationships directly on the canvas
  • Array Support - Full support for array fields across import/export and DBML
  • Views Support - Import and visualize database views
  • Quick Edit Mode - One-click edit for tables without switching modes
  • DBML Diff Preview - Preview changes to field types and relationships before applying
  • Smarter Imports - Detect auto-increment fields, parse more SQL variants
  • Improved PostgreSQL & SQL Server Support - Includes default values, new types, and ALTER TABLE handling
  • Canvas Filters 2.0 - Improved tree state, toggle logic, and filter behaviors
  • UI Polish & Fixes - 50+ fixes including performance, layout, field handling, and DDL exports

🔮 What’s Next

  • Version control - Git-backed diagram history
  • Sticky notes - Annotate diagrams visually
  • Docker improvements - Support for sub-route deployments

🔗 Live Demo / Cloud
🔗 GitHub
🔗 Docs

We're continuing to build based on community feedback, feel free to open issues, suggest features, or share how you’re using it!

Thanks again to everyone in selfhosted who’s supported ChartDB so far 🙌

 

Hi everyone! 👋

Back again with another update on ChartDB - a self-hosted, open-source tool for visualizing and designing your database schemas.

Since our last post, we’ve shipped v1.14 and v1.15, packed with features and fixes based on community feedback. Here's what’s new 👇

Why ChartDB?

  • ✅ Self-hosted - Full control, deployable via Docker
  • ✅ Open-source - Community-driven and actively maintained
  • ✅ No AI/API required - Deterministic SQL export, no external calls
  • ✅ Modern & Fast - Built with React + Monaco Editor
  • ✅ Multi-DB Support - PostgreSQL, MySQL, MSSQL, SQLite, ClickHouse, Oracle, Cloudflare D1

New in v1.14 & v1.15

  • Canvas Filtering Enhancements - Filter by area, show/hide faster
  • DBML Editor Upgrade - Edit diagrams directly from DBML
  • Areas 2.0 - Parent-child grouping + reorder with areas
  • View Support - Import and visualize database views
  • Auto-Increment Support - Handled per-dialect in export scripts
  • Custom Types - Highlight fields that use enums/composites
  • PostgreSQL Hash Indexes - Now supported and exportable
  • UI Fixes & Performance - 40+ improvements and bug fixes

What’s Next

  • Version control for diagrams, linked to your database
  • Sticky notes - Add annotations directly on the canvas
  • Docker improvements - Support for sub-route deployments
  • Clone diagram - Safely duplicate your diagram

🔗 Live Demo / Cloud: https://chartdb.io/ 🔗 GitHub: https://github.com/chartdb/chartdb 🔗 Docs: https://docs.chartdb.io/

Would love to hear your feedback, requests, or how you're using it in your stack. We’re building this together - huge thanks to the community for all - the support!

 

Hi everyone! 👋

Three months ago, I posted about ChartDB - a self-hosted, open-source tool for visualizing and designing your database schemas. Since then, we’ve shipped tons of new features and fixes, and we’re excited to share what’s new!

Why ChartDB?

  • ✅ Self-hosted - Full control, deployable anywhere via Docker
  • ✅ Open-source - Actively maintained and community-driven
  • ✅ No AI/API required - Deterministic SQL export, no external calls
  • ✅ Modern & Fast - Built with React + Monaco Editor
  • ✅ Multi-DB Support - PostgreSQL, MySQL, MSSQL, SQLite, ClickHouse, Cloudflare D1… and now Oracle!

Latest Updates (v1.11 → v1.13)

  • 🆕 Oracle Support - Import and visualize Oracle schemas
  • 🆕 Custom Types for Postgres - Enums and composite types
  • 🆕 Areas for Diagrams - Group tables visually into logical zones
  • Transparent Image Export - Great for docs & presentations
  • PostgreSQL SQL Import - Paste DDL scripts to generate diagrams
  • Improved Canvas UX - Faster, smoother, less lag
  • Inline Foreign Key DDL - Clean, readable SQL exports
  • Better JSON Import - Sanitize broken JSON gracefully
  • Read-Only Mode - View diagrams without editing access
  • DBML Enhancements - Support for comments, enums, inline refs

…plus 40+ bug fixes and performance improvements

🧠 What’s Next?

  • AI-powered foreign key detection
  • Git integration for diagram versioning
  • More database support & collaboration tools

🔗 GitHubhttps://github.com/chartdb/chartdb
🔗 Docshttps://docs.chartdb.io/ 🔗 Live Demo / Cloud Versionhttps://chartdb.io/

We’d love to hear your feedback, contributions, or just how you're using it.
Thanks for all the support so far! 🙌

[–] johnnyfish@lemmy.world 2 points 8 months 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!

 

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!

 

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

 

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!

 

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