100 MB SQL sample

An SQL file of exactly 104,857,600 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 100 MB sample, test or dummy SQL file.

sample-sql-100mb.sql

100 MB104,857,600 bytes

Download 100 MB SQL

Created in your browser and, in browsers that can stream to disk, sent straight to your downloads list; this can take a minute. No sign-up.

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

What is in this file

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

Preview

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

Where 100 MB matters

A 104,857,600-byte file: the request-body limit of Cloudflare's Free and Pro plans, and the size above which GitHub rejects a file outright.

All 100 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-100mb.sql
Format	SQL (SQL script)
Extension	.sql
MIME type	application/sql
Size	104,857,600 bytes (100 MB)
Kind	Text
SHA-256	4e4aed8a8608ade0bd6f140915f1ed99eb47258dc862cfcda0ff0854df510f2c
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-100mb.sql     # Linux
shasum -a 256 sample-sql-100mb.sql # macOS

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