postgres-patterns - PostgreSQL Best Practices for Database Optimization
Provides PostgreSQL patterns for query optimization, schema design, indexing, and security
Tags
Updated: 2026-02-23Capabilities
Typical Inputs
Typical Outputs
What this skill does
- query PostgreSQL databases
- create database indexes
- design database schemas
- optimize SQL queries
- implement security policies
Inputs
- PostgreSQL database
- SQL queries
- Database schema
- Performance metrics
Outputs
- Index recommendations
- Schema design patterns
- Query optimization suggestions
- Security policy templates
Requirements
- PostgreSQL database access
- SQL knowledge
- Database design experience