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).

sample-100kb.sqlite

92 KB

800 rows

Download

Verified file details

Filename: sample-100kb.sqlite
Exact size: 94,208 bytes
Displayed size: 92 KB
MIME type: application/octet-stream
Rows: 800
Tables: 1
Note: single-table
License: CC0 / Public Domain
Download URL: https://truefilesize.com/files/sqlite/sample-100kb.sqlite

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-500kb.sqlite

512 KB

3,000 rows

Download

Verified file details

Filename: sample-500kb.sqlite
Exact size: 524,288 bytes
Displayed size: 512 KB
MIME type: application/octet-stream
Rows: 3,000
Tables: 3
Indexes: 6
Note: multi-table
License: CC0 / Public Domain
Download URL: https://truefilesize.com/files/sqlite/sample-500kb.sqlite

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-1mb.sqlite

1.09 MB

7,500 rows

Download

Verified file details

Filename: sample-1mb.sqlite
Exact size: 1,146,880 bytes
Displayed size: 1.09 MB
MIME type: application/octet-stream
Rows: 7,500
Tables: 5
Indexes: 8
Note: with-indexes
License: CC0 / Public Domain
Download URL: https://truefilesize.com/files/sqlite/sample-1mb.sqlite

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-5mb.sqlite

4.41 MB

36,000 rows

Download

Verified file details

Filename: sample-5mb.sqlite
Exact size: 4,628,480 bytes
Displayed size: 4.41 MB
MIME type: application/octet-stream
Rows: 36,000
Tables: 8
Indexes: 8
Note: with-views
License: CC0 / Public Domain
Download URL: https://truefilesize.com/files/sqlite/sample-5mb.sqlite

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-10mb.sqlite

9.29 MB

80,000 rows

Download

Verified file details

Filename: sample-10mb.sqlite
Exact size: 9,744,384 bytes
Displayed size: 9.29 MB
MIME type: application/octet-stream
Rows: 80,000
Tables: 10
Indexes: 8
Note: full-schema
License: CC0 / Public Domain
Download URL: https://truefilesize.com/files/sqlite/sample-10mb.sqlite

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-50mb.sqlite

44.60 MB

396,000 rows

Download

Verified file details

Filename: sample-50mb.sqlite
Exact size: 46,764,032 bytes
Displayed size: 44.60 MB
MIME type: application/octet-stream
Rows: 396,000
Tables: 12
Indexes: 8
Note: stress-test
License: CC0 / Public Domain
Download URL: https://truefilesize.com/files/sqlite/sample-50mb.sqlite

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-empty-schema.sqlite

20 KB

Download

Verified file details

Filename: sample-empty-schema.sqlite
Exact size: 20,480 bytes
Displayed size: 20 KB
MIME type: application/octet-stream
Tables: 3
Note: empty-schema
License: CC0 / Public Domain
Download URL: https://truefilesize.com/files/sqlite/sample-empty-schema.sqlite

See how TrueFileSize generates and measures sample files, or review the editorial policy.

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, DataGrip

Who 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

What is SQLite?

SQLite is an embedded, serverless relational database engine that stores a complete database in a single cross-platform file (.sqlite, .db). Unlike PostgreSQL or MySQL, SQLite requires no server process — your application reads/writes the file directly. It's the most widely deployed database in the world — built into every smartphone, browser (Chrome, Firefox, Safari), and modern OS. Created by D. Richard Hipp in 2000, SQLite is public domain.

SQLite vs MySQL — When to use which?

SQLite is best for: mobile apps (iOS/Android), desktop apps, embedded devices, development/testing, single-user apps, and read-heavy workloads. MySQL/PostgreSQL is best for: web apps with concurrent writes, multi-user systems, and horizontal scaling. SQLite handles thousands of concurrent readers but only one writer at a time. Modern solutions (Turso, Litestream, Cloudflare D1, Rails 8) make SQLite viable for production web apps too.

How to open SQLite file?

CLI: sqlite3 database.sqlite (pre-installed on macOS/Linux). GUI: DB Browser for SQLite (free, sqlitebrowser.org), TablePlus, DBeaver, or DataGrip. Python: import sqlite3; conn = sqlite3.connect('database.sqlite'). Node.js: const db = new Database('database.sqlite') (better-sqlite3). Our sample database files let you test all these tools.

SQLite file extension — .db vs .sqlite vs .sqlite3?

They are all the same format — just different file extensions. SQLite identifies files by the header bytes ("SQLite format 3\0"), not the extension. Common conventions: .sqlite (most explicit), .db (generic, used by Android Room), .sqlite3 (version-specific). Use whichever your framework expects — the database engine doesn't care.

How do I convert SQLite to CSV or JSON?

CLI: sqlite3 database.sqlite -csv 'SELECT * FROM users' > users.csv. JSON: sqlite3 database.sqlite -json 'SELECT * FROM users' > users.json. Python: pd.read_sql('SELECT * FROM users', conn).to_csv('users.csv'). Node.js: query with better-sqlite3, write with fs.writeFileSync.

Other data formats

SQL JSON CSV XML

Sample SQLite Database Download — Free Test Files

Use cases for sample SQLite files

SQLite vs PostgreSQL vs MySQL

How to open and query SQLite files

Who uses SQLite?

Technical specifications

Frequently Asked Questions

Other data formats

Related reading

Mocking REST APIs with JSON Fixtures

Sample JSON Data for API Testing and Mocking

Seeding Test Databases with Sample Data — SQL, JSON, CSV