# Generate realistic test or mock data

Realistic synthetic datasets in CSV, JSON, or SQL for testing and demos.

- Topic: Software Development
- Framework: Few-Shot
- Level: Standard
- Tags: Fill-in Template
- Source: https://www.thinkwithprompt.com/prompts/generate-realistic-test-or-mock-data

## Prompt

```text
Generate realistic mock data.

**What it's for:** [testing, a demo, a prototype, a training exercise]
**Schema:** [fields, types, constraints — or paste a table definition]
**Number of rows:** [NUMBER]
**Realism requirements:** [distributions, relationships between fields, locales, edge cases to include]
**Format:** [CSV / JSON / SQL INSERT statements]

Rules:
- Values must be plausible and internally consistent (e.g. order dates after signup dates; totals that add up).
- Include a few deliberate edge cases (empty optional fields, long strings, boundary values) and list them.
- Use obviously fake personal data (e.g. example.com emails, 555 numbers) — never real people's data.

For more than ~50 rows, give me a small sample plus a script (Python or SQL) that generates the full set.
```

## What to fill in

- testing, a demo, a prototype, a training exercise
- fields, types, constraints — or paste a table definition
- NUMBER
- CSV / JSON / SQL INSERT statements

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.