8

Is there a tool (gratis), that helps developer to understand or helps to visualize the complex queries (involving JOINS, GROUP BY).

I know about the snowflakesjoins service which provides visualizer upto 800 characters but that is quite short.

It doesn't really matter if it can access the database or not. All I want is: if the SQL query is supplied, it should give some sort of visualization to understand the complexity.

I am looking for something that runs on Windows.

Improve this question
0

2 Answers 2

Reset to default
3

Python based reverse snowflake: http://revj.sourceforge.net

Improve this answer
1
  • funny thing is, it brings back to snowflakejoins.com site. :)
    – atp9
    Commented Aug 22, 2016 at 18:10
3

This online SQL parser visualises data flows and table joins in SQL statements -- see demo. It comes with a free tier.

disclaimer: I am co-founder of SQLdep (somebody who got too lazy to manually analyse SQL) :)

Improve this answer
3
  • Well, the tool looks good but it seems like heavily priced for anyone even to consider.
    – atp9
    Commented Aug 8, 2017 at 13:29
  • 1
    QueryScope (query visualiser) is $15/month. QueryFlow is heavily priced as it aims at DWH teams with 1m+ lines of SQL code.
    – Martin Masarik
    Commented Aug 9, 2017 at 16:03
  • 1
    okay.that was missing piece.
    – atp9
    Commented Aug 9, 2017 at 16:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.