GQry

Universal database client for VS Code — MySQL / MariaDB, PostgreSQL, Microsoft SQL Server, and SQLite all in a single extension.

Browse schemas, run queries, edit rows in a paged grid, and import / export data — without leaving the editor.

Features

Multi-driver
- MySQL & MariaDB (mysql2)
- PostgreSQL (pg)
- Microsoft SQL Server (tedious)
- SQLite (better-sqlite3, optional — install separately if you need it)
Connection explorer — databases, schemas (Postgres / MS SQL), tables, views, columns, procedures, functions, triggers.
Query editor — Ctrl+Enter to run, Ctrl+Shift+Enter to run selection, Ctrl+E for EXPLAIN. Multiple result sets, syntax-aware paging.
Table editor — paged grid, inline edit (double-click), sort by column, filter via WHERE, insert / delete rows, view CREATE.
Import / Export — CSV, TSV, JSON, JSONL, SQL INSERTs.
Database dump — full schema + data dump to a single .sql file.
Encrypted password storage — VS Code SecretStorage.
SQL log — every executed statement, optionally persisted to ~/.gqry/sql-history.log.

Open the GQry view from the activity bar.
Click Add Connection…, pick the database type, fill in host/user/password.
Click the connection → it expands to databases → tables.
Double-click any table to open the data grid, or right-click → New SQL Query to open the editor.

Connection metadata lives at ~/.gqry/connections.json. Passwords are stored in VS Code's encrypted SecretStorage, never in the JSON file.

GQry bundles mysql2, pg, and tedious so MySQL / PostgreSQL / MS SQL Server work out of the box.

SQLite uses better-sqlite3 which contains a native binding. If you need SQLite support, run inside the extension folder:

npm install better-sqlite3

Run GQry: Install / Check Drivers from the command palette to see which drivers are loaded.

Command	Description
`GQry: Add Connection…`	Create a new connection
`GQry: Connect` / `Disconnect`	Open/close a server connection
`GQry: New SQL Query`	Open an SQL editor for the selected server/database
`GQry: Open Table`	Open the data grid for the selected table
`GQry: Create Database…`	Issue `CREATE DATABASE`
`GQry: Drop / Truncate / Rename Table`	Schema operations
`GQry: Export Table…`	Save table data as CSV/TSV/JSON/SQL
`GQry: Import Into Table…`	Bulk-insert from CSV/TSV/JSON
`GQry: Dump Database to SQL…`	Full schema+data dump
`GQry: Show SQL Log`	Open the Output channel

Setting	Default	Description
`gqry.pageSize`	100	Rows per page in the table viewer
`gqry.confirmDestructive`	true	Ask before DROP / TRUNCATE / DELETE
`gqry.queryTimeout`	60000	Query timeout (ms)
`gqry.connectionTimeout`	10000	Connect timeout (ms)
`gqry.poolSize`	4	Max concurrent connections per server
`gqry.sqlLog.enabled`	true	Log every statement to Output
`gqry.sqlLog.keepHistory`	false	Persist statements to ~/.gqry/sql-history.log

MIT