Sample Business Database
April 10, 2026 · View on GitHub
Looking for a realistic sample database for SQL practice, software testing, or demo data? This is a modern alternative to AdventureWorks and Northwind — with balanced accounting, real tax compliance, and 3 years of simulated business operations.
Realistic, relational business datasets generated by simulating SMEs day-by-day over 3 financial years. Every transaction flows through double-entry accounting. Not random data — simulated business operations.
Free to use for development, testing, training, and evaluation.
Full datasets: 42 tables, 39K–83K rows, CSV + SQL + Parquet + SQLite — mindweave.tech/datasets | Kaggle (AU sample)
Three Variants
| Variant | Company | Compliance | Directory |
|---|---|---|---|
| Australian | Outback Outdoor Supplies Pty Ltd | ATO PAYG, GST 10%, BAS, Super 11.5% | ./ (root) |
| US | Summit Outdoor Gear LLC | IRS federal tax, FICA, ~7.5% sales tax | ./us/ |
| UK | Peak District Outdoor Supplies Ltd | HMRC PAYE, NI 10%, VAT 20%, Pension 3%+5% | ./uk/ |
Each variant has the same 42-table structure with 44 foreign key relationships, but with genuinely different tax rules, salary ranges, payroll frequency, financial year, and locale-specific data.
Quick Start
# Clone and explore
git clone https://github.com/MindweaveTech/sme-sim-sample.git
cd sme-sim-sample
# Australian data (root directory)
sqlite3 :memory: <<'SQL'
.mode csv
.import companies.csv companies
.import sales_orders_sample.csv sales_orders
SELECT name, country FROM companies;
SELECT count(*) as total_sales FROM sales_orders;
SQL
# US data
sqlite3 :memory: <<'SQL'
.mode csv
.import us/companies.csv companies
.import us/sales_orders_sample.csv sales_orders
SELECT name, country FROM companies;
SELECT count(*) as total_sales FROM sales_orders;
SQL
# UK data
sqlite3 :memory: <<'SQL'
.mode csv
.import uk/companies.csv companies
.import uk/sales_orders_sample.csv sales_orders
SELECT name, country FROM companies;
SELECT count(*) as total_sales FROM sales_orders;
SQL
What makes this different from AdventureWorks / Northwind / Faker
| Feature | AdventureWorks | Northwind | Faker/Mockaroo | sme-sim |
|---|---|---|---|---|
| Cross-domain traceability | Partial | No | No | Full — sale > invoice > payment > bank > journal entry |
| Double-entry accounting | No | No | No | Yes — debits always equal credits |
| Tax compliance | US-only | None | None | AU + US + UK |
| Temporal realism | Static | Static | Random | Simulated — seasonal patterns, staff turnover, payment behaviour |
| Relational integrity | Good | Basic | None | 44 FK relationships, all enforced |
| Still maintained | Last updated 2014 | Last updated ~2000 | N/A | 2025 |
Sample contents per variant
Each directory contains full reference tables plus sampled transaction tables (~200 rows each from the full dataset).
Reference tables: companies, departments, chart_of_accounts, products, customers, _row_counts
Sampled tables: sales_orders_sample, journal_entries_sample, employees_sample
Who this is for
- Developers building ERP, accounting, or business software
- QA teams testing complex business workflows across modules
- Consultants running demos and training without exposing client data
- Data engineers building ETL pipelines against a realistic source
- Students studying business systems and accounting
- AI/ML teams needing realistic business data for training
Full datasets & products
View all products at mindweave.tech/datasets.
Australian
| Product | Tables | Rows | Price |
|---|---|---|---|
| Free Sample (this repo) | 26 | ~2,800 | Free |
| Complete SME Dataset | 42 | 83,000+ | $49 |
| Multi-Company Bundle | 126 | 246,000+ | $99 |
| Enterprise Pack | 210 | 400,000+ | $199 |
US
| Product | Tables | Rows | Price |
|---|---|---|---|
| US Complete | 42 | 78,000+ | $49 |
| US Multi-Company | 126 | 230,000+ | $99 |
UK
| Product | Tables | Rows | Price |
|---|---|---|---|
| UK Complete | 42 | 39,000+ | $49 |
| UK Multi-Company | 126 | 124,000+ | $99 |
Industry Verticals
| Product | Industry | Rows | Price |
|---|---|---|---|
| AU Restaurant & Pub | Hospitality | 226,000+ | $79 |
| US Restaurant & Bar | Hospitality | 259,000+ | $79 |
| UK Pub & Kitchen | Hospitality | 180,000+ | $79 |
| AU Consulting Firm | Professional Services | 143,000+ | $79 |
| US Consulting Firm | Professional Services | 156,000+ | $79 |
| UK Advisory Firm | Professional Services | 109,000+ | $79 |
Also available on Kaggle and Hugging Face.
Keywords
Sample database, test data, dummy data, synthetic data, AdventureWorks alternative, Northwind alternative, SQL practice database, business dataset, accounting test data, ERP test data, double-entry accounting, mock data, demo database.
License
This sample is free to use for development, testing, training, and evaluation. Full datasets are commercially licensed — see mindweave.tech/datasets for terms.
Built by Mindweave Technologies | Dev.to: AdventureWorks Is Dead | Dev.to: 5 Reasons AdventureWorks Is Terrible