We've been using https://dbdiagram.io/ , which also has an open-source markup language: https://github.com/holistics/dbml
I like the markup language and the app looks nice but I just can't comfortably dump database schemas into random web apps.
Show HN: Private, text to entity-relationship diagram tool
61–70 of 87 posts
Re: Show HN: Private, text to entity-relationship diagram tool
#62did you consider letting the input be just sql ddl rather than yet another layer of ddl?
Every database has its own flavor of SQL syntax for DDLs. So, we settled on a minimal common syntax. We will have "import" functionality available soon. You should be able to convert database specific DDLs into diagram language.
Re: Show HN: Private, text to entity-relationship diagram tool
#63I love that this is trending on HN. LLMs be damned. We still have lots of “simple” problems to be solved, like how to effectively write and share an ERD.
Re: Show HN: Private, text to entity-relationship diagram tool
#64Re: Show HN: Private, text to entity-relationship diagram tool
#65Earlier quoted context omitted.
ive been a keeping a list of other diagramming tools too https://github.com/swyxio/spark-joy/blob/master/README.md#di...
Dude you have all the lists.
on a more serious note, everyone should have a little utility belt of lists, hand curated and intimately known. they are an extension of me at this point.
Re: Show HN: Private, text to entity-relationship diagram tool
#66Earlier quoted context omitted.
ive been a keeping a list of other diagramming tools too https://github.com/swyxio/spark-joy/blob/master/README.md#di...
would you mind checking https://chatuml.com out to see if it fits your list?
Re: Show HN: Private, text to entity-relationship diagram tool
#67Created this python script to export mysql to this format. Used chatgpt so expect weird code. it works! but dies a little with many tables :-) code: https://paste.rs/1ZHp7.py3 screenshot: https://i.imgur.com/4D2hEWc.png
Long term, we would want to build robust "Import" wizard for every dbms
Re: Show HN: Private, text to entity-relationship diagram tool
#68Re: Show HN: Private, text to entity-relationship diagram tool
#69This is the friggin' holy grail of all diagramming and modeling tools. And it is available and working now. Everything else is just too primitive !
Re: Show HN: Private, text to entity-relationship diagram tool
#70I love that this is trending on HN. LLMs be damned. We still have lots of “simple” problems to be solved, like how to effectively write and share an ERD.
A LLM would probably make this better. Instead of asking the user to learn a DSL why not just translate SQL to whatever structure the render functions uses?