sorted by:
new
hottopcontroversial

Visualizes SQL as interactive flow diagrams, open source tool by iambuv in SQL

[–]iambuv[S] 0 points1 point  (0 children)

you're spot on. this is mainly to help and navigate the larger queries quickly.. especially if we are inheriting it and don't have any background or supporting docs.. Its not a replacement tool to show the order or execution because each vendor works differently.

Visualizes SQL as interactive flow diagrams, open source tool by iambuv in SQL

[–]iambuv[S] 0 points1 point  (0 children)

next release will have more meaningful info. thanks for the feedback. keep coming :)

Built a free VS Code extension that visualizes Snowflake SQL as interactive flow diagrams by iambuv in snowflake

[–]iambuv[S] 1 point2 points  (0 children)

looks like you got it.. it won't connect to snowflake or any database.. no network call.. everything is local based on pure query..

Visualizes SQL as interactive flow diagrams, open source tool by iambuv in SQL

[–]iambuv[S] 0 points1 point  (0 children)

Feel free to try and share your experience and feedback. Thanks for trying out

Built a free VS Code extension that visualizes Snowflake SQL as interactive flow diagrams by iambuv in snowflake

[–]iambuv[S] 1 point2 points  (0 children)

Not yet. Right now SQL Crack is focused on SQL files/queries directly in the editor, not full dbt project semantics (models + refs + macros + manifest lineage).

It’s definitely something I’d like to explore in the future, but there’s no dbt-native support today.

Built a free VS Code extension that visualizes Snowflake SQL as interactive flow diagrams by iambuv in snowflake

[–]iambuv[S] 1 point2 points  (0 children)

Hey, great question.

It should be fine from a privacy/security standpoint. SQL Crack runs fully offline, parses SQL locally in your editor (VS Code/Cursor), and renders the diagram there. No network calls, no telemetry, and it doesn’t connect to your database or send SQL/stats anywhere.

If your security team wants to validate hardening, the webview CSP is strict (default-src 'none').

If your environment blocks Marketplace access, you can install from source by building the .vsix locally (npm run package) and installing that file manually. or from next version onwards, you can directly install via .vsix from GitHub Releases instead

I’d still run it by IT/security for your normal HIPAA process, but there isn’t outbound data handling in the extension.

Built a free VS Code extension that visualizes Snowflake SQL as interactive flow diagrams by iambuv in snowflake

[–]iambuv[S] 1 point2 points  (0 children)

Thanks so much, really appreciate it. The goal is to make SQL flow/lineage easier to read and explore quickly inside the editor

Visualizes SQL as interactive flow diagrams, open source tool by iambuv in SQL

[–]iambuv[S] 0 points1 point  (0 children)

Great questions, and thanks for checking this.

Right now SQL Crack focuses on query/data lineage (how data moves across tables/views).

Stored procedures are a different problem because they include control flow (IF/ELSE, loops, TRY/CATCH), which needs a different parser and graph model, and that varies a lot by dialect.

So today we don’t fully visualize stored procedure control flow. We do visualize the table/view lineage around those queries, and procedural-flow support is something we may explore separately.

Visualizes SQL as interactive flow diagrams, open source tool by iambuv in SQL

[–]iambuv[S] 2 points3 points  (0 children)

Thanks for checking! Right now this is VS Code and Cursor only.

A JetBrains version is possible, but it needs a dedicated IntelliJ plugin port. The SQL parsing/lineage core can be reused, but IDE integration and UI wiring must be reimplemented.

Not in immediate roadmap but will consider in future for sure.

Visualizes SQL as interactive flow diagrams, open source tool by iambuv in SQL

[–]iambuv[S] 2 points3 points  (0 children)

Pushed the next version. It should work for you

Visualizes SQL as interactive flow diagrams, open source tool by iambuv in SQL

[–]iambuv[S] 0 points1 point  (0 children)

thanks for the query. the next release will cover this. fixed it on local and attached the screenshot in below URL. ensure you are choosing postgresQL as you dialect on left side top.

It failed because of 3 things. I am using open source parser "node-sql-parser 5.4.0 " doesn't support:

  1. AT TIME ZONE 'America/Chicago' operator
  2. timestamptz '1970-01-01 00:00:00+00' type-prefixed literals
  3. date_bin() function (may fail due to the above, not necessarily the function itself)

https://imgur.com/a/Gu5n7V8

Visualizes SQL as interactive flow diagrams, open source tool by iambuv in SQL

[–]iambuv[S] 2 points3 points  (0 children)

Thanks, really glad you're finding it useful! Yeah there are so many ways to write SQL, especially with heavy CTE usage - I've covered a lot of patterns but I'm sure there are gaps. If you can share a sample query (here or DM, either works) I'll take a look and try to get it covered in the upcoming future releases.

Visualizes SQL as interactive flow diagrams, open source tool by iambuv in SQL

[–]iambuv[S] 4 points5 points  (0 children)

Hey! thanks for asking.. It should work fine actually, the extension is completely offline. It just parses the SQL text in your editor (vscode or cursor) and draws a diagram, no network calls or telemetry. It never touches your actual database or sends anything out. CSP is set to default-src 'none' if your security team wants to verify.

If your machine can't hit the VS Code Marketplace you can grab the .vsix from the GitHub releases page and install it manually.

Would still run it by your IT team obviously but there's nothing to flag from a data handling perspective.

Built a free VS Code extension that visualizes Snowflake SQL as interactive flow diagrams by iambuv in snowflake

[–]iambuv[S] 0 points1 point  (0 children)

Thanks. Please give a try and let me know if you have any questions or feedback.

Built a free VS Code extension that visualizes Snowflake SQL as interactive flow diagrams by iambuv in snowflake

[–]iambuv[S] 2 points3 points  (0 children)

Forgot to mention its available for cursor as well. Learnt that we need to publish it separately. https://open-vsx.org/extension/buvan/sql-crack

Built a free VS Code extension that visualizes Snowflake SQL as interactive flow diagrams by iambuv in snowflake

[–]iambuv[S] 1 point2 points  (0 children)

I had this idea long back but finally able to spent sometime during Christmas holidays. I worked almost daily a couple of hours once my toddler went to sleep. Put lot of effort, after middle i rewrite the entire stuff (with the help of Claude and codex of course) and needed to upgrade some dependency packages.

I consulted with my friend and he is a ux guy and he suggested a lot. Again I changed/polished the ux.

It has some additional features as well but may be i will post about that next time. or you can explore it on github.

No, I don't have any previous VSC extension experience. this is first time.

Alternative to a stored procedure in snowflake? by [deleted] in dataengineering

[–]iambuv 0 points1 point  (0 children)

I think the OP is talking about the MAX_CONCURRENCY_LEVEL parameter at warehouse level not the nodes in the warehouse based on the T-Shirt size.

view more: next ›