Sample SQL Files — Database Dump Downloads for Testing

Download free sample SQL files for MySQL, PostgreSQL, and SQLite. Includes user tables, ecommerce schemas, blog databases, and large dumps up to 100,000 rows. Schema-only and data-only variants available.

sample-mysql.sql

55.6 KB

1,000 rows

Download

File details and verification

Filename: sample-mysql.sql
Exact size: 56,910 bytes
Displayed size: 55.6 KB
Catalog status: Valid catalog fixture
SHA-256: 3feac5727e2d7f9a7fbaf226f293db7fc0c0c2d7961974d4869d9316603edccd
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-mysql.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-postgresql.sql

55.3 KB

1,000 rows

Download

File details and verification

Filename: sample-postgresql.sql
Exact size: 56,651 bytes
Displayed size: 55.3 KB
Catalog status: Valid catalog fixture
SHA-256: 9bd034cdb1452aefe78a9b94bdb353161ef4bd9abf183adedcddd612ac545cee
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-postgresql.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-sqlite.sql

55.2 KB

1,000 rows

Download

File details and verification

Filename: sample-sqlite.sql
Exact size: 56,490 bytes
Displayed size: 55.2 KB
Catalog status: Valid catalog fixture
SHA-256: 15f0df10b8d315589cf5ebe044621c6a96e52ff3ae8b43e41063ca7515f326ad
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-sqlite.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-users-table.sql

28.1 KB

500 rows

Download

File details and verification

Filename: sample-users-table.sql
Exact size: 28,735 bytes
Displayed size: 28.1 KB
Catalog status: Valid catalog fixture
SHA-256: aad074e827941c55db90b7c118b96a544f3a84518cb2a7ab075a3b66bfbdb386
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 500
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-users-table.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-ecommerce.sql

245 KB

5,000 rows

Download

File details and verification

Filename: sample-ecommerce.sql
Exact size: 250,844 bytes
Displayed size: 245 KB
Catalog status: Valid catalog fixture
SHA-256: b6f6e4b4711ad979f21fa4ef0e3e7f4603c22f44156114e4373c27425b25eebd
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 5,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-ecommerce.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-blog.sql

228 KB

2,000 rows

Download

File details and verification

Filename: sample-blog.sql
Exact size: 233,739 bytes
Displayed size: 228 KB
Catalog status: Valid catalog fixture
SHA-256: 219a3fa539ba2c1d78b9bbd21605b8c863ac9b23cae396354387d0b1a5c2f12b
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 2,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-blog.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-schema-only.sql

528 B

Download

File details and verification

Filename: sample-schema-only.sql
Exact size: 528 bytes
Displayed size: 528 B
Catalog status: Valid catalog fixture
SHA-256: 6b773f0fba36b6484ea5c24126a1c861427e080924d2228a77cef4542de17e2a
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-schema-only.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-data-only.sql

110 KB

2,000 rows

Download

File details and verification

Filename: sample-data-only.sql
Exact size: 112,499 bytes
Displayed size: 110 KB
Catalog status: Valid catalog fixture
SHA-256: ee9850e303238b247aafe1158035937b25ded01a10aed73dbaae0bc9329ce1e1
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 2,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-data-only.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-large.sql

5.38 MB

100,000 rows

Download

File details and verification

Filename: sample-large.sql
Exact size: 5,639,156 bytes
Displayed size: 5.38 MB
Catalog status: Valid catalog fixture
SHA-256: 45c6186904da36f9279ddeae61ea672296e10ea699e4f5737ad74533c738b023
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 100,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-large.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

Sample SQL file preview

Users table (MySQL)

CREATE TABLE users (
  id INT PRIMARY KEY AUTO_INCREMENT,
  username VARCHAR(50) NOT NULL,
  email VARCHAR(100) UNIQUE NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO users (username, email) VALUES
('alice_johnson', 'alice@example.com'),
('bob_smith', 'bob@example.com');

How to import a SQL file

MySQL

mysql -u root -p database_name < sample-mysql.sql

PostgreSQL

psql -U username -d database_name -f sample-postgresql.sql

SQLite

sqlite3 database.db < sample-sqlite.sql

phpMyAdmin

Import tab → Choose file → Select the .sql file → Execute. Works with all MySQL-compatible SQL files.

Use cases for sample SQL files

Seeding development and staging databases
Testing database migration scripts
Verifying SQL import/export functionality
Testing ORM compatibility (Prisma, Sequelize, SQLAlchemy)
Load testing databases with large datasets
Testing schema-only vs data-only import flows

Technical specifications

Dialects	MySQL, PostgreSQL, SQLite
Content	CREATE TABLE + INSERT statements
Data	Faker.js-generated realistic dummy data
Schemas	Users, ecommerce (8 tables), blog (5 tables)
Size range	10 KB to 5 MB (up to 100K rows)

Frequently Asked Questions

Are these SQL files compatible with my database?

We provide separate files for MySQL, PostgreSQL, and SQLite — each uses the correct dialect syntax. The MySQL files also work with MariaDB and Percona. Choose the file matching your database engine.

What is the difference between schema-only and data-only?

Schema-only (sample-schema-only.sql) contains only CREATE TABLE statements — no data. Data-only (sample-data-only.sql) contains only INSERT statements — assumes tables already exist. Use them to test separate schema migration and data seeding flows.

Is the data in these SQL files real?

No. All data is generated with faker.js — realistic usernames, emails, and addresses but entirely fictional. Safe for development, testing, and demos.

What tables does the ecommerce schema include?

8 tables: users, products, categories, orders, order_items, payments, addresses, and reviews. 5,000 total rows with foreign key relationships between all tables.

Can I use these with an ORM like Prisma or SQLAlchemy?

Yes. Import the SQL dump to create the database, then connect your ORM. For Prisma, use prisma db pull to introspect the schema. For SQLAlchemy, use automap_base() to reflect tables.

Other data formats

JSON XML CSV Excel (XLSX)

Sample SQL Files — Database Dump Downloads for Testing

Sample SQL file preview

How to import a SQL file

Use cases for sample SQL files

Technical specifications

Frequently Asked Questions

Other data formats

Related reading

Database Seeding from SQL Dumps

MIME Type Detection in Production — A Practical Validation Pipeline

Audio Upload Validation and Server-Side Transcoding