10 MB SQL sample file

An SQL file of exactly 10,485,760 bytes. It is a valid SQL script file, generated for this site and checked with an independent parser.

sample-sql-10mb.sql

10 MB10,485,760 bytes

Download 10 MB SQL

Direct download. No sign-up and no waiting.

Type: application/sql
SHA-256: bb9cd4e5baa0a50b4767ce3598591cbe0aa1bdf7e3c1bc6aef248073927f8df0
Direct URL: https://sampletestfiles.com/downloads/sql/sample-sql-10mb.sql

What is in this file

One CREATE TABLE statement and 46,125 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, 46,125 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-10mb.sql, exactly as they appear in the file.

-- SampleTestFiles sample SQL file (10 MB)
-- Portable SQL: one CREATE TABLE statement followed by single-row INSERT statements.
CREATE TABLE customers (
  id INTEGER PRIMARY KEY,
  first_name VARCHAR(50) NOT NULL,
  last_name VARCHAR(50) NOT NULL,
  email VARCHAR(120) NOT NULL,
  city VARCHAR(60),
  country CHAR(2),
  signup_date DATE,
  plan VARCHAR(20),
  balance DECIMAL(10,2),
  active SMALLINT
);

Preview

Shows the first 64 KB of the file.

Where 10 MB matters

A 10,485,760-byte file: over the default limits of PHP, API Gateway and Spring Boot requests. These are the default limits a file of this size is useful for testing:

System	Limit	Note
Amazon API Gateway	10 MB payload	A 10 MB file in a multipart or base64 body is over the limit.
Spring Boot multipart	10 MB per request by default (max-request-size)	Exceeded once form overhead is added.
PHP	8 MB POST body by default (post_max_size)	Rejected before the script runs.
Amazon S3 multipart upload	5 MiB minimum part size	This file splits into exactly two minimum-sized parts.
Email attachments	Commonly 20 to 25 MB per message	10 MB fits, at about 13.3 MB once encoded.

All 10 MB sample files

Use this file for

Exercising chunked and resumable uploads
Seeding development and test databases
Testing import features in database tools

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-10mb.sql
Format	SQL (SQL script)
Extension	.sql
MIME type	application/sql
Size	10,485,760 bytes (10 MB)
Kind	Text
SHA-256	bb9cd4e5baa0a50b4767ce3598591cbe0aa1bdf7e3c1bc6aef248073927f8df0
Created	2026-10-10
Validation	Exact size, signature bytes and structure checked when the file was generated
Preview	Available on this page
Source	Generated for this site; not copied from elsewhere
Licence	Free to use, modify and redistribute (terms)
Category	Database

Validated for expected format and integrity. As with any download, scan the file with your own security tools before opening it. How files are made and checked

Download from the command line and verify

Fetch the file with curl, then compare its checksum with the SHA-256 value above.

curl -o sample-sql-10mb.sql 'https://sampletestfiles.com/downloads/sql/sample-sql-10mb.sql'
sha256sum sample-sql-10mb.sql     # Linux
shasum -a 256 sample-sql-10mb.sql # macOS

On Windows, run Get-FileHash sample-sql-10mb.sql -Algorithm SHA256 in PowerShell. A matching value proves that the download is complete and unaltered.

Related files

Questions about this file

Is this file exactly 10 MB?: Yes. It is 10,485,760 bytes, which is 10 MB in the binary units that operating systems and server limits use (1 KB = 1,024 bytes).
What is inside the 10 MB SQL file?: One CREATE TABLE statement and 46,125 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