Back
SQLite Viewer (Local)
Browse SQLite files locally and export SELECT query results as CSV/JSON.
Max 20MB / local processing only
Loaded DB
No file loaded
Detected tables: 0
Query Result
Query result will appear after execution.
Security Guardrails
- Local processing only (SQLite files are not uploaded)
- SELECT/WITH only (write queries are rejected)
- Max 2000 rows displayed
- File size limit 20MB
SQLite Viewer (Local): Guide
- Intent
- Open a local SQLite database in your browser, run safe SELECT queries, and export result tables as CSV/JSON without uploading files.
- What it does
- Loads a SQLite file locally using WebAssembly, lists tables, executes SELECT/WITH queries, and exports the current result set.
- Key features
- Local DB load, Table list shortcuts, SELECT/WITH query runner, Query history controls, Failed-query retry, Paged + sortable result view, CSV/JSON export
- Privacy
- Runs locally in your browser. Database files are not uploaded.
- Best for
- Quickly inspecting SQLite files without installing desktop tools
- Support/debug workflows where you need a fast read-only data check
- Teams handling sensitive DB snapshots that must remain local
- Why this tool
- No setup beyond opening the page and selecting a DB file
- Read-only query guardrails reduce accidental destructive actions
- History and paging keep repetitive inspection faster
- One-click exports for ad-hoc reporting
How to use
- 1Load a `.db`/`.sqlite`/`.sqlite3` file.
- 2Click a table chip to auto-fill a preview query.
- 3Run a SELECT/WITH query.
- 4Export the result as CSV or JSON.
Common mistakes
- Trying to run UPDATE/DELETE/INSERT queries (read-only guard rejects non SELECT/WITH).
- Loading files that are not valid SQLite databases.
- Expecting full DB IDE features (this is an MVP viewer).
Examples
Browse table names
SELECT name
FROM sqlite_master
WHERE type='table'
ORDER BY name;
Inspect recent rows
SELECT *
FROM events
ORDER BY created_at DESC
LIMIT 100;