loremfile

Sample SQL dump for testing importers, free and CC0

SQL dumps are how data moves between databases, and they break on vendor-specific syntax: backtick quoting, AUTO_INCREMENT, SERIAL or bracketed identifiers. sql/people-1000-inserts-portable.sql avoids all of it.

It holds one CREATE TABLE statement and 1,000 INSERT statements for the shared synthetic people dataset, using only syntax that every major database accepts, so the same file loads into SQLite, PostgreSQL and MySQL alike. The rows are the same records as the CSV, JSON and SQLite people files.

Use it to test database import tools, migration scripts, SQL editors that preview large files, and upload forms that accept .sql files. One statement per row also makes it a realistic test of import speed with and without a surrounding transaction. Related formats: CSV, JSON and the ready-made SQLite database.

1 file. The same list as JSON: https://loremfile.dev/sql/index.json

SQL files
FileSizePropertiesDescription
people-1000-inserts-portable.sql 429.9 KB (429,863 bytes) utf-8, LF One CREATE TABLE and 1,000 INSERT statements for the shared people dataset, using only syntax that every major database accepts.
Snippets 
<a href="https://loremfile.dev/sql/people-1000-inserts-portable.sql">download</a>
curl -O https://loremfile.dev/sql/people-1000-inserts-portable.sql

Every SQL file in one command, each checked against its hash: npx loremfile get --format sql, or loremfile get --format sql after pip install loremfile.

File names follow the naming grammar. Verify a download against sha256sums.txt.