A VS Code extension that opens SQLite database files (.db, .sqlite, .sqlite3) in a visual table editor.
Features
View — click any SQLite file in the Explorer; it opens as a data grid. Switch between tables with the dropdown.
Sort — click a column header to sort ascending; click again for descending.
Add — the + Add Row button opens a form with one field per column. Fields left empty on insert are omitted so SQLite applies column defaults / autoincrement. A NULL checkbox is available per field.
Edit — double-click a row, or use the pencil button. Changes are written to the file immediately on save.
Delete — the ✕ button on each row.
Filter — type in the filter box to search across all columns of the current table (case-insensitive, matches anywhere).
SQL query runner — the SQL button opens a panel; run any SQL (Ctrl+Enter). SELECT results show in a grid; mutations report rows modified and persist to the file.
Export — CSV / JSON buttons export the whole current table via a save dialog.
Refresh — reloads the database from disk (useful if another tool changed the file).
Pagination at 200 rows per page.
Works with WITHOUT ROWID tables (rows are addressed by primary key) and shows BLOBs as read-only markers.
How it works
The database is loaded with sql.js (SQLite compiled to WebAssembly) — no native binaries, works on any platform. Every insert/update/delete runs against the in-memory database and the full file is written back to disk immediately, so there is no separate "save" step.
Development
npm install
npm run compile
Press F5 in VS Code to launch an Extension Development Host, then open sample.db (regenerate it any time with node scripts/make-sample.js).
Run the logic test suite (no VS Code required):
node scripts/verify.js
Project layout
src/sqliteSession.ts — all database logic (open, list tables, paged/sorted reads, insert/update/delete, export). No VS Code dependency, tested by scripts/verify.js.
src/sqliteEditorProvider.ts — custom editor provider; bridges webview messages to the session and persists the file after each mutation.
media/main.js, media/style.css — the webview grid UI.
