Schema Design

Purpose

Design relational database schemas with normalization trade-offs, migration plans, and indexing strategies. Produces migration-ready SQL that can be applied directly to the database.

Scope Constraints

• Produces schema definitions and migration SQL only; does not execute migrations.
• Covers entity design, relationships, indexes, RLS policies, and rollback plans.
• Does not define API contracts or endpoint shapes — hand off to api-design.

Inputs

• Feature requirements (from interview/idea phase)
• Existing schema (current tables, relationships, migrations)
• Query patterns (how the data will be read — drives index and denormalization decisions)
• Access control requirements (who can read/write which rows)