Skip to content
>_ TrueFileSize.com

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
File details and verification
Filename
sample-100kb.sqlite
Exact size
94,208 bytes
Displayed size
92 KB
Catalog status
Valid catalog fixture
SHA-256
4cabacb66210b69649cd7087aba2e01213aa21e4b524cd2c9bb8717613f52ba0
Header signature
Matched (SQLite format 3)
Verified on
2026-08-10
MIME type
application/octet-stream
Rows
800
Tables
1
Note
single-table
License
CC0 / Public Domain
Download URL
https://cdn.truefilesize.com/sqlite/sample-100kb.sqlite

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

sample-500kb.sqlite

508 KB

3,000 rows

Download
File details and verification
Filename
sample-500kb.sqlite
Exact size
520,192 bytes
Displayed size
508 KB
Catalog status
Valid catalog fixture
SHA-256
d3849801020f388090364f02c5e3d87ae005cb994e97d38209bfb3c1a4feb614
Header signature
Matched (SQLite format 3)
Verified on
2026-08-10
MIME type
application/octet-stream
Rows
3,000
Tables
3
Indexes
6
Note
multi-table
License
CC0 / Public Domain
Download URL
https://cdn.truefilesize.com/sqlite/sample-500kb.sqlite

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

sample-1mb.sqlite

1.10 MB

7,500 rows

Download
File details and verification
Filename
sample-1mb.sqlite
Exact size
1,150,976 bytes
Displayed size
1.10 MB
Catalog status
Valid catalog fixture
SHA-256
aee2c703c305ab91a423c037242fd2d7272b82f4e919fe6e6bc62d216e0db613
Header signature
Matched (SQLite format 3)
Verified on
2026-08-10
MIME type
application/octet-stream
Rows
7,500
Tables
5
Indexes
8
Note
with-indexes
License
CC0 / Public Domain
Download URL
https://cdn.truefilesize.com/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
File details and verification
Filename
sample-5mb.sqlite
Exact size
4,620,288 bytes
Displayed size
4.41 MB
Catalog status
Valid catalog fixture
SHA-256
fa5e4d5822549b632ae7e16233dbe02c5dd6804eee407544c828deb4a32126bc
Header signature
Matched (SQLite format 3)
Verified on
2026-08-10
MIME type
application/octet-stream
Rows
36,000
Tables
8
Indexes
8
Note
with-views
License
CC0 / Public Domain
Download URL
https://cdn.truefilesize.com/sqlite/sample-5mb.sqlite

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

sample-10mb.sqlite

9.28 MB

80,000 rows

Download
File details and verification
Filename
sample-10mb.sqlite
Exact size
9,732,096 bytes
Displayed size
9.28 MB
Catalog status
Valid catalog fixture
SHA-256
a1ec57f7884e6c1dac35356ac2d78b09dde0d88a357606d0fdebfad6bc32795e
Header signature
Matched (SQLite format 3)
Verified on
2026-08-10
MIME type
application/octet-stream
Rows
80,000
Tables
10
Indexes
8
Note
full-schema
License
CC0 / Public Domain
Download URL
https://cdn.truefilesize.com/sqlite/sample-10mb.sqlite

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

sample-50mb.sqlite

44.59 MB

396,000 rows

Download
File details and verification
Filename
sample-50mb.sqlite
Exact size
46,755,840 bytes
Displayed size
44.59 MB
Catalog status
Valid catalog fixture
SHA-256
9296923330aaf4e6333f9f74946deb5d1fa7a328e439b98d18bad4b77a8f7725
Header signature
Matched (SQLite format 3)
Verified on
2026-08-10
MIME type
application/octet-stream
Rows
396,000
Tables
12
Indexes
8
Note
stress-test
License
CC0 / Public Domain
Download URL
https://cdn.truefilesize.com/sqlite/sample-50mb.sqlite

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

sample-empty-schema.sqlite

20 KB
Download
File details and verification
Filename
sample-empty-schema.sqlite
Exact size
20,480 bytes
Displayed size
20 KB
Catalog status
Valid catalog fixture
SHA-256
a790bc15d508cc676675dff0c71a693a2de24ea28f8dc3826a3835267c2c3270
Header signature
Matched (SQLite format 3)
Verified on
2026-08-10
MIME type
application/octet-stream
Tables
3
Note
empty-schema
License
CC0 / Public Domain
Download URL
https://cdn.truefilesize.com/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

FeatureSQLitePostgreSQLMySQL
ArchitectureEmbedded (single file)Client-serverClient-server
Setup requiredNone (zero-config)Install + configureInstall + configure
Concurrent writers1 (file lock)Unlimited (MVCC)Unlimited (InnoDB)
Max database size281 TBUnlimitedUnlimited
Best forMobile, desktop, embedded, devProduction web appsWordPress, 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 nameSQLite (Structured Query Lite)
Extensions.sqlite, .db, .sqlite3
MIME typeapplication/x-sqlite3
ArchitectureEmbedded, serverless, zero-config
Max file size281 TB (theoretical)
Page size512B to 65536B (default 4096)
LicensePublic domain
Created byD. 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

SQLJSONCSVXML

Related reading

·8 min

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.

·7 min

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.

·7 min

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.