database-design
Installation
SKILL.md
When to Use
- Designing a new database schema
- Reviewing or refactoring existing schemas
- Planning migrations or data model changes
- Choosing data types, indexes, or constraints
- Defining naming conventions for tables, columns, or relationships
Instructions
1. Understand the Domain First
Before writing any DDL, map the business entities and their relationships. Use the conceptual → logical → physical flow:
- Conceptual: Entities, relationships, business rules (ER diagram)
- Logical: Attributes, keys, normal forms (independent of technology)
- Physical: Data types, indexes, partitions, engine-specific features