Database Design

When to Use

• User says "design a database" or "create a schema"
• User says "write a migration" or "add a column safely"
• User asks to "optimize this query" or "add an index"
• User wants zero-downtime migration advice
• User asks about normalization, denormalization, or constraints

Workflow: Designing a Schema

Step 1: Understand the Domain

Ask the user:

• What entities exist and how do they relate?
• What are the read vs write patterns?
• Expected data volume and growth rate?
• Any multi-tenancy requirements?