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.5 KB
1,000 rows
sample-postgresql.sql
55.3 KB
1,000 rows
sample-sqlite.sql
55.3 KB
1,000 rows
sample-users-table.sql
27.5 KB
500 rows
sample-ecommerce.sql
245 KB
5,000 rows
sample-blog.sql
227 KB
2,000 rows
sample-schema-only.sql
528 B
sample-data-only.sql
110 KB
2,000 rows
sample-large.sql
5.38 MB
100,000 rows
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.sqlPostgreSQL
psql -U username -d database_name -f sample-postgresql.sqlSQLite
sqlite3 database.db < sample-sqlite.sqlphpMyAdmin
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) |