top | item 44972238

Show HN: ChartDB Cloud – Visualize and Share Database Diagrams

101 points| Jonathanfishner | 6 months ago |app.chartdb.io

Me and Guy (@guyb3) built ChartDB to generate ER diagrams from your database without a need of any database access (via query/sql/dbml). We started with an open-source version, and after seeing a lot of use we decided to make a cloud version.

Our OSS launch (1y ago) - https://news.ycombinator.com/item?id=41339308

Now we’re launching ChartDB Cloud - built for teams:

- Embed ERDs into docs, dev portals, or Miro/Notion etc.

- Collaborate in real-time (with live cursors like Figma)

- Keep diagrams always in sync with your database

- Organize large, messy schemas without pain

- Export DDL in multiple SQL dialects (solved deterministically)

- AI assistant to brainstorm and generate new schema objects or schema changes

We designed it so working with databases feels less like a chore and more like a creative process.

Would love feedback - especially from teams dealing with messy schemas or outdated docs.

https://app.chartdb.io

13 comments

order

reactordev|6 months ago

Pretty.

The question I have is this, and don’t attack me for asking, but do people still produce database diagrams for use at work? I thought we had abstracted this by using Domain Driven design, ORMs, APIs, and the like.

Do individual teams still document their tables or do they document their entities? Do you still hand roll sql in a dao or do you use some higher abstractions?

Curious minds want to know because it’s been over a decade since I’ve done any database design documentation and have only done lean relationships and domain modeling documentation. Swaggering the rest.

I will say this, I love the look of this and I would love to just draw abstract shapes and things like I do on Miro. AWS architectures, etc etc.

andersonklando|6 months ago

We do at my team. I do not work on the Backend side, but I help in designing the DB schema.

Whenever I am thinking of new features to be developed, or when engineers are suggesting some features/approaches, looking at the ERD helps a ton. Onboarding is also easier.

We were using Lucidchart[1] until we reached the limit[2], so we found dbdiagram.io (which is just not the same).

[1] So far, it was the best of the market in terms of "canvas freedom" [2] We are struggling with salaries, so we are saving everywhere

mrits|6 months ago

The databases often out live the abstraction.

matt-p|6 months ago

Yes, very much so but I think it's probably a self fulfilling thing?

If I care about the data model so much that I want to diagram it then it's going to be the exact DB schema.

datadrivenangel|6 months ago

People have stopped documenting their databases, which is a loss for the industry.

tonyhart7|6 months ago

only for learning

for industry???? let me create an ERD for my 10th SaaS tools that need generic auth and payment, nope

evanelias|6 months ago

I'd love to hear more about your experience with AGPL licensing and building a cloud/SaaS product later. It looks like you introduced a CLA four months ago, but have a lot of external contributions prior to that.

How did you solve the AGPL hurdles for that pre-CLA third-party code? It's usually impractical to get a lot of contributors to retroactively sign a CLA. Did you have to rewrite some/all of those older code contributions, or is the full cloud product open source as well?

benocodes|6 months ago

Been using ChartDB recently and it’s been quite good for my use case. I’m on Supabase, and found that the Supabase built-in ERD viewer kind of breaks down once you go past like 15 tables.

I tried a few other DB visualization tools but was turned off because it felt like I needed to learn another toolset, when I just wanted to import my schema and start working with it. ChartDB's approach was better for me, the single query import worked fine, and adding to the schema works how you'd expect.

Really hoping to see a feature for “diffs between the dev diagram and the live DB”. we’re collaborating on the diagram as a team, and it’d be great to track what changed between our current draft and the actual database.

gcanyon|6 months ago

Any thoughts of supporting .dot files?