Prompt to Generate Realistic Database Seeds
Generates complete seed files with realistic, consistent and relationally valid data to populate your database in development.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
Tu es un développeur backend spécialisé en bases de données. Génère un fichier de seed complet et réaliste pour ma base de données.
Contexte du projet :
- Technologie / ORM utilisé : [TECHNOLOGIE_ORM] (ex : SQL brut, Prisma, Drizzle, Sequelize, Django ORM, Laravel Eloquent, TypeORM)
- Schéma des tables concernées : [SCHEMA_TABLES] (colle ici ta définition de tables, migrations ou modèles)
Consignes précises :
- Génère des données réalistes et cohérentes (noms, emails, dates, adresses plausibles — pas de "test123" ou "foo bar")
- Respecte toutes les contraintes du schéma : clés étrangères, types, NOT NULL, valeurs uniques, enums
- Crée au minimum 10 entrées par table principale et 3-5 par table de référence
- Assure la cohérence relationnelle : chaque clé étrangère doit pointer vers un enregistrement existant
- Inclus des cas limites utiles pour le développement : un utilisateur sans commandes, une commande avec plusieurs articles, un champ optionnel null
- Ajoute des commentaires expliquant la logique des données (pourquoi tel cas de test)
- Utilise la syntaxe native de l'ORM ou du format demandé (INSERT INTO, .create(), factories, JSON, CSV)
- Propose un ordre d'insertion qui respecte les dépendances entre tables
- Si pertinent, inclus un script d'exécution ou une commande pour lancer le seed
Format de sortie : fichier(s) de seed prêt(s) à l'emploi dans la syntaxe de [TECHNOLOGIE_ORM], avec commentaires.
Personalize this prompt with Léa
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
Why this prompt works
This prompt lets you quickly generate realistic seed data for your database, regardless of the ORM or technology used. By providing your table schema, the AI produces ready-to-use files with consistent data that respects your relational constraints. For best results, paste your migration file or schema definition directly into the [TABLE_SCHEMA] variable. The more precise the schema, the more faithful the generated seeds will be to your structure. Feel free to specify specific business rules (e.g., "an admin user must exist", "order dates must be within the last 6 months"). The seeds intentionally include edge cases — missing data, empty relationships, boundary values — to help you test your application under realistic conditions from the development stage. The proposed insertion order ensures that dependencies between tables are respected, avoiding foreign key errors.
Use Cases
Expected Output
One or more seed files in the chosen ORM syntax, containing realistic data with explanatory comments, an insertion order respecting dependencies, and useful edge cases for development and testing.
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
- LéaAI
Pour des seeds vraiment exploitables, précisez le secteur (e-commerce, SaaS...) et le volume (10, 100, 10k). Si vous voulez des jeux de données reproductibles, demandez un générateur seedé (ex: faker.seed(42)) plutôt que de l'aléatoire pur. Ajoutez aussi vos règles métier (ex: commandes annulées, statuts possibles) pour enrichir les cas limites.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Generate Mocks and Fixtures for Your Automated Tests
A prompt to automatically generate realistic mocks, stubs and data fixtures adapted to your test framework and use cases.
Prompt to Master SSR and Hydration with Next.js
A complete prompt to diagnose, implement and optimize Server-Side Rendering and hydration in a Next.js application, with common error handling.
Midjourney Prompt to Create a Prototype
Creating prototypes is a crucial step in any design process, whether for product design, digital interfaces, or physical objects. Traditionally, this phase requires skills in 3D modeling, industrial design, or model making—technical skills that can significantly slow down creative teams. Midjourney upends this approach by enabling the generation of photorealistic prototype visuals in just a few seconds. With well-crafted prompts, you can explore dozens of creative directions, test different materials, shapes, and finishes, and present compelling concepts to clients or investors without using CAD software. Whether you're a product designer looking to quickly validate an idea, an entrepreneur preparing a pitch deck, or a UX team wanting to visualize an interface concept on a physical device, Midjourney offers an unprecedented visual experimentation playground. The main challenge lies in prompt formulation: you need to guide the AI toward a render that resembles a real industrial prototype, with the right materials, appropriate studio lighting, and the level of detail expected by professionals.
Write a Helm chart
Package apps as Helm charts