SQLite Viewer
Open a SQLite database in your browser: list tables with row counts, browse rows, run SQL queries and export CSV or JSON.
Drop a database above to explore it here.
Tables & views
This database has no tables.
Pick a table on the left to browse its rows.
Schema
Run SQL
Edits run against an in-memory copy only — the file on your disk is never modified.
How to use the SQLite viewer
- Drop a
.sqlite,.dbor.db3file onto the box above — the engine is fetched once, then everything runs locally. - Pick a table on the left to page through its rows and read its
CREATE TABLEschema. - Write any
SELECTin the SQL box and press Run (or Ctrl/⌘ + Enter), then export the table or the result as CSV or JSON.
FAQ
Is my database uploaded?
No. The database is opened by a WebAssembly build of SQLite inside the page; the only network request is the engine itself from a CDN. Your data never leaves the browser tab.
Can I change the data?
You can run INSERT, UPDATE and DELETE, but they only affect the in-memory copy loaded from your file. The file on disk is never written to, and the changes disappear when you reload the page.
Which files work?
Any SQLite 3 database, whatever the extension — including the .db files shipped inside app backups, browser profiles and mobile exports. Encrypted (SQLCipher) databases cannot be opened.