20 MB SQL sample

An SQL file of exactly 20,971,520 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 20 MB sample, test or dummy SQL file.

sample-sql-20mb.sql

20 MB20,971,520 bytes

Download 20 MB SQL

Created in your browser in a few seconds, then checked against the SHA-256 checksum. No sign-up.

Type: application/sql
SHA-256: dc42132b8a0546d086af48c4d298c4beb381b274d5bd9527f3a5e8d7dd3c80cd
Delivery: Created in your browser from static generator assets (how it works).

What is in this file

One CREATE TABLE statement and 92,143 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, 92,143 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-20mb.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 30 20 4d  42 29 0a 2d 2d 20 50 6f |le (20 MB).-- Po|
00000030  72 74 61 62 6c 65 20 53  51 4c 3a 20 6f 6e 65 20 |rtable SQL: one |

Preview

Creates the file in your browser and shows its first 64 KB.

Where 20 MB matters

A 20,971,520-byte file: right at the default attachment limit of Outlook, and just under the 25 MB ceilings of Gmail and GitHub web uploads. These are the default limits a file of this size is useful for testing:

System	Limit	Note
Microsoft Outlook	20 MB of attachments by default for internet mail accounts	This file is right at the limit; add a second attachment and it is exceeded.
Gmail	25 MB per message	Under the limit, although email encoding adds about a third in transit.
GitHub web uploads	25 MiB per file added through the browser	Accepted. Pushing with Git allows larger files.
Cloudflare Pages assets	25 MiB per file	The largest round size that can be served as a static asset.
Amazon API Gateway	10 MB payload	Rejected; the upload has to go directly to object storage.
ASP.NET Core (Kestrel)	About 28.6 MB request body by default	Accepted with room for the multipart overhead.

All 20 MB sample files

Use this file for

Measuring download speed from your own server or CDN
Checking migration runners with large scripts
Seeding development and test databases

Testing notes for SQL

Clients that load the whole script into memory struggle with large dumps; streaming execution matters at 10 MB and above.
Executing an uploaded SQL file is running code. Only do it in an isolated database with a restricted account.

SQL format reference

Technical details

File name	sample-sql-20mb.sql
Format	SQL (SQL script)
Extension	.sql
MIME type	application/sql
Size	20,971,520 bytes (20 MB)
Kind	Text
SHA-256	dc42132b8a0546d086af48c4d298c4beb381b274d5bd9527f3a5e8d7dd3c80cd
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-20mb.sql     # Linux
shasum -a 256 sample-sql-20mb.sql # macOS

On Windows, run Get-FileHash sample-sql-20mb.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 20 MB?: Yes. It is 20,971,520 bytes, which is 20 MB in the binary units that operating systems and server limits use (1 KB = 1,024 bytes).
What is inside the 20 MB SQL file?: One CREATE TABLE statement and 92,143 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.

Download