Free SQLite sample, test and dummy files (.sqlite)
Self-contained, cross-platform SQLite 3 relational database files with normalized tables, foreign keys, and B-tree indexes. Download ready-to-query .sqlite fixtures for mobile app testing, Datasette/SQLite-Wasm demos, and backup-restore verification.
Quick facts: .sqlite format
| Extension | .sqlite |
|---|---|
| Full name | SQLite 3 Relational Database File |
| MIME type | application/vnd.sqlite3 |
| Category | Database |
| Compression / Encoding | Lossless B-tree paged relational database (4,096-byte pages) |
| Magic bytes (signature) | 53 51 4C 69 74 65 20 66 6F 72 6D 61 74 20 33 00 ('SQLite format 3\0') |
| Specification | SQLite3 Stable Cross-Platform Database File Format (Library of Congress LOC Recommended Format) |
Download sample SQLite files
Every file below is a spec-compliant .sqlite fixture generated deterministically for automated and manual testing. Verify the exact byte count and SHA-256 digest after downloading, or open the custom-size file generator to build additional fixtures in your browser.
| File | Size | Variant & contents | SHA-256 checksum | Download |
|---|---|---|---|---|
| sample-sqlite-company.sqlite | 16.00 KB16,384 bytes | SQLite 3 database with departments, employees (50 rows), and projects tables | 07050d03601f60320b31679ae971529596d7395e76ef31ccfa59afbb1f8a82da |
Download SQLite |
| sample-sqlite-inventory.sqlite | 32.00 KB32,768 bytes | SQLite 3 database with indexed products (250 rows) and stock_ledger tables | 56cbada043585a18ed8592874367d332b3409380c377b92ed6677109e70a13f3 |
Download SQLite |
What is a SQLite file?
SQLite is the world's most widely deployed embedded relational database engine. Unlike client-server database systems such as PostgreSQL or MySQL, an entire SQLite database—including its schema catalog (sqlite_schema), table B-trees, index B-trees, and freelist pages—is stored in a single ordinary disk file with a well-defined, backwards-compatible binary format that has remained stable since SQLite 3.0.0 in 2004.
Every SQLite 3 file begins with a 100-byte database header on Page 1. The first 16 bytes are the null-terminated ASCII string SQLite format 3\0 (hexadecimal 53 51 4C 69 74 65 20 66 6F 72 6D 61 74 20 33 00). Bytes 16–17 store the database page size as a 2-byte big-endian integer (0x1000 = 4,096 bytes in our samples), followed by file format write/read version numbers, change counters, and UTF-8 text encoding flags.
How to open a .sqlite file on Windows, macOS, Linux, Android and iOS
- CLI across Windows, macOS, and Linux: Run
sqlite3 sample-sqlite-company.sqlite ".tables"orsqlite3 sample-sqlite-company.sqlite "SELECT * FROM records LIMIT 5;". - Desktop GUI Tools: DB Browser for SQLite, DBeaver, TablePlus, DataGrip, and Beekeeper Studio.
- Python and Node.js: Python's built-in
import sqlite3module or Node'snode:sqlite/better-sqlite3. - In-Browser WebAssembly: Official
sqlite-wasmorsql.jsloads these files directly into an in-memory virtual filesystem.
What to test with SQLite sample files
- Page-size alignment and corruption checks: Because a SQLite database is an array of fixed-size 4,096-byte pages, any valid file size is an exact multiple of 4,096 bytes. Test whether your backup uploader detects partial transfers by running
PRAGMA integrity_check;after upload. - Foreign key and index inspection: Our sample databases include two tables (
departmentsandrecords) linked by aFOREIGN KEY(dept_id)constraint and an indexidx_records_dept. Use them to test schema introspection tools and ORM migrations. - Read-only vs. WAL journal handling: Verify that your application can open a downloaded
.sqlitefile in immutable or read-only mode without requiring-walor-shmshared-memory files.
Common problems when handling .sqlite files
A common security mistake in web applications that accept user-uploaded SQLite files is running queries against the uploaded file without disabling loadable extensions or checking for maliciously crafted sqlite_schema rootpage pointers. Always open untrusted SQLite fixtures with defensive flags enabled and run PRAGMA quick_check; before querying.
Need to convert or inspect a file right away? Use ConvertFerry Online SQL & SQLite Query Workbench or drop any local file into our in-browser Magic-Byte File Inspector.
Related formats and testing resources
Frequently asked questions
- What tables and columns are inside these sample SQLite files?
- Each file contains two tables: departments (dept_id INTEGER PRIMARY KEY, dept_name TEXT, budget_usd INTEGER) with 4 rows, and records (id INTEGER PRIMARY KEY, code TEXT, label TEXT, dept_id INTEGER, amount REAL, active INTEGER) with 50 or 250 rows, plus index idx_records_dept.
- Are .sqlite, .db, and .sqlite3 files the same format?
- Yes. All three file extensions refer to the exact same SQLite 3 binary format starting with the 16-byte header 'SQLite format 3\0'. You can rename any .sqlite sample to .db or .sqlite3 if your application filters by extension.
- What is the official IANA MIME type for SQLite 3 files?
- IANA registers application/vnd.sqlite3 as the official media type, with application/x-sqlite3 frequently used by older libraries.
- Are SQLite database files big-endian or little-endian?
- The SQLite 3 file format is portable across architectures: header integers and B-tree page structures are stored in big-endian byte order, so the exact same file works on x86_64, ARM64 (Apple Silicon / Android), and RISC-V.