Sample SQLite Database — Download a Test .sqlite File (2 Tables, 2,000 Rows)
SQLite database file · .sqlite, .db · MIME type application/vnd.sqlite3
Download a sample SQLite database — a real .sqlite file with a customers table, an orders table (2,000 rows) with a foreign key, an index on customer_id and a revenue_by_region view. It opens in DB Browser for SQLite, the sqlite3 CLI, DBeaver, DuckDB, and any language with an SQLite driver.
SQLite is the most deployed database engine in the world (every phone, browser and most desktop apps), and a single-file database is the ideal fixture: no server, no setup, deterministic contents.
Download sample SQLite files
| File | Details | Size | Download |
|---|---|---|---|
sample-database.sqlite | 2,012 rows | 221 KB |
Need one of every data format? Download the data sample pack (202 KB, one small file of every data format (17 files)).
Use these files from the command line or CI
Every URL is stable and CORS-open. Pin the SHA-256 in your test and you will know the moment a fixture changes.
# Download one file curl -O https://pnb-website-bucket.s3.us-east-2.amazonaws.com/samples/data/sqlite/sample-database.sqlite # Verify it (SHA-256 is listed for every file above) shasum -a 256 sample-database.sqlite # Machine-readable index of every sample file curl https://pnb-website-bucket.s3.us-east-2.amazonaws.com/samples/index.json | jq '.files[] | select(.format=="sqlite")'
SQLite format at a glance
| Full name | SQLite database file |
|---|---|
| Extensions | .sqlite, .db |
| MIME type | application/vnd.sqlite3 |
| Engine | SQLite 3, single file, vacuumed |
| Schema | customers(id, name, region); orders(order_id, order_date, customer_id → customers, product, category, quantity, unit_price, total, status) |
| Objects | 2 tables, 1 index, 1 view |
| Magic bytes | 53 51 4C 69 74 65 20 66 ("SQLite f") |
What people test with sample SQLite files
- Fixture database for integration tests
- SQLite viewer and admin tools
- Migration and ORM tooling
- Mobile-app bundled data
Frequently asked questions
How do I open a .sqlite file?
From the command line: sqlite3 sample-database.sqlite then .tables. Graphically: DB Browser for SQLite (free, cross-platform) or the SQLite extension for VS Code. In code, every major language has a built-in or standard driver.
Are these SQLite files safe to download?
Yes. Every file is generated by our own open script from scratch — nothing is scraped or user-uploaded — and contains no scripts, macros or executables. The SHA-256 of each file is published on this page so you can verify what you received.
Can I use the sample SQLite files commercially?
Yes. They are free for any purpose, including commercial products, test suites, demos and redistribution, with no attribution required. There is nothing to license and no one to ask.
Can I hotlink these files or use them in CI?
Yes. Every link is a stable direct URL over HTTPS with Access-Control-Allow-Origin: * and long cache headers, so curl, wget, fetch() and test runners can pull them directly. A JSON index of every file is linked from each page (see the command-line section).
Related sample files
Testing a file pipeline? We build them.
Uploads, conversions, previews, document processing and media workflows are the kind of production systems Pine & Birch designs and runs for clients — which is why we needed these files in the first place.
See how we can help