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 nameSQLite 3 Relational Database File
MIME typeapplication/vnd.sqlite3
CategoryDatabase
Compression / EncodingLossless 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')
SpecificationSQLite3 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.

SQLite sample files
FileSizeVariant & contentsSHA-256 checksumDownload
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

What to test with SQLite sample 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.