SynthForge SynthForge SynthForge IO

Realistic test data for your database
in seconds, not afternoons.

Describe your database in plain English and get multi-table test data with the foreign keys intact. The first 20,000 rows of every dataset are free.

  1. Describe it

    customers, their orders, and the line items on each order

  2. Get a schema

    customers

    • customer_id PK
    • first_name
    • last_name
    • email

    orders

    • order_id PK
    • customer_id FK
    • order_date
    • status

    order_items

    • order_item_id PK
    • order_id FK
    • quantity
    • line_price
  3. Get rows, keys intact

    customers
    customer_idfirst_namelast_nameemail
    1 Judy Jefferson bradmendez@example.net
    2 Robert Masoner hartnatasha@example.org
    3 Joseph Iverson nancyvargas@example.com
    4 Jeffrey Edmonson thunter@example.com
    orders
    order_idcustomer_idorder_datestatus
    1 1 2024-09-18T04:03:14 delivered
    7 2 2024-10-01T07:17:34 returned
    8 2 2025-02-08T18:40:20 delivered
    9 2 2025-10-03T03:46:24 canceled
    11 3 2024-04-05T07:52:51 returned
    15 4 2025-04-19T20:14:24 returned
    order_items
    order_item_idorder_idquantityline_price
    1 1 1 71.97
    2 1 3 14.76
    3 1 4 306.04
    21 7 1 420.61
    22 7 5 659.5
    23 7 4 1958.32
Every highlighted row belongs to the same customer. These are rows from the free sample pack, generated by the product.

See SynthForge IO in action

Foreign keys, not just foreign key columns

Pick a customer. Every order that belongs to them lights up, because the generator wrote those keys to point at rows that exist.

Customers
orders
order_idcustomer_idorder_datestatus
112024-09-18T04:03:14delivered
722024-10-01T07:17:34returned
822025-02-08T18:40:20delivered
922025-10-03T03:46:24canceled
1132024-04-05T07:52:51returned
1542025-04-19T20:14:24returned

Explore what SynthForge IO can do

Start Designing Your Data Model

Design once, generate realistic datasets with referential integrity.