500 KB SQL sample

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

sample-sql-500kb.sql

500 KB512,000 bytes

Download 500 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: 64675f2488aa27e1bacb11569c8b53f0111e280f49433409cb2cc44376f3fc12
Delivery: Created in your browser from static generator assets (how it works).

What is in this file

One CREATE TABLE statement and 2,274 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, 2,274 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-500kb.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 35 30 30 20  4b 42 29 0a 2d 2d 20 50 |le (500 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 500 KB matters

A 512,000-byte file: larger than most API body limits, smaller than most upload limits. These are the default limits a file of this size is useful for testing:

System	Limit	Note
Amazon DynamoDB items	400 KB per item	500 KB cannot be stored as a single item.
Express body parsers	100 KB by default	Rejected unless the limit is raised.
nginx request body	1 MB by default (client_max_body_size)	Accepted with room to spare.

All 500 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-500kb.sql
Format	SQL (SQL script)
Extension	.sql
MIME type	application/sql
Size	512,000 bytes (500 KB)
Kind	Text
SHA-256	64675f2488aa27e1bacb11569c8b53f0111e280f49433409cb2cc44376f3fc12
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-500kb.sql     # Linux
shasum -a 256 sample-sql-500kb.sql # macOS

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