E-commerce SQL Database Sample
Download a free e-commerce SQL database with 8 tables and 5,000 rows (200 KB). Includes products, categories, users, orders, order items, reviews, and more. Ideal for testing e-commerce backends, dashboard queries, and reporting.
sample-ecommerce.sql
245 KB
5,000 rows
Verified file details
- Filename
- sample-ecommerce.sql
- Exact size
- 251,375 bytes
- Displayed size
- 245 KB
- MIME type
- application/sql
- Rows
- 5,000
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-ecommerce.sql
Other SQL files
sample-mysql.sql
55.2 KB
1,000 rows
Verified file details
- Filename
- sample-mysql.sql
- Exact size
- 56,547 bytes
- Displayed size
- 55.2 KB
- MIME type
- application/sql
- Rows
- 1,000
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-mysql.sql
sample-postgresql.sql
55.4 KB
1,000 rows
Verified file details
- Filename
- sample-postgresql.sql
- Exact size
- 56,771 bytes
- Displayed size
- 55.4 KB
- MIME type
- application/sql
- Rows
- 1,000
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-postgresql.sql
sample-sqlite.sql
55.2 KB
1,000 rows
Verified file details
- Filename
- sample-sqlite.sql
- Exact size
- 56,555 bytes
- Displayed size
- 55.2 KB
- MIME type
- application/sql
- Rows
- 1,000
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-sqlite.sql
sample-users-table.sql
27.7 KB
500 rows
Verified file details
- Filename
- sample-users-table.sql
- Exact size
- 28,413 bytes
- Displayed size
- 27.7 KB
- MIME type
- application/sql
- Rows
- 500
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-users-table.sql
sample-blog.sql
228 KB
2,000 rows
Verified file details
- Filename
- sample-blog.sql
- Exact size
- 233,200 bytes
- Displayed size
- 228 KB
- MIME type
- application/sql
- Rows
- 2,000
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-blog.sql
sample-schema-only.sql
528 B
Verified file details
- Filename
- sample-schema-only.sql
- Exact size
- 528 bytes
- Displayed size
- 528 B
- MIME type
- application/sql
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/sql/sample-schema-only.sql
Frequently Asked Questions
What tables are in the e-commerce database?
Typical e-commerce schema: users, products, categories, orders, order_items, reviews, addresses, and payments. Tables have proper foreign key relationships for realistic join queries.
Can I use this to prototype an e-commerce app?
Yes. The schema follows common e-commerce patterns. Import it into MySQL, connect your backend (Node.js, Django, Laravel, etc.), and you have realistic seed data for products, orders, and user accounts.
What SQL dialect does this file use?
MySQL syntax. For PostgreSQL or SQLite, you'll need to adjust: AUTO_INCREMENT to SERIAL/AUTOINCREMENT, backticks to double quotes, and ENGINE=InnoDB clauses removed.
Other data formats
Similar files in other formats
sample-simple.json
87 B
1 rows
Verified file details
- Filename
- sample-simple.json
- Exact size
- 87 bytes
- Displayed size
- 87 B
- MIME type
- application/json
- Rows
- 1
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/json/sample-simple.json
sample-simple.xml
153 B
Verified file details
- Filename
- sample-simple.xml
- Exact size
- 153 bytes
- Displayed size
- 153 B
- MIME type
- application/xml
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/xml/sample-simple.xml
sample-1kb.yaml
1 KB
30 lines
Verified file details
- Filename
- sample-1kb.yaml
- Exact size
- 1,024 bytes
- Displayed size
- 1 KB
- MIME type
- application/octet-stream
- Lines
- 30
- Note
- simple-config
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/yaml/sample-1kb.yaml
sample-1kb.toml
1 KB
30 lines
Verified file details
- Filename
- sample-1kb.toml
- Exact size
- 1,024 bytes
- Displayed size
- 1 KB
- MIME type
- application/octet-stream
- Lines
- 30
- Note
- simple-config
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/toml/sample-1kb.toml