postgresql - Design and optimize PostgreSQL queries and schemas
Write advanced PostgreSQL queries, analyze execution plans, design indexes, handle concurrent writes, and plan safe schema migrations.
Tags
Updated: 2026-09-30Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Write window function queries
- Build recursive CTEs
- Query and update JSONB
- Design PostgreSQL indexes
- Interpret EXPLAIN ANALYZE output
- Handle concurrent writes
- Write upsert statements
- Plan schema migrations
Inputs
- SQL query requirements
- Database schema
- Table and column statistics
- Migration requirements
- Concurrency requirements
Outputs
- SQL queries
- Index definitions
- Execution plan analysis
- Migration plans
- Concurrency control statements
Requirements
- PostgreSQL 14 or later
- PostgreSQL query support