u/Ariel_Turgeman

I kept running into MySQL queries where the final result surprised me, but it was hard to understand exactly which clause changed the data in that way.

Complex queries can change the result in a lot of different ways and once they get bigger it becomes harder to reason about them step by step.

I ended up building a small VS Code extension for myself to walk through queries stage by stage and inspect the intermediate result after each step. It helped me a lot so maybe it’ll be useful to some of you too.

Here is the link:
https://marketplace.visualstudio.com/items?itemName=arieldev.sql-visual-debugger&ssr=false