Database Editor for VS Code

A fast, lightweight SQLite database editor built directly into VS Code. Browse tables, edit data, run queries, and manage your database schema — all without leaving the editor.

Features

• Open any SQLite file — Supports .db, .db3, .sqlite, .sqlite3, .sdb, .s3db, and .gpkg files
• Browse database structure — Tables, views, indexes, triggers, columns, primary and foreign keys in a clean sidebar
• Paged data grid — Sort, filter, and paginate through table data with per-column search
• Inline editing — Click any cell to edit its value, add new rows, or delete existing ones
• Image preview — BLOB columns with PNG/JPEG/GIF/WebP images render as thumbnails inline
• Pin rows & columns — Pin important columns to the left and mark rows for easy reference
• VS Code save integration — Edits are tracked and saved using the normal Ctrl+S / Cmd+S flow with undo/redo support
• Schema management — Create, rename, and drop tables; add and remove columns
• SQL query tab — Run read-only SQL queries with a full result grid
• Export — Export visible rows as CSV, or dump schema and table data as SQL
• Pure client-side — Powered by sql.js (SQLite compiled to WebAssembly) — no native dependencies

Usage

1. Open any SQLite database file (.db, .sqlite, etc.) in VS Code.
2. The custom editor launches automatically — browse tables in the sidebar.
3. Click a table to view its data in the paged grid.
4. Click any cell to edit its value, or use the Actions column to add/delete rows.
5. Press Ctrl+S (Cmd+S on macOS) or click the Save button to persist changes.

GitHub Copilot integration

When GitHub Copilot Chat is installed, use @sqlite or the “Chat with SQLite Database” editor action to work with the SQLite database currently open in the editor. The integration keeps database access inside the extension host: Copilot can ask the extension for schema details, run capped read-only queries, and, when enabled, apply confirmed database changes through the same dirty/save/undo flow as manual edits.

Use it for tasks such as:

• Understanding a database — Ask what tables, views, columns, indexes, triggers, and foreign keys exist.
• Writing queries — Ask Copilot to draft SQL against the real schema instead of guessing table or column names.
• Inspecting data — Let Agent Mode run safe SELECT or WITH queries and return capped JSON results.
• Planning changes — Ask for schema or data changes, review the generated SQL, then decide whether to apply it.

The integration has two access modes:

• Read-only (ro) — The default. Copilot can list open databases, inspect schema, and run one safe read-only query at a time. It cannot run INSERT, UPDATE, DELETE, DDL, PRAGMA, ATTACH, VACUUM, or multi-statement scripts.
• Read/write (rw) — Enables the modification tool. Copilot can propose a single write or schema statement, but VS Code asks for confirmation before it runs. Confirmed changes update the custom document, mark it dirty, refresh the webview, and can be saved or undone normally.

Set databaseEditor.copilot.accessMode to rw only when you want Copilot to be able to make user-confirmed changes. Set databaseEditor.copilot.enable to false to hide the @sqlite participant and Agent Mode tools.

Requirements

• VS Code 1.125.0 or later
• No external dependencies — SQLite runs entirely in the webview via WebAssembly

Known Limitations

• Only SQLite databases are supported (other SQL databases planned for future releases)
• The SQL query tab only allows SELECT statements (data editing is done through the grid)

License

Apache 2.0 — see LICENSE for details.