VISUAL LAB · EXPLORE, UNDERSTAND, EXPORT

Relational Test Dataset Builder

Generate reproducible customers and linked orders, tune ranges and regions, inject documented validation errors and export CSV, JSON, SQL or a ZIP bundle.

Interactive examplesBrowser processingCharts + data exports

Explore a preset, then edit the controls. Results update when you leave a field or select an option.

A worked example

Generate five customers and twelve orders with zero errors. Every order references an existing customer and occurs on or after that customer joined.

Scope and practical limits

1–1,000 customers and 0–5,000 orders. A fixed two-table schema; no arbitrary schema designer. Amounts are decimal strings. Seeded data is fictional and predictable.

Work is processed in your browser. Download a project to keep your settings; nothing is saved automatically. Advertising and analytics follow the website’s privacy and consent settings.

Using Relational Test Dataset Builder

Generate reproducible customers and linked orders, tune ranges and regions, inject documented validation errors and export CSV, JSON, SQL or a ZIP bundle.

Choose a preset to see a worked example, then edit the labeled values.
Inspect the live chart and result summary. Read any warnings about assumptions or unsupported inputs.
Review the calculation table, which shows 50 rows per page. Exports contain all available result rows.
Export the chart as SVG or PNG and the data as CSV or JSON. Save a project to reopen your inputs later.

Example

Generate five customers and twelve orders with zero errors. Every order references an existing customer and occurs on or after that customer joined.

Questions & answers

What errors can I inject?

Missing amounts, invalid dates and broken customer references. The issue manifest records each injected field error. A percentage is a probability, not an exact row quota.

Can I import the SQL directly?

The SQL targets SQLite with transaction and foreign-key enforcement. Clean data should import. Deliberately invalid fixtures can fail constraints; use JSON or CSV to test invalid data pipelines.

Can I keep editing later?

Save project downloads the inputs and options as JSON. Open project restores that file. Undo and redo remain available during this tab session.

Are images and data exports free?

Yes. Chart SVG/PNG and data CSV/JSON exports do not require an account. Specialized exports are shown beside the result when supported.