VS SQL Editor

Shipped · v0.0.1 MIT

Multi-engine SQL extension for VS Code — connect to PostgreSQL, MySQL, SQLite, PGlite, and ClickHouse without leaving your editor. Schema explorer, autocomplete, paginated results, and inline editing built in.

VS Code Marketplace ↗ GitHub ↗ Releases ↗

Install

The easiest way to install — search in VS Code or use the Quick Open command. Updates automatically.

# Quick Open (Ctrl+P / Cmd+P), then paste:
ext install cuongquachc88.vs-sql-editor

Or search VS SQL Editor in the Extensions panel · Open in Marketplace ↗

Download the packaged extension from GitHub Releases and install it directly into VS Code — no build step required.

# Download from GitHub Releases, then:
code --install-extension vs-sql-editor-0.0.1.vsix

Then reload VS Code and run SQL: Add Connection from the command palette.

Clone, build, and package the extension yourself. Requires Node ≥ 18 and npm.

git clone https://github.com/cuongquachc88/vs-sql-editor.git
cd vs-sql-editor
npm install
npx @vscode/vsce package
code --install-extension vs-sql-editor-0.0.1.vsix

Dev mode: press F5 in VS Code to launch the Extension Development Host.

Features

SQL editing, your way

Write SQL in the editor you already know. VS SQL Editor wires up connections, schema awareness, and a result grid — all without leaving VS Code.

5 Database Engines

PostgreSQL, MySQL, SQLite, PGlite (in-memory), and ClickHouse — one extension for all your SQL work.

Schema Explorer

Live tree view of all tables, columns, indexes, and foreign keys — always in sync with your database.

Schema-aware Autocomplete

Completions for table names, column names, and SQL keywords — scoped to your active connection.

Paginated Results

Large result sets paginated in a clean webview grid — no UI freeze, no memory blowout on big queries.

Inline Cell Editing

Edit result cells directly in the grid and push changes back — where the engine and primary key allow.

CSV / JSON Export

Export any result set to CSV or JSON in one click — ready to drop into a spreadsheet or pipeline.

OS Keychain Security

Passwords stored in VS Code's SecretStorage — backed by OS keychain. Never written to disk in plain text.

No Telemetry

Zero analytics, zero tracking, zero third-party calls. Connection profiles stored locally. What runs, stays local.

Engine Support

What works where

Engine	Connection	Inline edit	Read-only	Notes
PostgreSQL	Host/port + SSL	✓	—	Full driver support
MySQL	Host/port	✓	—	Full driver support
SQLite	File path	✓	—	File-based, no server
PGlite	In-memory / persist path	✓	—	PostgreSQL in WASM
ClickHouse	Host/port + HTTP	—	read-only	Append-oriented

Architecture

How it's built

EXTENSION LAYERS

Extension Host Node.js, manages DB connections

Driver Interface Unified DatabaseDriver abstraction

Webview Sandboxed result grid + typed messages

SecretStorage OS-keychain-backed credential store

Language Server Schema-aware SQL autocomplete

WORKFLOW

1

Add Connection

Run SQL: Add Connection from the command palette. Choose engine, enter credentials — saved to OS keychain.

2

Open a .sql file

Write your query in VS Code's native editor with schema-aware autocomplete.

3

Run Query

Click the Run Query CodeLens above your query or use the command palette.

4

Explore Results

Paginated grid appears in a webview panel. Edit cells inline, export to CSV or JSON.

Development

Build & test locally

SQLite and PGlite tests run without any external services. For PostgreSQL, MySQL, and ClickHouse, Docker Compose spins up the required databases.

npm run build Compile TypeScript via esbuild

npm test Run vitest suite (SQLite + PGlite)

npm run watch Incremental rebuild on file change

F5 in VS Code Launch Extension Development Host

docker compose up -d Start PostgreSQL, MySQL, ClickHouse

npx @vscode/vsce package Package as .vsix for distribution

VS SQL Editor

SQL editing, your way

What works where

How it's built

Build & test locally

Free. Open-source. No telemetry.