gitwtfhub

wtf is vscode-sqltools?

fieldju/vscode-sqltools — explained in plain English

Analysis updated 2026-07-17 · repo last pushed 2020-10-04

Audience · developerComplexity · 2/5DormantSetup · easy

TL;DR

A VSCode extension that lets you browse database tables, write and run SQL queries, and manage query history without leaving your code editor.

Mindmap

mindmap
  root((repo))
    What it does
      Database sidebar
      Run SQL queries
      Format SQL
    Tech stack
      VSCode
      SQL
    Use cases
      Explore datasets
      Test queries while coding
      Save bookmarked queries
    Audience
      Backend developers
      Data analysts
    Notable
      Supports PostgreSQL MySQL SQLite
      Community plugins for more DBs

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

Why would anyone build with this?

REASON 1

Browse a database's tables and structure directly in a VSCode sidebar.

REASON 2

Write, run, and format SQL queries without switching to a separate GUI tool.

REASON 3

Save frequently-used queries as bookmarks and search past query history.

REASON 4

Generate INSERT statements to quickly add new records to a table.

What's in the stack?

VSCodeSQL

How it stacks up

fieldju/vscode-sqltools0verflowme/alarm-clock0xhassaan/nn-from-scratch
Stars0
LanguageCSSPython
Last pushed2020-10-042022-10-03
MaintenanceDormantDormant
Setup difficultyeasyeasymoderate
Complexity2/52/54/5
Audiencedevelopervibe coderdeveloper

Figures from each repo's GitHub metadata at analysis time.

How do you spin it up?

Difficulty · easy Time to first run · 5min

Install from the VSCode marketplace and connect to a supported database with connection credentials.

Wtf does this do

This is a plugin for Visual Studio Code that lets you manage databases without leaving your code editor. Instead of switching between your text editor and a separate database tool, you can browse tables, write and run SQL queries, format code, and keep a history of your work, all built into VSCode. The extension connects to your database and shows you its structure in a sidebar, similar to how a file explorer works. You can write SQL queries in the editor, run them with a click, and see results instantly. It also includes handy features like auto-formatting to clean up messy SQL code, bookmarks to save frequently-used queries, and a search history so you can find queries you've run before. If you're generating new records, it can even help you write the INSERT statements. The tool supports most major databases, PostgreSQL, MySQL, MariaDB, SQLite, Microsoft SQL Server, and AWS Redshift all work out of the box. A few less common databases like InterSystems IRIS and SAP HANA are supported through community-maintained plugins. This breadth means whether you're working with a small local database or a cloud data warehouse, there's a good chance it'll work. Anyone who regularly writes SQL, backend developers, data analysts, DBAs, would find this useful. A developer might use it to quickly test a query while building a feature, or a data analyst might use it to explore a dataset without context-switching to a separate GUI tool. The project is open source and actively maintained, with extensive documentation available online.

Yoink these prompts

Prompt 1
Show me how to connect vscode-sqltools to a PostgreSQL database.
Prompt 2
Write a SQL query in VSCode using sqltools to explore a dataset and save it as a bookmark.
Prompt 3
Explain how to auto-format messy SQL code with this extension.
Prompt 4
Help me generate INSERT statements for a table using vscode-sqltools.

Frequently asked questions

wtf is vscode-sqltools?

A VSCode extension that lets you browse database tables, write and run SQL queries, and manage query history without leaving your code editor.

Is vscode-sqltools actively maintained?

Dormant — no commits in 2+ years (last push 2020-10-04).

How hard is vscode-sqltools to set up?

Setup difficulty is rated easy, with roughly 5min to a first successful run.

Who is vscode-sqltools for?

Mainly developer.

View the repo → Decode another repo

This repo across BitVibe Labs

Don't trust strangers blindly. Verify against the repo.