Guide

THE TOOLBOX / DATA & STORAGE UTILITIES

Inspect SQLite databases,
100% locally via WebAssembly.

Open .db and .sqlite3 files right in your browser, run SELECT and PRAGMA queries, sort and filter rows, and export CSV or JSON with zero uploads.

Drop a SQLite database (.db, .sqlite, .sqlite3) or click to browse

Runs 100% locally via sql.js WebAssembly in a background worker—your database never leaves this browser.

SQL Query Runner

Drop or select a local SQLite 3 database (.db, .sqlite, .sqlite3) up to 10 MiB.

Query Results

Load a local SQLite 3 database above and click Run Query to browse tables and export rows.

ESSENTIAL SQLITE COMMANDS

Handy PRAGMA & schema queries for exploring any .db file.

QueryWhat It Shows
SELECT name FROM sqlite_schema WHERE type='table';All user-defined tables in the database
PRAGMA table_info('users');Column names, types, primary keys, and defaults
PRAGMA integrity_check;Verifies B-tree and index integrity

Frequently Asked Questions

Does this SQLite viewer upload my database file to a server?

No. Your .db or .sqlite file is opened and queried 100% locally inside your browser using sql.js WebAssembly inside an isolated Web Worker. Zero bytes leave your device.

Can I sort columns, filter rows, and export query results?

Yes. Click any column header to sort ascending or descending, type into the filter box to search across all columns, and export matching rows as CSV or JSON.

Will running queries modify or corrupt my local .db file?

No. Every query runs against an ephemeral in-memory copy of your database, so your original file on disk is never altered.

What are the database size and row limits?

Files up to 10 MiB are supported in browser memory, with results capped at 1,000 rows per query and a 10-second timeout to keep the tab responsive.

How do I list all tables inside an unfamiliar SQLite file?

Click the default "Tables & Views" template or run SELECT name FROM sqlite_schema WHERE type='table'; to inspect every table immediately.