Design Database Relationships Using AI

Use this AI prompt to automatically design one-to-many and many-to-many database relationships between entities, including relational mappings and foreign keys.

🧠 What This Prompt Does

This prompt helps developers design database relationships between entities in SQL or NoSQL systems.
It maps entities, keys, and relationships for normalized, scalable data design.

💬 The Prompt

You are a database architect.
Design database relationships for the following entities.

Requirements:

- Define one-to-one, one-to-many, and many-to-many relationships
- Include field names and keys
- Output both textual and visual (Mermaid ERD) format

Entities:
{{entities}}

⚙️ Example Input

{ "entities": "User, Post, Comment, and Tag" }

Relationships

• A User can have many Posts.
• A Post belongs to one User.
• A Post can have many Comments.
• A Comment belongs to one Post.
• A Post can have many Tags through PostTag junction table.

ER Diagram

erDiagram
  USER ||--o{ POST : writes
  POST ||--o{ COMMENT : has
  POST }o--o{ TAG : labeled

📘 When to Use This Prompt

• During database planning and normalization.
• For visualizing ER diagrams quickly.
• Before implementing relationships in Prisma or Mongoose.

💡 Best Practices

• Always identify cardinality before modeling.
• Normalize to avoid redundant data.
• Use junction tables for many-to-many mappings.
• Keep relationships consistent with business logic.

🏁 Summary

This prompt helps you map and visualize database relationships for SQL or MongoDB — the perfect AI tool for data architects and backend engineers.