postgresql-table-design - Design PostgreSQL schemas with practical best practices
Designs PostgreSQL-specific schemas using guidance on data types, normalization, constraints, indexing, performance patterns, and advanced features.
Tags
Updated: 2026-10-01Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Design normalized schemas
- Select PostgreSQL data types
- Define keys and constraints
- Plan query-driven indexes
- Apply partitioning patterns
- Configure row-level security
- Evaluate storage performance
Inputs
- Schema requirements
- Query access patterns
- Data constraints
- PostgreSQL version
- Available extensions
Outputs
- PostgreSQL schema design
- Index recommendations
- Constraint recommendations
- Performance design guidance