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 🙌

    • ChartDB@lemmy.world
      cake
      OP
      link
      fedilink
      English
      arrow-up
      4
      ·
      7 hours ago

      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?

    • ChartDB@lemmy.world
      cake
      OP
      link
      fedilink
      English
      arrow-up
      2
      ·
      7 hours ago

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

    • ChartDB@lemmy.world
      cake
      OP
      link
      fedilink
      English
      arrow-up
      3
      ·
      7 hours 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!