Menu

Post image 1
Post image 2
1 / 2
0

I built a VS Code extension to debug MySQL queries step by step

DEV Community·Ariel·about 1 month ago
#nRl6hPUB
#sql#vscode#database#mysql#query#final
Reading 0:00
15s threshold

Ariel

I kept running into SQL queries where the final result looked surprising, but it was hard to understand exactly which part of the query changed the data in that way.

When a query gets larger, reasoning about it from the final output alone becomes annoying. I wanted an easier way to see how the data changed as the query moved forward.

So I built SQL Visual Debugger, a VS Code extension that lets me step through supported MySQL SELECT queries clause by clause and inspect the intermediate result after each stage.

Instead of only seeing the final output, I can see how the rows change throughout the query.

Right now the extension is focused on MySQL and supported SELECT-style query flows.

You can try it here:
https://marketplace.visualstudio.com/items?itemName=arieldev.sql-visual-debugger

Read More