What is a .SQLite3 file?
A .sqlite3 file is a SQLite database in a single file. Used inside countless apps and devices.
- Did you know
- The 3 in the extension refers to SQLite’s version 3 file format, introduced in 2004 and kept backwards compatible ever since.
- Hipp built SQLite while working on US Navy software, after a server database kept failing whenever its host went down.
- Every database in this format starts with the same 16-byte header - the text “SQLite format 3” followed by a null byte.
- What Analyser reads
- Open SQLite databases (.sqlite/.db/.sqlite3) and read their full schema in-browser - every table with its columns and row counts, views, indexes, triggers, the CREATE-statement DDL, and a sample of the largest table. Reads the WAL-mode sidecars too: the Write-Ahead Log (-wal) - page size, salts, frame and committed-transaction counts, and the pages it changed - and the shared-memory index (-shm) - valid frame count, database size and checkpoint progress. Also parses .sql dumps (dialect, tables, columns, INSERT counts) and identifies Microsoft Access (MDB, ACCDB).
- Depth of analysis
- .SQLite3 is an identification-grade format: Analyser recognises it from its bytes and decodes the header metadata it carries, rather than opening it in a full viewer. Formats that do get a full viewer are marked "Full" on the formats page.
- Open a .SQLite3 file
- Drag a .SQLite3 file onto the Analyser home page (or tap to pick one). It is identified entirely in your browser - nothing is uploaded, there is no account, and it works offline once installed.
- Related formats
- .SQLite · .DB · .DB3 · .MDB · .ACCDB · .SQL · .SQLite-WAL · .SQLite-SHM · .DB-WAL · .DB-SHM. See all supported file types.