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
1,000 rows
sample-postgresql.sql
1,000 rows
sample-sqlite.sql
1,000 rows
sample-users-table.sql
500 rows
sample-ecommerce.sql
5,000 rows
sample-blog.sql
2,000 rows
sample-schema-only.sql
sample-data-only.sql
2,000 rows
sample-large.sql
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', '[email protected]'),
('bob_smith', '[email protected]');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) |
Frequently Asked Questions
Other data formats
Related reading
Database Seeding from SQL Dumps
Populate test databases with realistic data. MySQL, PostgreSQL, and SQLite sample dumps. Fixtures for users, orders, and time-series data.
PDF Parsing and Text Extraction — A Practical Guide
Extract text, metadata, and structure from PDF files with pdf.js and pdf-parse. Handle scanned PDFs with OCR. Sample PDFs from 1KB to 100MB for every test case.
Testing Word and Excel Uploads in Production
Validating DOCX and XLSX uploads — size limits, macro detection, corrupted files, and viewer compatibility. Sample office files for every edge case.