5 KB SQL sample

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

Download

sample-sql-5kb.sql

5 KB5,120 bytes

Download 5 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
29bb2d031f1c64dc505bdc7c8dae6ec4b7fbb4809ce50da4ad5fa5c65a27ccf4
Delivery
Created in your browser from static generator assets (how it works).

What is in this file

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

Statements1 CREATE TABLE, 19 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-5kb.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 20 4b 42  29 0a 2d 2d 20 50 6f 72 |le (5 KB).-- Por|
00000030  74 61 62 6c 65 20 53 51  4c 3a 20 6f 6e 65 20 43 |table SQL: one C|

Preview

Shows the file contents.

Where 5 KB matters

A 5,120-byte file: larger than a cookie, smaller than a typical HTTP header limit. These are the default limits a file of this size is useful for testing:

SystemLimitNote
Browser cookies4,096 bytes per cookie5 KB does not fit in one cookie.
Vite asset inlining4 KB by default (assetsInlineLimit)A 5 KB asset is emitted as a separate file rather than inlined as base64.
nginx and Apache request headers8 KB per header line by default5 KB fits; the 10 KB sample does not.

All 5 KB sample files

Use this file for

  • Smoke tests in CI that must run in milliseconds
  • Seeding development and test databases
  • Testing import features in database tools

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-5kb.sql
FormatSQL (SQL script)
Extension.sql
MIME typeapplication/sql
Size5,120 bytes (5 KB)
KindText
SHA-25629bb2d031f1c64dc505bdc7c8dae6ec4b7fbb4809ce50da4ad5fa5c65a27ccf4
Created2026-10-23
ValidationSee 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.
PreviewAvailable on this page
SourceGenerated in your browser by this site's generator; not copied from elsewhere
LicenceFree to use, modify and redistribute (terms)
CategoryDatabase

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

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