Reviews PostgreSQL code for optimal indexing, JSONB performance, connection pooling, and transaction safety.
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.
Key Features
01Security checks for parameterized statements and SQL injection
0214 GitHub stars
03Connection pool configuration and leak detection
04Performance analysis for SQL queries and indexing strategies
05Transaction safety and isolation level verification
06Optimization of JSONB operations and GIN index usage
Use Cases
01Troubleshooting slow JSONB queries in high-scale applications
02Reviewing backend connection management to prevent resource leaks
03Auditing database schema migrations for optimal indexing patterns
