ChartDB

ChartDB@lemmy.world · 5 months

Hi all - I’m one of the creators of Clawe.

Clawe is an open-source tool that helps you run and coordinate multiple OpenClaw agents in a structured way, instead of just having scattered scripts or cron jobs.

It gives each agent an identity, scheduled work loops, task boards, shared context, and a UI to monitor progress and status.

https://github.com/getclawe/clawe

Key features

Run multiple AI agents with clear roles
Agents check for work on schedules
Kanban-style tasks & assignments
Shared task context/history
Web UI for observing workflows
Fully self-hosted and open-source

Tech / setup

Uses OpenClaw as the agent gateway
Docker & Docker-Compose for easy local/per-VPS deployment
Convex backend for data storage (free tier works)
Anthropic API key required for agent models

Would love feedback from the self-hosted community, especially what kinds of workflows you’d want to automate or how you’d extend this architecture!

ChartDB@lemmy.world · 8 months

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

ChartDB@lemmy.world · 8 months

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!

ChartDB@lemmy.world · 8 months

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 · 8 months

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 · 8 months

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 · 10 months

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!

ChartDB@lemmy.world · 1 year

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

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

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

ChartDB@lemmy.world · 1 year

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!

ChartDB@lemmy.world · 1 year

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!

ChartDB@lemmy.world · 1 year

It just merged. Take a look in the readme how to set it up :)

ChartDB@lemmy.world · 1 year

I really appreciate you taking the time to share your thoughts so candidly. No worries at all - your feedback isn’t rude! If anything, it’s incredibly helpful in understanding how the messaging comes across to users, and that’s exactly the kind of insight we need to improve.

I totally get where you’re coming from with the SSO concern. Even if it’s more of a personal preference, it’s still a valid point, and I respect that. We’ll definitely consider adding a simple email-based sign-up option to give users more choice.

As for the Mac-only part, I hear you loud and clear. It’s frustrating when you’re excited about something, only to find out it’s not available on your platform. That’s on us for not making it clearer upfront, and we’ll be adjusting how we communicate this in the future to avoid any confusion.

On the ‘ChartDB 2.0’ vs. ‘Buckle’ transition - I get why this felt misleading, and I appreciate you calling it out. Our intention wasn’t to do a bait-and-switch, but I can see how it might have come across that way. The goal was to show continuity between ChartDB and what we’re building next, but we’ll rethink how we present this so it’s clearer from the start.

I really appreciate you sharing your perspective, and I hope you’ll keep giving us this kind of honest feedback. It helps us make things better for everyone. Thanks again!

Cheers, Jonathan

ChartDB@lemmy.world · 1 year

Thanks for your detailed feedback! I really appreciate you taking the time to share both your concerns and what you like about ChartDB. Let me address each of your points:

ChartDB v2.0 & Mac-Only Availability - I completely understand your frustration. We should have made it clearer upfront that the initial release of ChartDB v2.0 (Buckle) would be Mac-only. The reason behind this decision is that we’re prioritizing a solid foundation on one platform before expanding to Windows and Linux. That said, we’re actively working on cross-platform support, and I’ll make sure we communicate this more transparently moving forward.

Clarity & Messaging Around ChartDB v2.0 - You’re absolutely right that the messaging around ChartDB v2.0 could be clearer and less intrusive. We’ve received similar feedback and are actively working to improve this experience. You can track the updates and contribute to the discussion here: GitHub Issue #541. We want to ensure that users get the right information upfront without feeling pressured or misled.

The Name ‘Buckle’ & Product Direction - Buckle is our next-gen database tool, built on the foundations of ChartDB but designed to be much more interactive and powerful. The reason for the new name is that it’s not just an update—it’s a complete reimagination of how database tools should work. But we should definitely make that distinction clearer so users know what to expect before signing up. And yes, we’re exploring a freemium model to keep the core experience free while offering advanced features for those who need them.

Third-Party Sign-Up - I hear you on this! The reason we ask for sign-in via Google/GitHub is to prevent spam and ensure a smooth experience when we roll out access. We also only request the minimal permissions—just your email and name via SSO. It’s not full access to your Google or GitHub account, and we don’t retrieve any additional data. That said, I understand that some users may prefer a simple email-only sign-up, and we’ll consider adding that option in the future.

Feature Requests (Adding Views & VARCHAR Length) - I love that you’re thinking about these details! Right now, ChartDB shows existing views but doesn’t support adding new ones directly. We definitely want to include this in the future, as it would make the tool much more useful for database design. As for setting VARCHAR length - great catch!

We currently don’t expose that option, but it’s something we’ll look into adding. I truly appreciate your honest feedback. It helps us improve and make ChartDB/Buckle a better experience for everyone. If you have any more suggestions or need clarifications, I’d love to hear them! 😊

ChartDB@lemmy.world · 1 year

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@lemmy.world · 1 year

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

ChartDB@lemmy.world · 1 year

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@lemmy.world · 2 years

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@lemmy.world · 2 years

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@lemmy.world · 2 years

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!

ChartDB@lemmy.world · 2 years

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

Clawe - open-source coordination layer for OpenClaw agents

Key features

Tech / setup

🧩 ChartDB v1.17 - Open-Source DB Diagram Tool | Arrays, Views, Canvas Editing, and More

Why ChartDB?

🔥 New in v1.16 & v1.17

🔮 What’s Next

🧩 ChartDB v1.15 - Open-Source DB Diagram Tool | Now with Views, Auto-Increment Fields & Improved Filtering

ChartDB v1.13 - Open-Source DB Diagram Tool | Now with Oracle Support, Enums, Areas and More

Why ChartDB?

Latest Updates (v1.11 → v1.13)

🧠 What’s Next?

ChartDB – Open-Source Database Diagrams | Self-Hosted Alternative to dbdiagram.io & DrawSQL

Why ChartDB?

Latest Updates (v1.8.0 → v1.10.0)

What’s Next

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

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