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

sample-500kb.sqlite

512 KB

3,000 rows

sample-1mb.sqlite

1.09 MB

7,500 rows

sample-5mb.sqlite

4.41 MB

36,000 rows

sample-10mb.sqlite

9.29 MB

80,000 rows

sample-50mb.sqlite

44.60 MB

396,000 rows

sample-empty-schema.sqlite

20 KB

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

Other data formats

Related reading