u/No-Lettuce-1655

I built a SQL workspace inside VS Code — saved queries, version history, data compare, session monitor

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:

https://preview.redd.it/sm6kk9ajup2h1.png?width=1917&format=png&auto=webp&s=618a5ecefc8c3ebaa74a64492744e7c693128f1f

reddit.com
u/No-Lettuce-1655 — 1 day ago
▲ 1 r/SQL

I built a SQL workspace inside VS Code — saved queries, version history, data compare, session monitor

https://preview.redd.it/z4pqqtxbxs2h1.jpg?width=1917&format=pjpg&auto=webp&s=a9c51a8930ad3f3eca0f4d2f9392ad3d87276090

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 stage, so I’d really appreciate feedback:
What features are missing?
What would stop you from using it?
What DB workflow annoys you the most today?

​

reddit.com
u/No-Lettuce-1655 — 1 day ago