
I built a SQL workspace inside VS Code — saved queries, version history, data compare, session monitor
I got tired of switching between VS Code and a separate DB tool every few minutes, so I built SQLLab — a VS Code extension that puts a full SQL workspace inside the editor.
What it does:
- Connect to SQL Server, PostgreSQL, MySQL, Oracle, SQLite, DuckDB
- Saved query library with full-text search (search name, description, and the SQL itself)
- Every save creates a version — diff any two versions side by side
- Data Compare: run two queries against different DBs and see SAME/DIFFERENT per row and column
- Session Monitor: see blocked/active sessions, kill them from right-click
- Batch Run: run multiple saved queries in parallel, track status per script
- Parameterised SQL with Jinja-style
{{ variable }}substitution - Schema-aware autocomplete (tables, columns, PKs, indexes)
- Paginated results — no freezing on large datasets
Still early, so feedback on what's missing or broken is very welcome.
main screen:
u/No-Lettuce-1655 — 1 day ago