postgresql-table-design - Design PostgreSQL schemas with sound data modeling
Designs PostgreSQL-specific schemas using appropriate data types, constraints, indexes, partitioning, and performance patterns.
Tags
Updated: 2026-10-01Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Design normalized schemas
- Select PostgreSQL data types
- Define keys and constraints
- Create query-focused indexes
- Apply partitioning strategies
- Configure row-level security
Inputs
- Schema requirements
- Query access patterns
- Data volume estimates
- PostgreSQL version
Outputs
- Schema design recommendations
- PostgreSQL DDL guidance
- Indexing recommendations
- Constraint recommendations