MySQL/Postgres ER diagram generator

open-source-ideas / ideas

💡 Looking for inspiration for your next open source project? Or perhaps you've got a brilliant idea you can't wait to share with others? Open Source Ideas is a community built specifically for this! 👋

6.59k stars 220 forks source link

MySQL/Postgres ER diagram generator #22

Closed Thrilleratplay closed 6 years ago

Thrilleratplay commented 8 years ago

Project description

Autogenerate , or load cached, force layout node graph, example, by reading the information_schema metadata from MySQL/Postgres/Oracle/SQL Server. Node tethers would represent foreign keys. Hovering or highlighting a node could show the table description.

Security should be the first priority, followed by performance and usability.

Relevant Technology

The example is Ontology Visualization from d3.js Gallery.

Who is this for

Advanced experience.

Nzen commented 7 years ago

Perhaps consider schemaspy. The graphs are columnar, rather than force directed. I sense an implied desire that this be a webservice. SchemaSpy makes a static website of the tables with diagrams. If one were to put that behind a normal webserver, that could satisfy the idea presented here.

Thrilleratplay commented 6 years ago

SchemaSpy is the essence of the idea I had. @Nzen Thank you.