# Sample SQL dump for testing importers, free and CC0

1 SQL test file of 429.9 KB. A direct URL, the file's SHA-256 and CC0, so curl and CI can fetch it with no signup and no keys.

The page: <https://loremfile.dev/sql>.

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](https://loremfile.dev/csv), [JSON](https://loremfile.dev/json) and the ready-made [SQLite](https://loremfile.dev/sqlite) database.

## Files

| Path | Size | MIME | Properties |
|---|---|---|---|
| [`sql/people-1000-inserts-portable.sql`](https://loremfile.dev/sql/people-1000-inserts-portable.sql) | 429.9 KB (429,863 bytes) | `application/sql` | utf-8, LF, 1,018 lines |

The same list as JSON: <https://loremfile.dev/sql/index.json>.