1 KB SQL sample file

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

sample-sql-1kb.sql

1 KB1,024 bytes

Download 1 KB SQL

Direct download. No sign-up and no waiting.

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

What is in this file

One CREATE TABLE statement and 2 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 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-1kb.sql, exactly as they appear in the file.

-- SampleTestFiles sample SQL file (1 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 1 KB matters

The smallest practical test file: 1,024 bytes, small enough to travel in a single network packet. These are the default limits a file of this size is useful for testing:

System	Limit	Note
Ethernet	1,500 bytes (typical MTU)	A 1 KB payload fits in one packet with its headers.
Browser cookies	4,096 bytes per cookie	1 KB is well inside the limit; the 5 KB sample is over it.

All 1 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 name	sample-sql-1kb.sql
Format	SQL (SQL script)
Extension	.sql
MIME type	application/sql
Size	1,024 bytes (1 KB)
Kind	Text
SHA-256	f340b13f61b65ac1fe01f2e363a0b8d629e52ac15783fba1a2ef3cd743743f2b
Created	2026-10-10
Validation	Exact size, signature bytes and structure checked when the file was generated
Preview	Available on this page
Source	Generated for this site; not copied from elsewhere
Licence	Free to use, modify and redistribute (terms)
Category	Database

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-1kb.sql 'https://sampletestfiles.com/downloads/sql/sample-sql-1kb.sql'
sha256sum sample-sql-1kb.sql     # Linux
shasum -a 256 sample-sql-1kb.sql # macOS

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

Related files

Questions about this file

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