50 MB SQL sample

An SQL file of exactly 52,428,800 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 50 MB sample, test or dummy SQL file.

Download

sample-sql-50mb.sql

50 MB52,428,800 bytes

Download 50 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
fdc3631f5c13d2654063a8469091011e3b066e4256378adbe47f6f597bdf3773
Delivery
Created in your browser from static generator assets (how it works).

What is in this file

One CREATE TABLE statement and 229,076 single-row INSERT statements with fictional customer data. SQL comment lines at the end bring the script to the exact size.

Statements1 CREATE TABLE, 229,076 INSERT
DialectPortable SQL (runs on PostgreSQL, MySQL, MariaDB and SQLite)
EncodingUTF-8 (ASCII characters only)

How the file begins

The opening lines of sample-sql-50mb.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 35 30 20 4d  42 29 0a 2d 2d 20 50 6f |le (50 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 50 MB matters

A 52,428,800-byte file: exactly the size at which Git hosting on GitHub starts warning about large files, and about the limit for a zipped AWS Lambda package uploaded directly.

All 50 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 namesample-sql-50mb.sql
FormatSQL (SQL script)
Extension.sql
MIME typeapplication/sql
Size52,428,800 bytes (50 MB)
KindText
SHA-256fdc3631f5c13d2654063a8469091011e3b066e4256378adbe47f6f597bdf3773
Created2026-10-23
ValidationSee 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.
PreviewAvailable on this page
SourceGenerated in your browser by this site's generator; not copied from elsewhere
LicenceFree to use, modify and redistribute (terms)
CategoryDatabase

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-50mb.sql     # Linux
shasum -a 256 sample-sql-50mb.sql # macOS

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