postgresql - PostgreSQL Schema and Table Design
Design PostgreSQL schemas using data types, constraints, indexes, performance practices, and advanced features.
Tags
Updated: 2026-10-04Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Design PostgreSQL schemas
- Select data types
- Define constraints
- Plan indexes
- Validate query plans
- Plan partitioning and RLS
- Review migration safety
Inputs
- Entity definitions
- Access patterns
- Scale targets
- Data retention requirements
- Access control requirements
- Migration context
Outputs
- Schema design recommendations
- DDL recommendations
- Index recommendations
- Constraint recommendations
- Migration safety findings
Requirements
- PostgreSQL database
- Compatible PostgreSQL version
- Production backup and rollback plan
- Staging environment