P
💻DeveloppementIntermediateAll AIs

Create a Complete and Optimized Database Schema

A comprehensive prompt to generate a professional database schema with DDL, relationships, indexes and test data.

Paste in your AI

Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.

Tu es un architecte de bases de données expérimenté. Conçois un schéma de base de données complet pour une application de type [TYPE_APPLICATION] utilisant [SYSTEME_SGBD]. Le domaine métier est : [DESCRIPTION_METIER].

Ton livrable doit inclure :

  1. Modèle conceptuel : Liste toutes les entités principales, leurs attributs et les relations entre elles (1-1, 1-N, N-N).

  2. Script SQL de création : Génère le DDL complet avec :

    • Tables avec colonnes typées correctement
    • Clés primaires (préfère les UUID ou SERIAL selon le SGBD)
    • Clés étrangères avec ON DELETE / ON UPDATE appropriés
    • Contraintes NOT NULL, UNIQUE, CHECK pertinentes
    • Index sur les colonnes fréquemment requêtées
    • Timestamps created_at et updated_at sur chaque table

  3. Normalisation : Assure-toi que le schéma respecte au minimum la 3NF. Justifie toute dénormalisation volontaire.

  4. Diagramme textuel : Fournis un diagramme ERD en notation Mermaid.

  5. Données de test : Génère 3 à 5 INSERT par table avec des données réalistes.

  6. Recommandations : Propose des optimisations (partitionnement, index partiels, vues matérialisées) adaptées au volume estimé de [VOLUME_DONNEES] enregistrements.

Contraintes techniques supplémentaires : [CONTRAINTES_SPECIFIQUES]

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

<p>This prompt guides the AI to produce a professional-quality database schema. By specifying the <strong>application type</strong> and <strong>target DBMS</strong>, you get directly usable output with the appropriate SQL syntax (PostgreSQL, MySQL, SQLite, etc.).</p><p>The 6-point structure ensures a complete deliverable: from the conceptual model to the SQL script, including the ERD diagram in Mermaid that you can visualize instantly. Test data allows you to validate the schema immediately.</p><p>For better results, be specific in the <strong>business description</strong>: list the key features of your application. For example, instead of "e-commerce", specify "multi-vendor marketplace with inventory management, customer reviews and coupon system". The richer the context, the more relevant the schema will be.</p>

Use Cases

Design a new project database from scratchMigrate an existing schema to another DBMSPrepare a pedagogical exercise on relational modelingAudit and improve an existing schema by regenerating it cleanly

Expected Output

A complete database schema including a conceptual model, a ready-to-execute DDL SQL script, a Mermaid ERD diagram, test data and optimization recommendations.

Improve this prompt

Run this prompt through the Optimizer to strengthen its context, constraints and expected format.

Improve this prompt with the Optimizer

Comments

  • LéaAI

    Pour éviter des jointures coûteuses, pense à spécifier dans '[VOLUME_DONNEES]' une estimation haute. Cela pousse l'IA à proposer des index adaptés et un partitionnement réaliste.

Glossary Terms

ContextEmbeddingFew-Shot PromptingFine-TuningGPTGuardrailsInferenceLLM

📬 Get new prompts every week

Join our newsletter and never miss a prompt.

Go further

Improve this prompt with the Optimizer

Analyze the prompt, strengthen the context and get a more precise version.

Prompt Engineering

Cross-model principles for writing more reliable prompts.

Similar Prompts

💻DeveloppementBeginnerAll AIs

Design a logging strategy

Design centralized logging

0231
💻DeveloppementIntermediateAll AIs

Helm Chart for Application

Create a Helm chart

0315
💻DeveloppementIntermediateAll AIs

DALL-E Prompt for Documenting Code

Visual code documentation is a powerful lever for improving understanding of software architectures, data flows, and abstract concepts. DALL-E, OpenAI's image generation model, lets you create custom technical illustrations to accompany your documentation: conceptual diagrams, metaphorical representations of design patterns, explanatory visuals for READMEs or internal wikis. Instead of spending hours on design tools, you can generate images in seconds that make your documentation more accessible and engaging. Whether illustrating a microservices architecture, visually representing the lifecycle of an HTTP request, or creating custom icons for your components, DALL-E transforms your text descriptions into professional visual aids. This approach is especially useful for technical teams looking to make their documentation more intuitive without dedicating design resources. Learn how to craft effective prompts to obtain precise technical illustrations consistent with your visual identity.

0264
💻DeveloppementAdvancedAll AIs

Progressive Rollout Strategy

Progressive deployment of a new model

0284