Postgresql Expert Best Practices Code Review

The postgresql-expert-best-practices-code-review skill enables AI agents to audit PostgreSQL database code against industry-standard best practices. It analyzes queries and schema definitions to identify performance bottlenecks, security vulnerabilities, and design flaws before deployment.

When to use it

• Before merging complex migration scripts into a production branch.
• When optimizing slow-running queries in high-traffic applications.
• To ensure new table schemas adhere to normalization rules and indexing strategies.
• During code reviews for stored procedures or functions to prevent logic errors.

Key capabilities

• Identifies inefficient SQL patterns such as N+1 query problems and missing indexes.
• Flags security risks including SQL injection vulnerabilities and weak authentication logic.
• Validates schema designs against normalization principles to reduce data redundancy.
• Detects potential deadlocks and transaction isolation issues in concurrent workloads.

Example prompts

• "Review this PostgreSQL migration script for performance issues and suggest optimizations."
• "Analyze the following stored procedure for SQL injection vulnerabilities and logic errors."
• "Check if this new table schema follows normalization rules and recommend necessary indexes."

Tips & gotchas

Ensure you provide the full context of the database environment, such as expected read/write loads, to get accurate performance recommendations. This skill focuses on code quality; it does not execute queries or alter live data directly.