4 ms·

I maintain an almost exhaustive list of text to diagram tools [1]. dbdiagram.io requires login to export. Other dedicated text to database diagram tools are 1

I maintain an almost exhaustive list of text to diagram tools [1]. dbdiagram.io requires login to export. Other dedicated text to database diagram tools are 1. Database Diagram Tool https://databasediagram.com/app https://databasediagram.com/app 2. QuickDBD https://app.quickdatabasediagrams.com/#/ https://app.quickdatabasediagrams.com/#/ 3. ERD Lab https://app.erdlab.io/designer/guest https://app.erdlab.io/designer/guest (Requires Login to Export) [1]: https://xosh.org/text-to-diagram/ https://xosh.org/text-to-diagram/

spintin 2y ago
Isn't editable diagram to text more useful? I used to query databases and create diagrams from the metadata, but text to diagram just makes little sense to me.
- omneity 2y ago
  You probably know this already but I’ll leave it for posterity. https://mermaid.js.org/syntax/entityRelationshipDiagram.html https://mermaid.js.org/syntax/entityRelationshipDiagram.html
vseplet 2y ago
Thank you very much, interesting!
maxsupport 2y ago
[dead]
xnickb 2y ago
A bit more specialized, but still a nice list: https://wiki.postgresql.org/wiki/Design_Tools https://wiki.postgresql.org/wiki/Design_Tools
darth_avocado 2y ago
Is there a tool that can connect to a db and generate its own diagram?
- ChromaticPanic 2y ago
  Jet brains DataGrip is great for this. Compared to pgadmin an dbeaver. The DataGrip visualization options are so good that I grabbed a subscription.
  - bdangubic 2y ago
    100%… any new project I get involved I use DataGrip to build visualization to quickly get across the data model
- colemannugent 2y ago
  DBeaver will generate an ER diagram from a connected DB
  - 3eb7988a1663 2y ago
    I find the auto-generated layout to be pretty poor. Requires a lot of jostling to get something more compact and immediately usable.
- jamwil 2y ago
  Proprietary and a bit pricy but Luna Modeller is good.
- breadwinner 2y ago
  Visual DB can do that: https://visualdb.com/ https://visualdb.com/
- ssfak 2y ago
  chartsdb[1][2] can be installed locally (or run through Docker) and import your database schema [1]: https://chartdb.io/ https://chartdb.io/ [2]: https://github.com/chartdb/chartdb https://github.com/chartdb/chartdb
- speakspokespok 2y ago
  Your question doesn't include the size or complexity of the database you're trying to visualize. With that preface said, schemaspy has been around for years and years and I've seen it at every tech company I've ever worked at for visualizing their production databases. I think it's free? https://schemaspy.org/samples/chinook/relationships.html https://schemaspy.org/samples/chinook/relationships.html
snthpy 1y ago
Thank you for your list and webpage. Those are great!

spintin 2y ago

Isn't editable diagram to text more useful? I used to query databases and create diagrams from the metadata, but text to diagram just makes little sense to me.

omneity 2y ago
You probably know this already but I’ll leave it for posterity. https://mermaid.js.org/syntax/entityRelationshipDiagram.html https://mermaid.js.org/syntax/entityRelationshipDiagram.html

vseplet 2y ago

Thank you very much, interesting!

maxsupport 2y ago

[dead]

xnickb 2y ago

A bit more specialized, but still a nice list: https://wiki.postgresql.org/wiki/Design_Tools https://wiki.postgresql.org/wiki/Design_Tools

darth_avocado 2y ago

Is there a tool that can connect to a db and generate its own diagram?

ChromaticPanic 2y ago
Jet brains DataGrip is great for this. Compared to pgadmin an dbeaver. The DataGrip visualization options are so good that I grabbed a subscription.
- bdangubic 2y ago
  100%… any new project I get involved I use DataGrip to build visualization to quickly get across the data model
colemannugent 2y ago
DBeaver will generate an ER diagram from a connected DB
- 3eb7988a1663 2y ago
  I find the auto-generated layout to be pretty poor. Requires a lot of jostling to get something more compact and immediately usable.
jamwil 2y ago
Proprietary and a bit pricy but Luna Modeller is good.
breadwinner 2y ago
Visual DB can do that: https://visualdb.com/ https://visualdb.com/
ssfak 2y ago
chartsdb[1][2] can be installed locally (or run through Docker) and import your database schema [1]: https://chartdb.io/ https://chartdb.io/ [2]: https://github.com/chartdb/chartdb https://github.com/chartdb/chartdb
speakspokespok 2y ago
Your question doesn't include the size or complexity of the database you're trying to visualize. With that preface said, schemaspy has been around for years and years and I've seen it at every tech company I've ever worked at for visualizing their production databases. I think it's free? https://schemaspy.org/samples/chinook/relationships.html https://schemaspy.org/samples/chinook/relationships.html

snthpy 1y ago

Thank you for your list and webpage. Those are great!