Playgrounds →MockForge Live
Relational Mock Data & Fixture Playground
Paste any SQL DDL (`CREATE TABLE`) or Prisma Schema. MockForge parses dependencies using Kahn's DAG topological sorting, synthesizing 100% foreign-key consistent test fixtures directly in your browser with zero network transmission.
Wasm / 100% In-Memory
$0 Cloud FeeInput Schema (SQL / Prisma)
4-tier foreign key hierarchy: Users → Orders → Order Items & Paymentssql
Terminal Zero-Install:
npx @ritualdev-lab/mockforge generate schema.prismaSynthesized Fixtures (4 tables · 20 rows)
Rows:
Relational Referential Integrity Verified (0 Broken FKs)
json{
"users": [
{
"id": 11,
"name": "Alex Chen",
"email": "alex.kowalski+11@ritualdev.in",
"country": "United States",
"created_at": "2026-03-11T14:30:00Z"
},
{
"id": 12,
"name": "Jordan Kowalski",
"email": "jordan.patel+12@cloudcorp.io",
"country": "Germany",
"created_at": "2026-03-12T14:30:00Z"
},
{
"id": 13,
"name": "Taylor Patel",
"email": "taylor.dubois+13@matrix.org",
"country": "Japan",
"created_at": "2026-03-13T14:30:00Z"
},
{
"id": 14,
"name": "Morgan Dubois",
"email": "morgan.nakamura+14@enterprise.net",
"country": "India",
"created_at": "2026-03-14T14:30:00Z"
},
{
"id": 15,
"name": "Sam Nakamura",
"email": "sam.alvarez+15@apexlabs.dev",
"country": "Canada",
"created_at": "2026-03-15T14:30:00Z"
}
],
"orders": [
{
"id": 11,
"user_id": 11,
"order_number": "Val_order_number_11",
"total_amount": 224.99,
"2)": "Val_2)_11",
"status": "completed",
"created_at": "2026-03-11T14:30:00Z"
},
{
"id": 12,
"user_id": 12,
"order_number": "Val_order_number_12",
"total_amount": 242.49,
"2)": "Val_2)_12",
"status": "active",
"created_at": "2026-03-12T14:30:00Z"
},
{
"id": 13,
"user_id": 13,
"order_number": "Val_order_number_13",
"total_amount": 259.99,
"2)": "Val_2)_13",
"status": "completed",
"created_at": "2026-03-13T14:30:00Z"
},
{
"id": 14,
"user_id": 14,
"order_number": "Val_order_number_14",
"total_amount": 277.49,
"2)": "Val_2)_14",
"status": "active",
"created_at": "2026-03-14T14:30:00Z"
},
{
"id": 15,
"user_id": 15,
"order_number": "Val_order_number_15",
"total_amount": 294.99,
"2)": "Val_2)_15",
"status": "completed",
"created_at": "2026-03-15T14:30:00Z"
}
],
"order_items": [
{
"id": 11,
"order_id": 11,
"product_name": "Alex Chen",
"quantity": 22,
"unit_price": 224.99,
"2)": "Val_2)_11"
},
{
"id": 12,
"order_id": 12,
"product_name": "Jordan Kowalski",
"quantity": 24,
"unit_price": 242.49,
"2)": "Val_2)_12"
},
{
"id": 13,
"order_id": 13,
"product_name": "Taylor Patel",
"quantity": 26,
"unit_price": 259.99,
"2)": "Val_2)_13"
},
{
"id": 14,
"order_id": 14,
"product_name": "Morgan Dubois",
"quantity": 28,
"unit_price": 277.49,
"2)": "Val_2)_14"
},
{
"id": 15,
"order_id": 15,
"product_name": "Sam Nakamura",
"quantity": 30,
"unit_price": 294.99,
"2)": "Val_2)_15"
}
],
"payments": [
{
"id": 11,
"order_id": 11,
"payment_method": "Val_payment_method_11",
"transaction_ref": "Val_transaction_ref_11",
"is_successful": true
},
{
"id": 12,
"order_id": 12,
"payment_method": "Val_payment_method_12",
"transaction_ref": "Val_transaction_ref_12",
"is_successful": true
},
{
"id": 13,
"order_id": 13,
"payment_method": "Val_payment_method_13",
"transaction_ref": "Val_transaction_ref_13",
"is_successful": false
},
{
"id": 14,
"order_id": 14,
"payment_method": "Val_payment_method_14",
"transaction_ref": "Val_transaction_ref_14",
"is_successful": true
},
{
"id": 15,
"order_id": 15,
"payment_method": "Val_payment_method_15",
"transaction_ref": "Val_transaction_ref_15",
"is_successful": true
}
]
}DAG Topo Order
Deterministic Seeding
Zero-Cloud Transmission
Enterprise MockForge Architecture
Deterministic Kahn's DAG ordering with zero database credentials required.
1. Directed Acyclic Graph (DAG)
Kahn's algorithm evaluates primary-to-foreign key edges, guaranteeing parent tables are populated before child tables to eliminate constraint errors.
2. SOC 2 & HIPAA Sanitization
Never test with production PII. Synthesize photorealistic user, financial, and order records that pass validation schemas without security risk.
3. CI/CD Pipeline Integration
Use in GitHub Actions or Docker test containers: npx @ritualdev-lab/mockforge generate schema.sql --rows 500 runs in sub-100ms.