Postgres Schema and Migration

When to use

Invoke when designing a new PostgreSQL schema, introducing a service persistence layer, planning schema evolution, reviewing indexes, performing production migrations, or preparing large-scale data changes.

Do not use for schemaless databases, NoSQL/document stores, graph databases, analytics warehouses, or ORM-only modeling discussions.

Inputs

Required:

• Domain entities, relationships, and ownership boundaries.
• Known access patterns or API/system design context.

Optional: