PostgreSQL Skills
PostgreSQL database administration with psql. Query data, manage users, backups, and server configuration.
9 skills
PostgreSQL Connection Pooling with PgBouncer
Configure PgBouncer for PostgreSQL connection pooling — transaction vs session pooling, sizing pool limits, monitoring connections, and handling prepared statements.
Reading EXPLAIN ANALYZE Like a Pro
Decode PostgreSQL EXPLAIN ANALYZE output — understand node types, costs, buffer usage, timing breakdowns, and common performance patterns to diagnose slow queries.
PostgreSQL Index Strategy & Design
Master PostgreSQL indexing — B-tree, GIN, GiST, BRIN index types, partial indexes, covering indexes, and composite index column ordering for optimal query performance.
Zero-Downtime PostgreSQL Migrations
Execute safe schema migrations on production PostgreSQL databases — adding columns, creating indexes concurrently, renaming tables, and avoiding locks that block reads and writes.
Postgres Best Practices
Postgres performance optimization and best practices from Supabase.
PostgreSQL Optimization
PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.
PostgreSQL Best Practices
- Designing a schema for PostgreSQL - Selecting data types and constraints - Planning indexes, partitions, or RLS policies.
SQL Optimization Patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.
SQL Pro
Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques.