Generate realistic test or mock data
Realistic synthetic datasets in CSV, JSON, or SQL for testing and demos.
The prompt
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.
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Software Development prompts
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
How this prompt is built
This prompt follows the Few-Shot structure (Few-shot prompting). A few-shot prompt includes one or more worked examples of the input and the output you want, so the model can copy the pattern instead of guessing it.
Related prompts
- Analyze logs to find what went wrongReads logs to identify errors, patterns, and the likely root cause.
- Break my first coding project into small buildable stepsA milestone plan where every step leaves you with a working program and tells you what to learn next.
- Get unstuck on a coding error with hints instead of the answerA plain-English explanation of your error and step-by-step hints, so you learn to debug instead of copying a fix.
- Get a beginner-friendly code review of my first projectA ranked set of the five improvements that matter most, explained simply, plus what you did well and what to learn next.