Comment by smusamashah
1 day ago
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
2. QuickDBD https://app.quickdatabasediagrams.com/#/
3. ERD Lab https://app.erdlab.io/designer/guest (Requires Login to Export)
A bit more specialized, but still a nice list: https://wiki.postgresql.org/wiki/Design_Tools
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.
You probably know this already but I’ll leave it for posterity.
https://mermaid.js.org/syntax/entityRelationshipDiagram.html
Is there a tool that can connect to a db and generate its own diagram?
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
Jet brains DataGrip is great for this. Compared to pgadmin an dbeaver. The DataGrip visualization options are so good that I grabbed a subscription.
100%… any new project I get involved I use DataGrip to build visualization to quickly get across the data model
Visual DB can do that: https://visualdb.com/
chartsdb[1][2] can be installed locally (or run through Docker) and import your database schema
[1]: https://chartdb.io/ [2]: https://github.com/chartdb/chartdb
Proprietary and a bit pricy but Luna Modeller is good.
DBeaver will generate an ER diagram from a connected DB
I find the auto-generated layout to be pretty poor. Requires a lot of jostling to get something more compact and immediately usable.
Thank you very much, interesting!
[dead]