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

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.

Other SQL files

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-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.

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

JSON XML CSV Excel (XLSX)

Similar files in other formats

sample-simple.json

87 B

1 rows

Download

File details and verification

Filename: sample-simple.json
Exact size: 87 bytes
Displayed size: 87 B
Catalog status: Valid catalog fixture
SHA-256: 2ed7134796dcc9670f375f725f09c73fd518f6d2e463dd31081137a4bd068235
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/json
Rows: 1
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/json/sample-simple.json

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

sample-simple.xml

153 B

Download

File details and verification

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

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

sample-1kb.yaml

1 KB

30 lines

Download

File details and verification

Filename: sample-1kb.yaml
Exact size: 1,024 bytes
Displayed size: 1 KB
Catalog status: Valid catalog fixture
SHA-256: 2e383ce376f7cdea9bc326b12d679a226657fff5a9e1f99cda389caa956f5863
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/octet-stream
Lines: 30
Note: simple-config
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/yaml/sample-1kb.yaml

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

sample-1kb.toml

1 KB

30 lines

Download

File details and verification

Filename: sample-1kb.toml
Exact size: 1,024 bytes
Displayed size: 1 KB
Catalog status: Valid catalog fixture
SHA-256: 5321484b28dd4dd11e150116a8e70e97e8d5d953bb38a6340a13766822d35faf
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/octet-stream
Lines: 30
Note: simple-config
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/toml/sample-1kb.toml

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