postgres-patterns - PostgreSQL Database Patterns and Optimization Guide
Reference for PostgreSQL best practices including query optimization, schema design, indexing, and security
Tags
Updated: 2026-02-23Capabilities
Typical Inputs
Typical Outputs
What this skill does
- provide query optimization guidance
- suggest index types
- recommend data types
- show common patterns examples
- detect anti-patterns
- provide configuration templates
Inputs
- SQL queries
- database schema
- performance requirements
Outputs
- optimization recommendations
- configuration suggestions
- pattern examples
Requirements
- PostgreSQL environment access
- database design context
- SQL knowledge