Nifty SQLite
Browse and query SQLite databases: tables and views in the side bar, a fast grid for any table, SQL queries with results, and export to CSV or JSON, with no native modules.
Maintained. No sign-in. No telemetry. Works in VS Code, Cursor, Windsurf, VSCodium and other editors that use Open VSX.
Features
- Open a database like a file.
.sqlite, .sqlite3 and .db3 files open straight into the viewer; .db files via Open With… or the Explorer's right-click menu. Tables and views are listed on the left with their columns. Click one to see its rows.
- Query with SQL. Type any query and press Ctrl+Enter. Results are paged, so huge tables stay fast; the total row count is shown, and clicking a column header sorts by it.
- Run SQL from your editor. In a
.sql file, Ctrl+Enter (or the ▶ button) runs the selection or the whole file on a database. It asks which one the first time and remembers it for that file.
- Safe by default. Browsing can never change a database: statements that write (INSERT, UPDATE, CREATE…) are refused unless you turn on
nifty.sqlite.allowWrites. With it on, changes are saved to the file right away.
- Export any result to CSV or JSON, sorted as shown.
- No native modules. SQLite runs as WebAssembly (sql.js), so it works the same on Windows, macOS, Linux, remote hosts, and in Cursor, Windsurf and VSCodium. There's nothing to compile or install.
- Viewers reload when the database changes on disk. You're warned when a write-ahead log (
-wal file) holds changes that aren't in the main file yet.
- Works in the browser on vscode.dev and github.dev.
Commands
| Command |
What it does |
Nifty SQLite: Open Database |
Pick a database in the workspace, or browse for one |
Nifty SQLite: Run Query on Database |
Run the selected SQL, or the whole .sql file, on a database (Ctrl+Enter in .sql files) |
Settings
| Setting |
Default |
What it does |
nifty.sqlite.allowWrites |
false |
Allow statements that change the database; changes are saved immediately |
nifty.sqlite.pageSize |
500 |
Rows per page in the viewer |
nifty.sqlite.maxSizeMB |
512 |
Largest database to open (it's loaded into memory) |
Install
- VS Code: search for "Nifty SQLite" in the Extensions view, or install from the Visual Studio Marketplace.
- Cursor, Windsurf, VSCodium, Kiro, Antigravity: install from Open VSX.
Privacy
This extension collects no telemetry and needs no account.
- Nifty Data Viewer: CSV & Parquet Viewer with SQL: Open CSV, Parquet and JSON files as a fast table and query them with SQL, powered by DuckDB. Sort, page through millions of rows, and export to CSV, Parquet or JSON. (Open VSX)
- Nifty Spreadsheet Viewer: XLSX, XLS & ODS: Open Excel, OpenDocument and other spreadsheets in a fast read-only grid with sheet tabs, formulas, search and CSV export, and compare two workbooks as a diff. (Open VSX)
- Nifty Data Pack: 9 Nifty extensions for working with JSON, YAML, XML, CSV, SQL and spreadsheets: JSON, YAML, XML, SQL, Data Viewer, SQLite, Spreadsheet Viewer, Paste JSON as Code, Mermaid. (Open VSX)
- Nifty SQL: SQL Formatter for 20 Dialects: Format SQL in 20 dialects, including dbt and Jinja templates, with your team's settings. (Open VSX)
- Nifty JSON: Formatter, Validator & JSONPath: Format, minify, sort keys, query with JSONPath, copy paths, generate TypeScript types, and browse huge JSON files in a fast tree view. (Open VSX)
- Nifty Notebook Servers: Kernels, Sessions & Files: Manage Jupyter servers from the side bar: see kernels and sessions, shut down, restart or interrupt kernels, and browse, open and edit the server's files directly. (Open VSX)
See all 100+ Nifty extensions and web tools at https://getnifty.dev
| |
