Back
SQLite Viewer (Local)
SQLiteファイルをローカルで閲覧し、SELECTクエリ結果をCSV/JSONで出力できます。
最大 20MB / ローカル処理のみ
Loaded DB
No file loaded
Detected tables: 0
Query Result
クエリ実行後に結果を表示します。
Security Guardrails
- ローカル処理のみ（SQLiteファイルはアップロードしません）
- SELECT/WITH のみ実行可能（更新系SQLは拒否）
- 結果表示は最大 2000 行に制限
- ファイルサイズ上限 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;