5

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.

3

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

  • funny thing is, it brings back to snowflakejoins.com site. :) – atp9 Aug 22 '16 at 18:10
0

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) :)

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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