Database sample files
SQL scripts and tabular data for seeding test databases and testing import tools.
Formats in this category
| Format | What it is | Sizes |
|---|---|---|
| SQL sample files.sql application/sql | A text file of SQL statements, used for database dumps, migrations and seed data. | 1 KB to 10 MB |
| CSV sample files.csv text/csv | Tabular data as plain text, one record per line. The universal import and export format. | 1 KB to 10 MB |
| JSONL sample files.jsonl application/jsonl | One JSON value per line. The usual format for logs, data pipelines and machine-learning datasets. | 1 KB to 10 MB |
About these files
A test database needs data, and writing it by hand is tedious. These scripts create a customers table and fill it with fictional rows using syntax that the common open-source databases all accept.
CSV and JSON Lines samples are listed here too, because bulk loading from those formats is usually faster than running INSERT statements.
Ready-made samples
Hand-designed files with realistic content or a specific edge case.
| File | Format | Size | Contents | Download |
|---|---|---|---|---|
| Sample customers SQL script (100 rows)sample-customers.sql | SQL | 19.3 KB19,777 bytes | Statements: 1 CREATE TABLE, 100 INSERT | Download SQL |
Popular downloads by size
Jump straight to a file. Every size is exact to the byte.
Or browse every format at one size: 1 KB, 5 KB, 10 KB, 25 KB, 50 KB, 100 KB, 500 KB, 1 MB, 5 MB, 10 MB.
What to test
- Software development
General-purpose fixtures for building, debugging and demonstrating software that reads or writes files.
- CI/CD pipelines
Fixtures for build, test and deployment pipelines, with checksums for verification.
- Performance testing
Large, predictable inputs for measuring throughput, memory use and processing time.
Related categories
Database files: questions
- Which database engines are supported?
- The scripts avoid engine-specific syntax and run on SQLite, PostgreSQL, MySQL and MariaDB.