SampleTestFiles

10 KB SQL sample file

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

Download

sample-sql-10kb.sql

10 KB10,240 bytes

Download 10 KB SQL

Direct download. No sign-up and no waiting.

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

What is in this file

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

Statements1 CREATE TABLE, 44 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-10kb.sql, exactly as they appear in the file.

-- SampleTestFiles sample SQL file (10 KB)
-- 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 file contents.

Where 10 KB matters

A 10,240-byte file that still arrives in the first round trip of a new connection. These are the default limits a file of this size is useful for testing:

SystemLimitNote
TCP initial congestion windowAbout 14.6 KB (10 segments)A 10 KB response fits in the first flight of packets; the 25 KB sample does not.
nginx and Apache request headers8 KB per header line by defaultData this large must go in the request body.
webpack asset modules8 KB by defaultAssets over the threshold are emitted as files instead of data URIs.

All 10 KB sample files

Use this file for

  • Checking thumbnail and icon handling
  • Checking migration runners with large scripts
  • Seeding development and test databases

Testing notes for SQL

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

SQL format reference

Technical details

File namesample-sql-10kb.sql
FormatSQL (SQL script)
Extension.sql
MIME typeapplication/sql
Size10,240 bytes (10 KB)
KindText
SHA-256a15e638cac42b79f0234b618c118a6c9bb9a8c1ed88f15bc8ac3e815605b580b
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-10kb.sql 'https://sampletestfiles.com/downloads/sql/sample-sql-10kb.sql'
sha256sum sample-sql-10kb.sql     # Linux
shasum -a 256 sample-sql-10kb.sql # macOS

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

Related files

Other SQL sizes

Other 10 KB files

Use cases

Guides

Questions about this file

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