SampleTestFiles

100 KB SQL sample file

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

Download

sample-sql-100kb.sql

100 KB102,400 bytes

Download 100 KB SQL

Direct download. No sign-up and no waiting.

Type
application/sql
SHA-256
5a3a1e0c9ab9bf276eca37c495cdb45d8ccf2bb9d91ac4053826da84cd367303
Direct URL
https://sampletestfiles.com/downloads/sql/sample-sql-100kb.sql

What is in this file

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

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

-- SampleTestFiles sample SQL file (100 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 first 64 KB of the file.

Where 100 KB matters

A 102,400-byte file that sits exactly on the default request-body limit of Express. These are the default limits a file of this size is useful for testing:

SystemLimitNote
Express body parsers100 KB (102,400 bytes) by defaultA request body of exactly this size passes; anything larger returns 413 Payload Too Large.
Gmail message clippingAbout 102 KB of HTMLLonger messages are truncated behind a "view entire message" link.
Amazon DynamoDB items400 KB per item100 KB fits; the 500 KB sample does not.

All 100 KB sample files

Use this file for

  • Checking email size handling
  • 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-100kb.sql
FormatSQL (SQL script)
Extension.sql
MIME typeapplication/sql
Size102,400 bytes (100 KB)
KindText
SHA-2565a3a1e0c9ab9bf276eca37c495cdb45d8ccf2bb9d91ac4053826da84cd367303
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-100kb.sql 'https://sampletestfiles.com/downloads/sql/sample-sql-100kb.sql'
sha256sum sample-sql-100kb.sql     # Linux
shasum -a 256 sample-sql-100kb.sql # macOS

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

Related files

Other SQL sizes

Other 100 KB files

Use cases

Guides

Questions about this file

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