postgresql-table-design - Design PostgreSQL-specific table schemas
Designs PostgreSQL-specific schemas with guidance on data types, constraints, indexing, performance, partitioning, and advanced features.
Tags
Updated: 2026-10-01Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Design PostgreSQL schemas
- Choose PostgreSQL data types
- Define constraints and keys
- Plan query-oriented indexes
- Apply performance patterns
- Use advanced PostgreSQL features
Inputs
- Schema requirements
- Query access patterns
- Data volume estimates
- Data lifecycle requirements
- PostgreSQL version
- Extension availability
Outputs
- Schema design guidance
- Table and column definitions
- Constraint recommendations
- Index recommendations
- Partitioning recommendations