3 ms·
This looks really cool. Anyone know of a tool that can parse a complex sql and generate a table diagram showing the various joins etc.,?
by victor106 6y ago
This looks really cool.
Anyone know of a tool that can parse a complex sql and generate a table diagram showing the various joins etc.,?
- mbil 6y agoI don't think this is exactly what you described, but you may find it valuable: it's a tool that produces a visualization of a postgres query plan https://tatiyants.com/pev/#/plans/new https://tatiyants.com/pev/#/plans/new (click "create sample plan" in top right and then "submit" to see an example)
- eckza 6y agoSSMS has built-in support for generating database diagrams. Beyond that, look for ERD generation tools.
- mmsimanga 6y agoSQLeo[0] is a Java desktop client. You can use it to build SQL statements visually or paste in a SQL statement and get a diagram. Its been around for a long time, don't be fooled by the dated look of the screenshot. [0]https://sqleo.sourceforge.io/ https://sqleo.sourceforge.io/
- victor106 6y agoExactly what i was looking for. Thank you.
- flarg 6y agohttp://revj.sourceforge.net/example.html http://revj.sourceforge.net/example.html
- victor106 6y agoJust tried this out, works like a charm. Thanks so much for this. Been looking for a similar tool for a few months now.
- pvorb 6y agoIntelliJ IDEA Ultimate comes with a diagram functionality based on yFiles, which is quite good and I've used it several times to visualize the current database schema.
- noir_lord 6y agoYeah it's pretty OK, it's actually one of the least polished areas of the IDE, I'm amazed no one has devoted serious resources to a tool that can properly reverse engineer a schema and infer relationships giving you a list of "I think X and Y are related, are they?" questions to solve it. I've inherited so many "interesting" schema's over the years and it feels like archaeology understanding the creators intent.