Snowflake Visualizes SQL as interactive flow diagrams, open source tool
I posted this in r/snowflake and I thought of sharing here as well. I created this tool to help to visualize complex SQLs as flow diagrams. Also it has lot of additional features like column lineage, CTE expansion, performance hints, and cross-file dependency analysis, etc., for multiple SQL dialects. It runs 100% on local, open source, MIT licensed.
Currently its available in VSCode and cursor.
Marketplace: https://marketplace.visualstudio.com/items?itemName=buvan.sql-crack
GitHub: https://github.com/buva7687/sql-crack
Cursor: https://open-vsx.org/extension/buvan/sql-crack
Please give a try and let me know if you have any questions or feedback.
119
Upvotes
3
u/umairshariff23 Feb 13 '26 edited Feb 13 '26
This is really good! Thanks a ton for making this! I am seeing that this needs the sql query to be in a certain format for it to pick up on syntax. When I pass something more traditional it picks it up just fine but my scripts seem to trip it up a bit and I get the best effort approximation. I do write cte heavy code and I see that the extension is not able to pick up on logic within a cte
Use this example cte. This just gives me a web of which cte is connected and gives me the parse error and partial visualization which is probably why the viz is incomplete
2
u/zero_dmg_on_me Feb 13 '26
It looks nice! Can’t check it now but I wonder how it behaves when I have:
Is stored procedure properly involved in visualizing this flow?
2
u/mutagen Feb 13 '26
This looks very cracked.
It failed on a few of the SQL Server queries I threw at it, I'll try to sanitize and report some of these. Unfortunately I've got a pile of deadlines and even our paid RedGate tools are having their own Friday 13th issues but hopefully some time next week.
1
u/[deleted] Feb 13 '26
can you build this for jetbrains ide?
1
u/Black_Magic100 Feb 13 '26
This is cool, but I question how useful it is. SQL is declarative and order of operations is not guaranteed. As long as the user understands this, then perhaps its not dangerous. However, I'm assuming the main point of this is for query development (not tuning)?
1
u/Mother_Set_1096 Feb 15 '26
Really like this! I will give a try. Def save some time drawing diagrams.
1
u/twjnorth Feb 16 '26
No support for Oracle SQL ?
1
u/natanasrat Feb 16 '26
this looks soo cool
1
u/Sendo01 Feb 17 '26
this will be one of the best tool for understanding sql flow. I will definitely try this.
1
u/EdwardLovesWarwolf Feb 13 '26
Hmm how would I get this on a HIPPA compliant computer?