SQLite Lens
SQLite Lens is a visual SQLite database editor for Visual Studio Code. Open any .db, .sqlite or .sqlite3 file directly in the editor — no external tools required.
Features
Visual table browser
Click any SQLite file in the explorer to open the visual editor. The left sidebar lists all tables; click one to load its data instantly.
SQL query editor
Write and execute any SQL statement directly from the editor. Press Ctrl+Enter to run. SELECT results are paginated (100 rows per page). INSERT / UPDATE / DELETE operations show the number of affected rows in the status bar.
Cell inspector panel
Click any cell to open the Inspector panel on the right side:
- Displays the full value in an editable textarea — ideal for long text fields.
- Foreign key detection: if the column references another table, the related record is shown automatically.
- NULL handling: toggle a checkbox to set a value to
NULL.
- Ctrl+Enter inside the textarea saves the change without losing focus.
Excel-like selection
- Click a cell to select it.
- Shift+Click or click and drag to select a rectangular range.
- Click a row number to select the entire row; drag to extend across multiple rows.
Copy to clipboard
Right-click any cell or selection:
| Option |
Description |
| Copy cell |
Single cell value |
| Copy row |
Tab-separated row values |
| Copy row (with header) |
Column names + row values |
| Copy selection |
Rectangular range, tab-separated |
| Copy selection (with header) |
Column names + range |
Ctrl+C copies the current selection. Ctrl+Shift+C includes the header row.
Right-click any table in the sidebar:
| Option |
Description |
| Rename table |
Inline rename via VS Code input box |
| Export as CSV |
Save table data as .csv |
| Export as JSON |
Save table data as .json |
| Export as SQL |
Save CREATE TABLE + INSERT statements |
Table structure inspector
When no cell is selected, the Inspector panel shows the table's DDL (CREATE TABLE statement) and a column list with type and constraint badges (PK, FK, NN, DF).
Results are paginated at 100 rows per page. The pager bar appears between the SQL editor and the results table whenever there is more than one page — for both table browsing and SQL queries.
Supported file extensions
.db · .sqlite · .sqlite3 · .db3 · .sdb
Keyboard shortcuts
| Shortcut |
Action |
Ctrl+Enter |
Execute SQL query |
Ctrl+Enter (in Inspector) |
Save cell value |
Ctrl+C |
Copy selection |
Ctrl+Shift+C |
Copy selection with header |
Escape |
Close context menu |
How it works
SQLite Lens uses sql.js — a WebAssembly port of SQLite — to read and write .db files entirely within the VS Code extension host. No native binaries, no external dependencies. Changes are written back to the original file immediately after each edit.
Limitations
- WITHOUT ROWID tables are displayed in read-only mode (cell editing requires
rowid).
- Very large databases (> several hundred MB) may load slowly due to the in-memory model used by sql.js.
- Undo/redo is not supported — each cell edit is saved directly to disk.
License
MIT
