Data
SQL test files, any size.
Set a size and generate a structurally valid SQL immediately. Nothing is uploaded and nothing is stored.
SQL, built to spec.
Each file is a runnable dump with a CREATE TABLE and an INSERT. The size you ask for is reached with a block comment, so the result opens in psql, mysql, DBeaver and TablePlus. Most people generate these for testing database import limits and migration tooling.
Common sizes
Pick a size to jump straight to it, or set your own on the caliper above.
1 KB SQL
1,024 bytes
5 KB SQL
5,120 bytes
10 KB SQL
10,240 bytes
50 KB SQL
51,200 bytes
100 KB SQL
102,400 bytes
500 KB SQL
512,000 bytes
1 MB SQL
1,048,576 bytes
2 MB SQL
2,097,152 bytes
3 MB SQL
3,145,728 bytes
5 MB SQL
5,242,880 bytes
10 MB SQL
10,485,760 bytes
15 MB SQL
15,728,640 bytes
20 MB SQL
20,971,520 bytes
25 MB SQL
26,214,400 bytes
50 MB SQL
52,428,800 bytes
100 MB SQL
104,857,600 bytes
200 MB SQL
209,715,200 bytes
500 MB SQL
524,288,000 bytes
1 GB SQL
1,073,741,824 bytes
2 GB SQL
2,147,483,648 bytes
Questions.
How small can an SQL file be?
About 126 bytes. Below that the format cannot carry its mandatory structure, let alone padding.
Will the file open normally?
Yes — it opens in psql, mysql, DBeaver and TablePlus, because the padding lives in a block comment.
Can I ask for an unusual size?
Any byte count above the minimum works, including values like 3,145,728 or 27.5 MB. Drag the caliper or type the number.
Noticed an issue with this test file? Report an issue →