postgres-code-review

Review PostgreSQL queries by examining WHERE and JOIN clauses to identify columns lacking indexes, then validate against query plans to confirm performance impact. The Skill guides analyzing index strategies to eliminate sequential scans and improve execution efficiency.

JSONB operators like @>, ->, and @@ serve different query patterns; pair them with appropriate GIN indexes for fast lookups. The Skill recommends matching operators to your access patterns and validating index applicability to prevent full-table scans on JSON columns.

Transaction safety requires choosing correct isolation levels, managing connection pooling to prevent leaks, and applying appropriate locking patterns. The Skill reviews your SQL and connection lifecycle to identify unsafe commits, race conditions, and improper resource handling.

Yes. The Skill applies to SQL queries and schemas across application stacks, including ORM data access layers. It identifies indexing gaps, JSONB misuse, and transaction issues whether code is hand-written or framework-generated.

Connection pooling review detects improper lifecycle handling—unclosed connections, exhausted pool limits, and incorrect configuration. The Skill ensures your application reuses connections safely and avoids resource exhaustion in production.

Isolation levels control how concurrent transactions interact; wrong choices cause dirty reads, phantom reads, or unnecessary lock contention. The Skill validates your isolation settings and locking patterns match your data consistency requirements.