Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Are there any tools to visualize a complicated SQL join? [closed]

Given that many frameworks will create complicated (and maybe not so readable/logical) SQL queries, it would seem that having a tool to show, visually, how the joins were done might be a helpful tool. But I have not found such a tool.

I took a query that included a lot of tables and created a graphic as an example of what I think would be the output from such a tool: manually generated visualization

The text on the links are the field names that are used in the join. The bold items are inputs to the query. The table names ending in digits are just repeat instances of the same table (ie Partner and Partner2 are the same table, just part of the query more than once).

I would like to be able to drop an SQL query into a tool and see a diagram like this. Possible?

like image 409
Dale Avatar asked Jun 21 '13 13:06

Dale


People also ask

Can you do data visualization with SQL?

If you need a more polished tool that's ready to go out of the box, a paid data-visualization tool for SQL is a good way to go. Each has a unique way of dealing with SQL and visualizing data, so what's good for other companies may not be the right choice for you.

What are the 4 types of SQL JOIN operations?

Four types of joins: left, right, inner, and outer.


1 Answers

I found this tool, it might be useful.

http://queryviz.com/online/

Although the SQL syntax supported looks to be quite limited..

like image 114
Ning Avatar answered Sep 30 '22 17:09

Ning