QA Utility Tool — Full stack

Test Data Generator for SDET Teams

Deterministic commerce bundles (users, orders, line items, cards), SQL & Playwright exports, JSON Schema sampling, and REST endpoints for CI (GET/POST /api/test-data/generate).

Synthetic QA data only

Phones use fictional ranges (US: 555-010-xxxx; India-style synthetic prefixes). Emails use reserved .test TLDs — not for real inboxes. Card fields are random last-four / metadata only, not real PAN/bank data. Do not use for SMS, voice, or production identity — QA and CI fixtures only.

Template & generation

Template ID

Template version

Locale

Seed

Users (size)

Max orders / user

Dataset options

Include order line items (totals reconcile with order subtotal)Include payment cards (token-like, not real PAN)Include negative edge cases (invalid email, zero order, expired card)

Same template + seed + version produces the same dataset — safe for reproducible CI runs.

Dataset summary

Users

Orders

Line items

Cards

Export entity

Selected rows

0 users records

SQL export (adjust table names)

Users table

Orders table

Line items table

Cards table

Synthetic data only. Rename columns in SQL to match your schema before running in production databases.

Playwright / TypeScript fixture

Export variable prefix

Commerce preview

First 6 rows of users.

[]

REST API for CI

POST /api/test-data/generate (JSON body) or GET /api/test-data/generate?... for quick curls.

POST body example

{
  "templateId": "tdg-commerce-v1",
  "templateVersion": "1.0.0",
  "locale": "india",
  "seed": 20260504,
  "size": 200,
  "maxOrdersPerUser": 4,
  "includeCards": true,
  "includeLineItems": true,
  "includeEdgeCases": true,
  "entity": "users"
}

GET example (capped size in URL)

curl -s "/api/test-data/generate?seed=20260504&size=100&locale=india&entity=all&templateId=tdg-commerce-v1&maxOrdersPerUser=4"

JSON Schema sampling

Paste a JSON Schema with root type: object and properties. Generates QA-friendly sample rows (strings, numbers, enums, nested objects — best-effort).

Rows

Seed

[
  {
    "requestId": "id_640993",
    "amount": 44884,
    "currency": "EUR",
    "paid": true
  },
  {
    "requestId": "id_257332",
    "amount": 52706,
    "currency": "INR",
    "paid": true
  },
  {
    "requestId": "id_878927",
    "amount": 47284,
    "currency": "INR",
    "paid": true
  },
  {
    "requestId": "id_771163",
    "amount": 30769,
    "currency": "INR",
    "paid": true
  },
  {
    "requestId": "id_717950",
    "amount": 61101,
    "currency": "INR",
    "paid": false
  },
  {
    "requestId": "id_853603",
    "amount": 5215,
    "currency": "USD",
    "paid": false
  },
  {
    "requestId": "id_340260",
    "amount": 6271,
    "currency": "INR",
    "paid": true
  },
  {
    "requestId": "id_577302",
    "amount": 2809,
    "currency": "INR",
    "paid": true
  }
]

Server-side: POST { "mode": "schema", "jsonSchema": {...}, "schemaSampleCount": 50, "seed": 1 } to /api/test-data/generate.