Sample SQLite Database Download — Free Test Files
Download free sample database files in SQLite format — 8KB to 50MB with multi-table, with-indexes, and empty-schema variants. Use these SQLite db example files for mobile app development, testing ORM libraries (Prisma, Drizzle, SQLAlchemy), and database browser tools testing (DB Browser for SQLite, TablePlus).
Use cases for sample SQLite files
- Testing ORM connection and query execution (Prisma, Drizzle, SQLAlchemy)
- Verifying SQLite browser tools (DB Browser for SQLite, TablePlus)
- Testing database migration and schema diffing tools
- Benchmarking SQLite read/write performance at various sizes
- Testing mobile app database handling (iOS Core Data, Android Room)
- Validating backup/restore and database file import workflows
SQLite vs PostgreSQL vs MySQL
| Feature | SQLite | PostgreSQL | MySQL |
|---|---|---|---|
| Architecture | Embedded (single file) | Client-server | Client-server |
| Setup required | None (zero-config) | Install + configure | Install + configure |
| Concurrent writers | 1 (file lock) | Unlimited (MVCC) | Unlimited (InnoDB) |
| Max database size | 281 TB | Unlimited | Unlimited |
| Best for | Mobile, desktop, embedded, dev | Production web apps | WordPress, legacy apps |
How to open and query SQLite files
# CLI (built into macOS/Linux, install on Windows)
sqlite3 database.sqlite
sqlite3 database.sqlite "SELECT * FROM users LIMIT 10;"
sqlite3 database.sqlite ".tables"
sqlite3 database.sqlite ".schema users"
# Node.js (better-sqlite3 — synchronous, fast)
import Database from 'better-sqlite3';
const db = new Database('database.sqlite');
const users = db.prepare('SELECT * FROM users').all();
# Python (built-in — no install needed)
import sqlite3
conn = sqlite3.connect('database.sqlite')
cursor = conn.execute('SELECT * FROM users')
rows = cursor.fetchall()
# GUI tools
# DB Browser for SQLite (free, cross-platform)
# TablePlus, DBeaver, DataGripWho uses SQLite?
SQLite is the most deployed database engine in the world — embedded in every iPhone, Android device, Mac, Windows 10+, every major web browser (Chrome, Firefox, Safari), Skype, iTunes, Dropbox, and many more. It's also increasingly used for web backends:
- Turso / libSQL — distributed SQLite for edge computing
- Litestream — streaming SQLite replication to S3
- LiteFS — distributed SQLite by Fly.io
- Cloudflare D1 — serverless SQLite at the edge
- Rails 8 — default database for new Rails projects
Technical specifications
| Full name | SQLite (Structured Query Lite) |
| Extensions | .sqlite, .db, .sqlite3 |
| MIME type | application/x-sqlite3 |
| Architecture | Embedded, serverless, zero-config |
| Max file size | 281 TB (theoretical) |
| Page size | 512B to 65536B (default 4096) |
| License | Public domain |
| Created by | D. Richard Hipp (2000) |
Frequently Asked Questions
Other data formats
Related reading
Mocking REST APIs with JSON Fixtures
Fast frontend iteration without a backend. MSW, json-server, and sample fixtures for users, products, and nested objects. Copy-paste examples.
Sample JSON Data for API Testing and Mocking
Free sample JSON files for testing REST APIs. Users, products, nested objects, GeoJSON, and API response wrappers with code examples.
Seeding Test Databases with Sample Data — SQL, JSON, CSV
How to seed development and staging databases using sample SQL dumps, JSON files, and CSV imports from TrueFileSize. Covers PostgreSQL, MySQL, SQLite, MongoDB, and Prisma.