What is a .SQLite file?
SQLite is a complete database stored in a single file. Used inside countless apps, phones and browsers.
- Did you know
- SQLite was created by D. Richard Hipp in 2000 and is the most widely deployed database in the world.
- SQLite is released into the public domain, with effectively no copyright restrictions on its use.
- Analyser spots a .SQLite file by its signature bytes
53 51 4C 69- the start of "SQLite format 3".
- 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
- .SQLite 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 .SQLite file
- Drag a .SQLite 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
- .SQLite3 · .DB · .DB3 · .MDB · .ACCDB · .SQL · .SQLite-WAL · .SQLite-SHM · .DB-WAL · .DB-SHM. See all supported file types.