Get Example Files

Sample SQL Files for Download

SQL · .sql

Free downloads · No account required · File sizes and checksums listed

Download a sample SQL script containing an orders table, indexes and fictional order records. The 10 KB script includes 32 INSERT statements and an example summary query.

Intended for SQLite / ANSI-style smoke tests. Validate in a disposable database before claiming support. Choose a size below.

Download Sample SQL Files

Verified sample files · Actual sizes · SHA-256 available

Target size File Actual size
10 KB example-10kb.sql 10 KB Download
100 KB example-100kb.sql 100 KB Download
500 KB example-500kb.sql 497 KB Download
1 MB example-1mb.sql 1017 KB Download
5 MB example-5mb.sql 4.97 MB Download
10 MB example-10mb.sql 9.96 MB Download

Target size is approximate. Use Actual size for limit tests. Open file details for SHA-256 checksums.

File details and SHA-256 checksums

Full SHA-256 for automated tests. MIME application/sql for all sizes.

  • 10 KB example-10kb.sql 10105 bytes (10 KB)
    69cfced004e67903180c349031f43cce82f718a89646415aebee8a3d59e361e2
  • 100 KB example-100kb.sql 102239 bytes (100 KB)
    e77e539f829aab4a5ecc1c250f01b377492d101a802f6d9cad776e05a419b0de
  • 500 KB example-500kb.sql 508726 bytes (497 KB)
    63a2d425efc92b5a2410320679894dbb607707010d0313848abdcb4767655df0
  • 1 MB example-1mb.sql 1041472 bytes (1017 KB)
    9e2c27ad43d5320e3654fe84dcb5dc76465094eda05668d9bd8151978fdcc445
  • 5 MB example-5mb.sql 5215558 bytes (4.97 MB)
    4071f4f7ee08deab01e9b09505328ecd200160066a859b6abe2001e81b18d223
  • 10 MB example-10mb.sql 10441759 bytes (9.96 MB)
    679a059adf61b993c53c5eb04344b7ca1246ccb9dee0263f572ef29ca66af075

How to download

  1. Choose a file in the table and click Download.
  2. Optional: open File details and SHA-256 checksums to confirm the exact bytes for repeatable tests.

Browse more Sample Developer Files or return to Free Example Files.

About these samples

These are synthetic sample files for testing and learning. They are not real user documents and are not intended to contain personal data. A matching SHA-256 confirms you received the published bytes — it is not a malware scan or a guarantee that every application will accept the file.

File information

Format
SQL Script
Extension
.sql
MIME type
application/sql
Category
Developer Files
License
Free for testing and development

Common test uses

  • Schema upload forms: Confirm .sql acceptance.
  • Importer smoke tests: Feed fixtures into migration tools carefully.
  • CI size limits: Pin CDN URLs and checksums.

What's in these samples

Checked on example-10kb.sql: comment identifies SQLite/ANSI intent; creates orders, two indexes, inserts 32 rows in a transaction, and includes a grouped SELECT. Rerunning inserts can hit primary-key/unique constraints even though CREATE uses IF NOT EXISTS. Compatibility was not executed against every engine.

SQL excerpt

Abbreviated preview — not a runnable script. Opening statements from the published 10 KB file with middle rows omitted.

-- Get Example Files - sample SQL script (SQLite / ANSI compatible)
CREATE TABLE IF NOT EXISTS orders (
  id INTEGER PRIMARY KEY,
  order_code VARCHAR(20) NOT NULL UNIQUE,
  customer VARCHAR(80) NOT NULL,
  …
);
CREATE INDEX IF NOT EXISTS idx_orders_city ON orders (city);
BEGIN TRANSACTION;
INSERT INTO orders (…) VALUES (1, 'ORD-100001', …);
-- 32 INSERT statements + a grouped SELECT summary

What Is a SQL Example File?

A SQL example file is a text script of DDL/DML statements for import and parser tests.

These samples target SQLite-friendly / ANSI-style SQL. They do not prove universal dialect compatibility.

Notes about these SQL samples

MIME type is often application/sql or text/plain. Related: CSV, JSON, YAML.

Need a different format in this category? Try these related samples.

Browse all Developer Files Free Example Files

Frequently Asked Questions

Are SQL example files free?

Yes. Published SQL samples are free to download.

What dialect is the 10 KB script?

The file comments identify SQLite / ANSI-compatible intent. Validate on a disposable SQLite database before asserting support for other engines.

What does the 10 KB script contain?

An orders table, two indexes, 32 INSERT statements in a transaction, and an example grouped SELECT.

Looking for More Sample Developer Files?

Return to the Developer Files category to browse published formats.

Also try: CSV Example Files · JSON Example Files · YAML Example Files · XML Example Files

Browse Sample Developer Files