Random Test Data Generator

Generate synthetic tables with typed fields, ranges, uniqueness, nullable values and real foreign-key relationships.

Define synthetic fixtures

Schema JSON

{
  "tables": [
    {
      "name": "users",
      "rows": 5,
      "fields": [
        {
          "name": "id",
          "type": "id"
        },
        {
          "name": "name",
          "type": "name"
        },
        {
          "name": "email",
          "type": "email",
          "unique": true
        },
        {
          "name": "status",
          "type": "enum",
          "values": [
            "active",
            "trial",
            "paused"
          ]
        }
      ]
    },
    {
      "name": "orders",
      "rows": 15,
      "fields": [
        {
          "name": "id",
          "type": "id"
        },
        {
          "name": "user_id",
          "type": "foreign",
          "ref": "users.id"
        },
        {
          "name": "total",
          "type": "decimal",
          "min": 5,
          "max": 200,
          "decimals": 2
        },
        {
          "name": "created",
          "type": "date",
          "start": "2026-01-01",
          "end": "2026-12-31"
        }
      ]
    }
  ]
}

Up to 8 tables, 20 fields each, 5,000 rows per table and 10,000 rows total. Declare referenced tables first.Seed (optional)

Field types and options

Types: id, integer, decimal, boolean, string, name, email, enum, date, uuid, foreign. Use min/max for numbers, decimals for precision, length for strings, values for enums, start/end for dates, unique for distinct non-null values, nullPercent for nullable values and ref for a parent table’s ID or unique field. ID fields are non-null, sequential primary keys.

Your result

Ready when you are

Generate related tables with ranges, uniqueness, nullable fields and foreign keys. Edit the starter schema or use its 20-row example.

How to use this tool

Generate synthetic tables with typed fields, ranges, uniqueness, nullable values and real foreign-key relationships.

Edit the starter JSON schema. Declare parent tables before referencing them.
Choose an optional seed and generate. Preview up to 100 rows of a selected table.
Export all tables as JSON or SQL, or download a selected table as CSV.

About the results

This browser version supports 10,000 total rows, 8 tables and 20 fields per table. IDs are sequential primary keys; nullable unique values may have multiple nulls. It does not offer AI schema design, hosted APIs or million-row exports. Records are synthetic fixtures, not real identities or security credentials.