SampleTestFiles

1 MB SQL sample file

An SQL file of exactly 1,048,576 bytes. It is a valid SQL script file, generated for this site and checked with an independent parser.

Download

sample-sql-1mb.sql

1 MB1,048,576 bytes

Download 1 MB SQL

Direct download. No sign-up and no waiting.

Type
application/sql
SHA-256
7de7aec0bd0f02cba8e3fcd2d37a03fcad2f123c21aa746a307fcb95fec712d4
Direct URL
https://sampletestfiles.com/downloads/sql/sample-sql-1mb.sql

What is in this file

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

Statements1 CREATE TABLE, 4,652 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-1mb.sql, exactly as they appear in the file.

-- SampleTestFiles sample SQL file (1 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 1 MB matters

A 1,048,576-byte file: exactly the default upload limit of nginx, Spring Boot and Next.js. These are the default limits a file of this size is useful for testing:

SystemLimitNote
nginx1 MB by default (client_max_body_size)A multipart upload of this file exceeds the limit by the size of the form boundaries.
Spring Boot multipart1 MB per file by default (max-file-size)A file of exactly 1 MB is at the limit.
Next.js API routes and Server Actions1 MB by defaultLarger bodies need the size limit raised in configuration.
Cloud Firestore documents1 MiB (1,048,576 bytes)The same number of bytes as this file.
Apache Kafka messagesAbout 1 MB by defaultBrokers reject larger records unless message.max.bytes is raised.

All 1 MB sample files

Use this file for

  • Download tests on mobile connections
  • Testing import features in database tools
  • Checking migration runners with large scripts

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-1mb.sql
FormatSQL (SQL script)
Extension.sql
MIME typeapplication/sql
Size1,048,576 bytes (1 MB)
KindText
SHA-2567de7aec0bd0f02cba8e3fcd2d37a03fcad2f123c21aa746a307fcb95fec712d4
Created2026-10-10
ValidationExact size, signature bytes and structure checked when the file was generated
PreviewAvailable on this page
SourceGenerated for this site; not copied from elsewhere
LicenceFree to use, modify and redistribute (terms)
CategoryDatabase

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-1mb.sql 'https://sampletestfiles.com/downloads/sql/sample-sql-1mb.sql'
sha256sum sample-sql-1mb.sql     # Linux
shasum -a 256 sample-sql-1mb.sql # macOS

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

Related files

Other SQL sizes

Other 1 MB files

Use cases

Guides

Questions about this file

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