What specific PostgreSQL features does this skill review?

It focuses on indexing strategies, JSONB operations, connection pooling, and transaction safety including isolation levels and lock management.

Does it support JSONB optimization?

Absolutely. it reviews JSONB operators like @> and ? and ensures GIN indexes are properly applied to JSONB columns for efficient querying.

Can it help prevent SQL injection?

Yes, the skill includes specific checks to ensure all database queries use parameterized statements rather than unsafe string concatenation.

How does it handle transaction reviews?

It identifies potential deadlocks, checks for appropriate isolation levels, and ensures that transactions are not held open too long, preventing resource contention.

PostgreSQL Code Review

Name: PostgreSQL Code Review
Author: existential-birds

byexistential-birds

•

Gestión de Bases de Datos

Reviews PostgreSQL code for optimal indexing, JSONB performance, connection pooling, and transaction safety.

Acerca de

The postgres-code-review skill provides specialized guidance for optimizing PostgreSQL databases within Claude Code. It evaluates SQL queries for proper indexing strategies, analyzes JSONB operations for GIN index usage, ensures robust connection pooling configurations, and verifies transaction isolation levels to prevent deadlocks and performance bottlenecks. This skill is indispensable for backend developers and DBAs who need to ensure their database interactions are performant, secure from SQL injection, and architecturally sound during the development process.

Características Principales

Security checks for parameterized statements and SQL injection
14 GitHub stars
Connection pool configuration and leak detection
Performance analysis for SQL queries and indexing strategies
Transaction safety and isolation level verification
Optimization of JSONB operations and GIN index usage

Casos de Uso

Troubleshooting slow JSONB queries in high-scale applications
Reviewing backend connection management to prevent resource leaks
Auditing database schema migrations for optimal indexing patterns

Acerca de

Características Principales

Security checks for parameterized statements and SQL injection
14 GitHub stars
Connection pool configuration and leak detection
Performance analysis for SQL queries and indexing strategies
Transaction safety and isolation level verification
Optimization of JSONB operations and GIN index usage

Casos de Uso

Troubleshooting slow JSONB queries in high-scale applications
Reviewing backend connection management to prevent resource leaks
Auditing database schema migrations for optimal indexing patterns