Sample SQLite database file — free download
A genuinely valid SQLite 3 database, written byte by byte from source so the file is reproducible. It passes PRAGMA integrity_check and ordinary SELECT queries work.
2 ready-made SQLite test files
| File | Size | What it catches | |
|---|---|---|---|
| truncated.sqlite | 5.9 KB | Error handling for a partially-uploaded or interrupted database transfer. The signature and header validate, so extension and magic-number checks both pass - only actually opening the file reveals the damage ("database disk image is malformed"). | download |
| users.sqlite | 8.0 KB | Database import, upload and inspection paths. Opens in sqlite3, DB Browser, Python and any SQLite driver; PRAGMA integrity_check returns ok and ordinary SELECT/WHERE queries work. Also exercises magic-number detection: the file starts with the ASCII string "SQLite format 3". | download |
Every file is generated from source — no third-party copyright — and each has its own page with a published SHA-256 you can verify after download.
Questions
Where can I download a sample SQLite database?
The .sqlite file below contains one table with ten rows. It opens in the sqlite3 CLI, DB Browser, Python and any SQLite driver.
How do I test corrupt database handling?
The truncated database has an intact 100-byte header but a cut-short body, so extension and magic-number checks both pass — only opening it reveals "database disk image is malformed".