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

  1. 1Load a `.db`/`.sqlite`/`.sqlite3` file.
  2. 2Click a table chip to auto-fill a preview query.
  3. 3Run a SELECT/WITH query.
  4. 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;

Related tools

CSV/TSV Batch Converter
Normalize CSV exports from query outputs.
CSV Inspector
Validate CSV shape after export.
JSON Shape Inspector
Inspect exported JSON structure quickly.

Workflows (kits)

Docs & Reporting Kit
Pair DB inspection with CSV/JSON/PDF reporting utilities.