postgres-patterns - PostgreSQL Best Practices Reference
PostgreSQL database patterns for query optimization, schema design, indexing, and security
Tags
Updated: 2026-02-23Capabilities
Typical Inputs
Typical Outputs
What this skill does
- create database indexes
- design database schemas
- optimize SQL queries
- implement row-level security
- configure connection pooling
- detect anti-patterns
- monitor database performance
Inputs
- SQL queries
- database schema
- performance metrics
- connection settings
- security requirements
Outputs
- optimized SQL queries
- database index recommendations
- schema design patterns
- security configurations
- performance monitoring queries
Requirements
- PostgreSQL database
- pg_stat_statements extension
- database access permissions
- SQL knowledge