Looking for a realistic UK sample database for SQL practice, software testing, or demo data? This is a modern alternative to AdventureWorks and Northwind — with balanced double-entry accounting, HMRC tax compliance, and 3 years of simulated business operations.
A realistic, relational business dataset generated by simulating a UK retail SME 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 dataset: 42 tables, 39,000+ rows, CSV + SQL + Parquet + SQLite — $49 on Gumroad
| Field | Value |
|---|---|
| Company | Peak District Outdoor Supplies Ltd |
| Industry | Retail (outdoor/camping equipment) |
| Country | UK (West Midlands) |
| Structure | Ltd (Limited company) with CRN + UTR |
| Period | 6 April 2024 – 5 April 2026 |
| Financial Year | April–March (UK tax year) |
- PAYE income tax — Personal Allowance £12,570, Basic 20%, Higher 40%, Additional 45%
- Employee National Insurance — 10% (£12,570–£50,270), 2% above
- Employer National Insurance — 13.8% above £9,100
- VAT — 20% standard rate on all sales and purchases
- Auto-enrolment pension — 3% employer + 5% employee
- Monthly payroll with real HMRC withholding calculations
Every payslip satisfies: Gross = Net + PAYE + NI. Every journal entry balances: debits = credits.
git clone https://github.com/MindweaveTech/uk-sme-dataset-sample.git
cd uk-sme-dataset-sample
sqlite3 :memory: <<'SQL'
.mode csv
.import companies.csv companies
.import chart_of_accounts.csv coa
.import sales_orders_sample.csv sales_orders
SELECT name, country, structure FROM companies;
SELECT count(*) as total_sales FROM sales_orders;
SELECT name FROM coa WHERE name LIKE '%VAT%' OR name LIKE '%NI%' OR name LIKE '%PAYE%';
SQLFull reference tables: companies, departments, chart_of_accounts (59 accounts — UK terminology: Trade Debtors, VAT, PAYE, Employer NI, Pension), products (25 SKUs), customers
Sampled transactions: sales_orders (200 rows), journal_entries (200 rows), employees (full)
| Feature | AU | US | UK |
|---|---|---|---|
| Tax system | ATO PAYG + GST | IRS + FICA | HMRC PAYE + NI |
| Sales tax | GST 10% | ~7.5% state | VAT 20% |
| Pension/Super | Super 11.5% | 401(k) 4% | Auto-enrolment 8% |
| Payroll frequency | Fortnightly | Fortnightly | Monthly |
| Financial year | July–June | Calendar | April–March |
| Company structure | Pty Ltd | LLC | Ltd |
| Salary range | A$50K–85K | $35K–70K | £24K–42K |
View all products at mindweave.tech/datasets.
| Product | Country | Tables | Rows | Price |
|---|---|---|---|---|
| UK Complete | UK | 42 | 39,000+ | $49 |
| AU Complete | AU | 42 | 83,000+ | $49 |
| US Complete | US | 42 | 78,000+ | $49 |
| Product | Industry | Rows | Price |
|---|---|---|---|
| UK Pub & Kitchen | Hospitality | 180,000+ | $79 |
| UK Advisory Firm | Professional Services | 109,000+ | $79 |
| UK Multi-Company | Retail (3 companies) | 124,000+ | $99 |
Also on Payhip, Kaggle, and Hugging Face.
Sample database, test data, dummy data, synthetic data, AdventureWorks alternative, Northwind alternative, SQL practice database, UK business dataset, HMRC test data, PAYE, VAT, National Insurance, accounting test data, mock data, demo database.
Free for development, testing, training, and evaluation. Full dataset commercially licensed — see mindweave.tech/datasets.
Built by Mindweave Technologies | Dev.to: AdventureWorks Is Dead | Dev.to: 5 Reasons AdventureWorks Is Terrible