SQLite viewer
To open a SQLite file, drop it in the box below. It opens straight away, even with no extension or the wrong one. Your browser opens it on your device: nothing is uploaded.
What you see
| SQLite in the viewer | |
|---|---|
| Opened | Read-only, in memory, by SQLite itself compiled for the browser |
| Tables | Up to a million rows shown; the rest are counted |
| Query | One SELECT, WITH or read-only PRAGMA, up to 100,000 rows, with Stop |
| Size | Databases up to 400 MB |
| Files with no extension | Opened from their bytes (SQLite format 3) |
| Extensions | .sqlite, .db, .sqlite3, .db3, .s3db, .sl3 |
| Upload | None: opened on your device |
What is a SQLite file?
SQLite is a whole database in one file: tables, views, indexes and triggers. Phones, browsers and many desktop apps keep their data in it, often named .db or .sqlite3.
Every table and view down the side, with its row count; the one you pick opens as a table you can sort, filter and search. Schema shows the CREATE statements, and Query runs a read-only SELECT of your own. Details lists the page size, the text encoding and the SQLite version that last wrote it.
How to open a SQLite file
- Add your SQLite. Drop the file in the box, choose it or paste it.
- Look at it. Every table and view down the side, with its row count; the one you pick opens as a table you can sort, filter and search. Schema shows the CREATE statements, and Query runs a read-only SELECT of your own. Details lists the page size, the text encoding and the SQLite version that last wrote it.
- Take it further. Open in hands it, in a new tab, to File converter.
Questions
Drop it here. If it is an SQLite database, which most .db files are, its tables open in the page, read from the file on your device.
No. The file is opened read-only in memory, queries that write are refused before they run, and the original file is never touched.
Some apps keep recent changes in a separate -wal file beside the database. Only the main file is read, so changes still in that file are not shown; Details says when a database uses one.
No. The viewer runs in your browser and opens the file on your device. Nothing is sent anywhere.