2 MB SQL sample
An SQL file of exactly 2,097,152 bytes. It is a valid SQL script file, generated by this site. Compare its checksum and test it with the parser used by your application. Use it wherever you need a 2 MB sample, test or dummy SQL file.
Download
sample-sql-2mb.sql
2 MB2,097,152 bytes
Download 2 MB SQLCreated in your browser in a few seconds, then checked against the SHA-256 checksum. The file is not uploaded anywhere. No sign-up.
- Type
- application/sql
- SHA-256
ca3de0973d0d44d77ce55d3b86b837b689379000d929ee0e83d08010536196ea- Delivery
- Created in your browser from static generator assets (how it works).
What is in this file
One CREATE TABLE statement and 9,293 single-row INSERT statements with fictional customer data. SQL comment lines at the end bring the script to the exact size.
| Statements | 1 CREATE TABLE, 9,293 INSERT |
|---|---|
| Dialect | Portable SQL (runs on PostgreSQL, MySQL, MariaDB and SQLite) |
| Encoding | UTF-8 (ASCII characters only) |
How the file begins
The opening lines of sample-sql-2mb.sql, exactly as they appear in the file.
00000000 2d 2d 20 53 61 6d 70 6c 65 54 65 73 74 46 69 6c |-- SampleTestFil|
00000010 65 73 20 73 61 6d 70 6c 65 20 53 51 4c 20 66 69 |es sample SQL fi|
00000020 6c 65 20 28 32 20 4d 42 29 0a 2d 2d 20 50 6f 72 |le (2 MB).-- Por|
00000030 74 61 62 6c 65 20 53 51 4c 3a 20 6f 6e 65 20 43 |table SQL: one C|Preview
Creates the file in your browser and shows the first 64 KB of it.
Where 2 MB matters
A 2,097,152-byte file: exactly the default upload limit of PHP, and twice the default of nginx and Spring Boot. These are the default limits a file of this size is useful for testing:
| System | Limit | Note |
|---|---|---|
| PHP | 2 MB per uploaded file by default (upload_max_filesize) | A file of exactly 2 MB is accepted; one byte more is refused. |
| nginx | 1 MB by default (client_max_body_size) | Rejected with 413 Request Entity Too Large. |
| Spring Boot multipart | 1 MB per file by default (max-file-size) | Rejected unless the property is raised. |
| Django | 2.5 MB in memory by default | 2 MB is held in memory; the 5 MB sample is streamed to a temporary file. |
| Vercel Functions | 4.5 MB request body | Accepted, including as base64 at about 2.8 MB. |
Use this file for
- Finding the first upload limit in a new stack
- Checking migration runners with large scripts
- Seeding development and test databases
Testing notes for SQL
- Executing an uploaded SQL file is running code. Only do it in an isolated database with a restricted account.
- Clients that load the whole script into memory struggle with large dumps; streaming execution matters at 10 MB and above.
Technical details
| File name | sample-sql-2mb.sql |
|---|---|
| Format | SQL (SQL script) |
| Extension | .sql |
| MIME type | application/sql |
| Size | 2,097,152 bytes (2 MB) |
| Kind | Text |
| SHA-256 | ca3de0973d0d44d77ce55d3b86b837b689379000d929ee0e83d08010536196ea |
| Created | 2026-10-23 |
| Validation | See the listed size and SHA-256. Small downloads are checked in the browser; verify streamed downloads manually. A hash match does not prove parser compatibility. |
| Preview | Available on this page |
| Source | Generated in your browser by this site's generator; not copied from elsewhere |
| Licence | Free to use, modify and redistribute (terms) |
| Category | Database |
Check the stated structure and checksum against your application requirements. As with any download, scan the file with your own security tools before opening it. How files are made and checked
Verify your copy
This file is created in your browser, so it has no direct URL for curl or wget. The generator is designed to produce reproducible bytes. After saving, compare the checksum with the SHA-256 value above.
sha256sum sample-sql-2mb.sql # Linux
shasum -a 256 sample-sql-2mb.sql # macOSOn Windows, run Get-FileHash sample-sql-2mb.sql -Algorithm SHA256 in PowerShell. For scripts and pipelines, save the file once and keep your own copy.
Related files
Questions about this file
- Is this file exactly 2 MB?
- Yes. It is 2,097,152 bytes, which is 2 MB in the binary units that operating systems and server limits use (1 KB = 1,024 bytes).
- What is inside the 2 MB SQL file?
- One CREATE TABLE statement and 9,293 single-row INSERT statements with fictional customer data. SQL comment lines at the end bring the script to the exact size.
- Which databases can run the sample scripts?
- They use portable syntax and have been run on SQLite. PostgreSQL, MySQL and MariaDB accept the same statements.