Open SQLite files in your browser
The database inside your phone, your browser and most of your apps, kept in one file. Open one right here as a folder of its tables. Nothing leaves your device.
Or drop it anywhere on this page
What you'll see
Your database opens as a folder in the file list, its tables and views with their rows counted, and each table you pick opens in the grid.
- Every table and view in a folder • Rows counted
- Keys lead to the rows they point at
- Search • Every table at once
- Export • Save a table or the whole database
About SQLite
D. Richard Hipp wrote SQLite in 2000: a whole database in one file, with no server to run. It's now the most used database there is, and every phone keeps hundreds of them, for messages, history, photos and settings. Every SQLite 3 since 2004 still reads the files of the first one, and its makers plan to keep it so through 2050.
A file holds tables, views, indexes and triggers, each kept with the SQL that made it, in pages of 512 bytes to 64 KB. A column's type is only a hint, so any cell can hold text, a number, a BLOB or nothing. Many apps keep a log beside the file, its -wal, with the newest changes until SQLite folds them in.
Filepeek reads the file with its own build of SQLite 3.53, a page at a time, so a database of several gigabytes opens at once as a folder of its tables and views, each with its rows counted. It tells a database by its first bytes, whatever its name, and names the app it came from, like Chrome history, Messages or a Lightroom catalog. A key leads to the row it points at, Search looks in every table, and pictures and files kept in BLOBs open in their own viewers. Nothing is ever written to the file.
SQLite database
.sqlite • .sqlite3 • .db • .db3 • .s3db • .sl3
Format
- MIME type
- application/vnd.sqlite3
- Made by
- D. Richard Hipp
- Released
- 2000
Inside the file
- Tables
- Rows, by rowid or by primary key
- Schema
- The SQL of each table, view, index and trigger
- Pages
- 512 bytes to 64 KB each
- Text
- UTF-8, or UTF-16
Opens in every browser
No browser opens a SQLite file: they download it. Filepeek opens it as a folder of tables in Chrome, Edge, Firefox and Safari.
- YouChromeOpens through Filepeek
- YouEdgeOpens through Filepeek
- YouFirefoxOpens through Filepeek
- YouSafariOpens through Filepeek
Questions
How do I open a SQLite file without installing anything?
Drop it on this page or choose Peek an SQLite. Its tables and views show as a folder in the file list, each with its rows counted, and the one you pick opens as a grid.
Can I look inside an app's database, like chat.db or History?
Yes. Filepeek tells a SQLite file by its first bytes, so Messages' chat.db, a browser's History and files with no extension open too. Apps keep dates as numbers, like Apple's seconds since 2001, and a column's card shows them as dates when you pick how to read them.
What about the -wal file next to it?
It holds the newest changes, which the database file doesn't have yet. Drop both files together, or pick them both, and the tables show with those changes, as the app sees them. Without it, the file's details say what's missing.
Can I save a table, or the whole database?
Export saves a table as CSV, Excel, JSON, Parquet or SQL, with every row or only the rows you sorted and filtered. The same menu saves every table at once: as a ZIP of CSVs, one Excel workbook with a sheet for each table, a SQLite database or a SQL dump.
Is my file uploaded?
No. The database opens inside your browser and never leaves your device.