Hacker News new | ask | show | jobs
by darth_avocado 418 days ago
Is there a tool that can connect to a db and generate its own diagram?
6 comments

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

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.
Proprietary and a bit pricy but Luna Modeller is good.