# SQLite explorer for forensic databases

Open SQLite databases from phones, browsers and apps in the browser: tables, schema, row counts, row browsing, timestamp decoding, read-only SQL and CSV export. The database is read into browser memory and never uploaded. Interactive tool: https://digitalforensics.co.uk/tools/sqlite-explorer/ (offline copy available there, with its SHA-256).

## What it does not do

- Recover deleted records. Deleted data can survive in free pages and inside live pages, so a free page count of zero does not mean nothing was deleted.
- Merge a separate -wal file: recent changes may be missing.
- Open encrypted databases.

## Good practice

- Open a copy, never the original; match the SHA-256 shown with the original's hash.
- Rows appear in stored order, not necessarily event order.
- Quick check only: verify results with validated tools and record the method you used.

Built on sql.js 1.15.2 (MIT licence).

## Questions

### Is my database uploaded?

No. The file is read into your browser's memory and opened there by a copy of SQLite compiled to WebAssembly. Nothing is sent to this site or anyone else. Browser extensions and your own device are outside our control, so follow your organisation's rules for case data.

### Can it change the original file?

No. A web page cannot write back to a file you open this way, and the tool works on an in-memory copy. The query box accepts only read-only statements and keeps SQLite's query-only mode on, so your SQL is not used to change the data. Still work on a copy of the evidence, as you would with any tool.

### Does it recover deleted records?

No. It shows the live records only. Deleted records can survive in free pages and inside live pages, so even a database with no free pages may still hold deleted data that a specialist recovery tool can read.

### Why are some recent messages or visits missing?

If the database uses write-ahead logging, the newest changes may still be in a separate file ending in -wal, which this tool does not merge. The details panel says when a database is in WAL mode.

### How large a database can it open?

The whole file is loaded into memory, so it suits typical app databases up to a few hundred megabytes. It warns above 500 MB and refuses files over 1.5 GB.

### Can I rely on this for a report or court?

Treat it as a quick check, not validated forensic software. Verify important results with your own validated tools and record the method you used. Nothing here is legal advice.
