SQLite Database Viewer (.sqlite, .db)
Look inside a SQLite database from an app, a phone backup or a download without installing a database tool.
Use the tool
Why this tool exists
The page reads the file format directly: header, page size, text encoding, the schema table and the b-tree pages of every ordinary table, including cells that spill onto overflow pages. Columns are named from the CREATE TABLE statement and INTEGER PRIMARY KEY columns show the rowid. Results were compared with Python's sqlite3 on a database with 1,500 rows, big text values and blobs.
It is read-only and has no SQL engine. WITHOUT ROWID tables, virtual tables and index b-trees are listed but not read. Files are processed in memory, so very large databases may be slow.
The file is read in your browser and is not uploaded anywhere.
How to use it
- Choose a .sqlite, .sqlite3 or .db file.
- Set how many rows to show per table.
- Read the schema and sample rows.
- Use the CSV and SQL tools to query exported data.
Frequently asked questions
Is my database uploaded?
No. It is read in your browser.
Can I run SQL?
No, this is a viewer. Export tables and use the SQL-on-CSV tool for queries.
Why is a table not shown?
It may be WITHOUT ROWID or virtual, which this reader does not decode.
Is my data sent anywhere?
The file is read in your browser and is not uploaded anywhere.