Fake Database Testing
Use these prompts to generate and clear dummy data for testing purposes.
Create
Generate realistic dummy data in JSON format based on my specifications:
DATA TYPE: [user profiles / products / blog posts / transactions / etc]
QUANTITY: [number] items
FIELDS NEEDED: [list the fields you want, e.g., name, email, age, address, etc]
REQUIREMENTS:
- Output valid JSON array format only
- Make data realistic and varied (different names, realistic dates, varied numbers)
- For names: use diverse, international names
- For emails: use various domains (@gmail, @yahoo, @outlook, etc)
- For dates: use ISO format (YYYY-MM-DD) within the last 2 years
- For prices: use realistic ranges with 2 decimal places
- For text content: vary length and style
- For images: use placeholder URLs like https://placehold.co/600x400
- Include no markdown formatting, just raw JSON
EXAMPLE REQUEST:
"Generate 10 user profiles with: firstName, lastName, email, age (18-65), city, signupDate, isPremium (boolean), avatar (placeholder URL)"
OUTPUT FORMAT:
[
{
"field1": "value",
"field2": "value"
}
]
Now generate data for: [YOUR SPECIFICATION HERE]Destroy
CLEAR ALL DUMMY/TEST DATA PROMPT:
I need to remove all test/dummy data from my application. Given the context provided [PASTE YOUR APP CODE/DATABASE SETUP HERE]:
1. Identify all locations where dummy data might be stored:
- Database tables
- localStorage
- sessionStorage
- JSON files
- API endpoints with test data
- State management stores
2. Generate code/commands to safely delete ALL test data:
- SQL DELETE statements (with WHERE clauses to protect real data if mixed)
- localStorage.clear() or specific key removal
- API calls to delete endpoints
- File deletion commands
- Reset database to empty state
3. Provide both:
- DESTRUCTIVE VERSION: Deletes everything (for pure test environments)
- SAFE VERSION: Only deletes data matching dummy data patterns (e.g., emails ending in @example.com, names from dummy generator, dates in test range)
4. Include verification queries to:
- Check what data exists before deletion
- Confirm data was deleted after running commands
- Count remaining records
5. Add rollback instructions in case of mistakes
FORMAT OUTPUT AS:
ā ļø BEFORE YOU RUN - Backup Check:
[Commands to verify what will be deleted]
šļø DESTRUCTIVE DELETE (Use only in test/dev):
[Commands to delete everything]
š”ļø SAFE DELETE (Targets only dummy data patterns):
[Commands to delete only test data]
ā
VERIFICATION:
[Commands to confirm deletion worked]
š ROLLBACK (if you made a mistake):
[Commands to restore, if backups exist]
My application uses: [DATABASE TYPE - e.g., "localStorage only", "PostgreSQL", "MongoDB", "Firebase", "Supabase", etc.]
Generate the cleanup code for my specific setup.