PostgreSQL Skill

Roadmap Alignment: roadmap.sh/postgresql-dba
Reference: PostgreSQL Official Documentation

Status: Initial scaffold. Foundational guidance for PostgreSQL development and administration.

When to Use This Skill

• Writing and reviewing SQL queries and schema designs
• Creating database migrations (standalone or framework-integrated)
• Performance tuning and index optimization
• Database security and access control
• Connection pooling and transaction management
• Replication and backup strategies

Core Standards

1. Query Best Practices