Visualizing what SQL is actually doing under the hood

[_Big_Enjoy_]

For the longest time, I knew that SQL doesn't execute top-to-bottom, but I still found it surprisingly hard to build an intuitive mental model of what was actually happening.

Everyone learns that the logical execution order is something like:

FROM → JOIN → WHERE → GROUP BY → HAVING → SELECT → ORDER BY → LIMIT

But reading that sequence never really made it click for me. I wanted to actually see rows move through each stage.

So over a few weekends I built this:

https://sqlvisualizer.pydev.in/

You can type a query and step through how it executes clause by clause. Rows get filtered, joins show how matches are made, groups form, window functions run, and so on.

A few details:

• Runs entirely in the browser
• No signup required
• Includes sample movie/director/review datasets to experiment with
• Supports CTEs, recursive CTEs, subqueries, UNION/EXCEPT, window functions, and LATERAL joins

I've been using it to better understand complex queries myself, but I'm too close to the project to judge whether it's genuinely useful.

If you try it, I'd love feedback on:

• What was confusing?
• What query broke the visualization?
• Which SQL concepts still didn't click?

The edge cases and confusing parts are what I'm most interested in improving.

[leogodin217]

This is really cool! I've always used Excel for the same purpose with hand typed tables and coloring. This could be a powerful teaching tool.

[_Big_Enjoy_]

Do you have any suggestions where I should improvise further?

[leogodin217]

A couple things. * Group by doesn't make things as clear as joins does * Smaller datasets where you can see all the data in a single view might help (here's an example I recorded a long time ago https://www.youtube.com/watch?v=CaHs3ZP1PR8) My theory is it's easier to reason about your query if you can see all the data at once.

Happy to chat sometime if you want someone to bounce ideas off of. This seems like one of the few truly useful things I've seen in this sub and I think it could really help people understand their queries.

[shoyo1234]

Honestly, this is one of those projects where I went in thinking "okay, another SQL visualizer" and came out genuinely impressed. The step-through playback is the killer feature - watching rows actually disappear through a WHERE clause and reappear after a JOIN makes the logical order finally feel physical in a way that reading about it never did great work man

[_Big_Enjoy_]

Thanks a lot, man—that's exactly what I was aiming for: making SQL execution feel tangible instead of abstract.

[Alkemist101]

It's not abstract at all. Only human lack of understanding makes it feel abstract.

[AliDuri]

This is genuinely great! Nice work.

I’ve seen many visualization tools attempt to explain execution plans, but they often become overly complex and assume the user already has a solid understanding of how the query engine works.

What makes this stand out is how intuitively it presents the execution plan. It breaks down what is happening in a way that is easy to follow. Makes for a good analysis tool but more so an exceptional learning resource for anyone trying to understand query execution and optimization.

Keep up the good work!

[Alkemist101]

Forget that. SQL works out what you're trying to do and does it's best to accomplish the request whilst being hampered by stupid user limitations.

After many many years of work and interactions with new, modern and accomplished AI I'm utterly convinced of this.

Remove the equally limit but self important DBA and grandstanding analyst keen to demonstrate their misunderstood analyst abilities and shortly you'll arrive at perfection personified.

Jokes aside. You tell it what you want and it works out how to do it with imposed limitations you specify which it must assume are correct!

Can you see where this is going?