this post was submitted on 27 Oct 2025
143 points (98.6% liked)

Selfhosted

60526 readers
1163 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

Detailed Rules Post

  1. Be civil.

  2. No spam.

  3. Posts are to be related to self-hosting.

  4. Don't duplicate the full text of your blog or readme if you're providing a link.

  5. Submission headline should match the article title.

  6. No trolling.

  7. Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details.

  8. AI-related discussions and AI-involved promotional posts have additional requirements for tagging, as noted in Rule 7 and the AI & Promotional Post Expanded Rules post.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 3 years ago
MODERATORS
 

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 🙌

top 7 comments
sorted by: hot top controversial new old
[–] QueenMidna@lemmy.ca 5 points 8 months ago* (last edited 8 months ago) (1 children)

Support for Big Data types (maps, hash sets ,structs) would be wonderful

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

[–] QueenMidna@lemmy.ca 1 points 8 months ago

Hadoop and other big data sources such as Spark

[–] Tangent5280@lemmy.world 4 points 8 months ago (1 children)

Looks great! I'll give it a try. Do you have a forum or discussions board?

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

[–] recklessengagement@lemmy.world 3 points 8 months ago (1 children)

I like the UI. I'll give it a test run when I find some time

[–] johnnyfish@lemmy.world 2 points 8 months ago

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