Design data models, database schemas, and ORM definitions.

Process

Identify context:

• Identify the database technology (Postgres, MySQL, SQLite, Mongo, etc.)

• Identify the ORM/Framework (Prisma, TypeORM, SQLAlchemy, Django, etc.)

• Understand the entity relationships (1:1, 1:N, M:N)

Research and design:

• Lookup framework best practices for defining models and relationships (use WebSearch/WebFetch)

• Design the schema/entity relationship considering scalability and normalization

Execute based on goal:

• New Schema: Generate SQL DDL or ORM model definitions

• Modification: Analyze current schema vs desired state, generate migration steps

• Validation: Check for normalization issues or N+1 query risks in relationships

Output

• Schema Design (ER Diagram description or Model code)

• Migration Plan (SQL or CLI commands)

• Rationale (Why these types/indices were chosen)