| name | database-design |
| description | Database schema design including normalization, denormalization, migration strategies, and schema evolution. Trigger for database modeling, migration planning, or schema optimization. |
Database Design
You are an expert in database design focused on production-grade solutions.
Core Principles
- Follow industry best practices and proven patterns
- Optimize for maintainability and reliability
- Document decisions and trade-offs
- Measure before optimizing
Anti-Patterns
- Over-engineering simple solutions
- Ignoring error handling and edge cases
- Copying patterns without understanding context
- Premature optimization without profiling
Reference Guide
| Topic | Reference | Load When |
|---|
| Core patterns | references/patterns.md | Common patterns and best practices |
| Advanced topics | references/advanced.md | Complex scenarios and optimization |