RichScriptsProducts →
TEST DATA THAT JOINS CORRECTLY

Relational
Test Data Package

Customers, orders and line items that actually connect. Generate fictional rows from a JSON schema, with consistent keys and a check report.

Build your package →

Free five-row previews · US$9 / ZIP package · No subscription

Developer laptop with connected database tables
AI-created product scene · Illustrative, not an app screenshot
ONE SCHEMA. CONNECTED TABLES.

Customers → Orders
Orders → Items

CSV files per table
SQL Server CREATE + INSERT scripts
Primary / foreign-key checks
Seed & schema for repeatable runs

Fictional values generated locally. No database connection or real customer data required.

1. Define your schema

JSON schema format, up to 20 tables and 20 columns per table. Use the shop example to start.

Supported schema & limits

Each table has a name and columns. Column types: integer, decimal, string, boolean, date, datetime, uuid. Optional flags: primaryKey, unique, nullable. A references object contains table and column names. Use one integer/string/uuid primary key per table. Foreign keys must reference a primary or unique column with the same type. Cyclic and composite keys, CHECK constraints, enums, defaults, identity columns and raw SQL DDL are not supported.

Use SQL Server scripts only in an isolated test database. Generated names, emails and values are fictional placeholders. Constraint checks cover the declared keys, nullability, types and uniqueness; they do not validate business rules or production compatibility.

2. Set the dataset

1–500 rows per table, up to 10,000 rows total. The same schema, row count and seed produce the same data.