200 KB SQL sample

An SQL file of exactly 204,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 200 KB sample, test or dummy SQL file.

sample-sql-200kb.sql

200 KB204,800 bytes

Download 200 KB SQL

Created in your browser in a few seconds, then checked against the SHA-256 checksum. The file is not uploaded anywhere. No sign-up.

Type: application/sql
SHA-256: 5fbc5b70f8cae937d87f71fcb46b4dd17b63e3c739f66bee39476a46e6112042
Delivery: Created in your browser from static generator assets (how it works).

What is in this file

One CREATE TABLE statement and 912 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, 912 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-200kb.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 32 30 30 20  4b 42 29 0a 2d 2d 20 50 |le (200 KB).-- P|
00000030  6f 72 74 61 62 6c 65 20  53 51 4c 3a 20 6f 6e 65 |ortable SQL: one|

Preview

Creates the file in your browser and shows the first 64 KB of it.

Where 200 KB matters

A 204,800-byte file: twice the default body limit of most API frameworks, and a common cap for photo and signature uploads on application forms. These are the default limits a file of this size is useful for testing:

System	Limit	Note
Express body parsers	100 KB by default	Rejected with 413 unless the limit is raised.
Amazon DynamoDB items	400 KB per item	200 KB fits, even after base64 encoding takes it to about 273 KB.
Azure Service Bus, Standard tier	256 KB per message	Fits as raw bytes, but not once base64-encoded.

All 200 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 name	sample-sql-200kb.sql
Format	SQL (SQL script)
Extension	.sql
MIME type	application/sql
Size	204,800 bytes (200 KB)
Kind	Text
SHA-256	5fbc5b70f8cae937d87f71fcb46b4dd17b63e3c739f66bee39476a46e6112042
Created	2026-10-23
Validation	See 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.
Preview	Available on this page
Source	Generated in your browser by this site's generator; not copied from elsewhere
Licence	Free to use, modify and redistribute (terms)
Category	Database

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

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