postgres-code-review

What it does

This skill enables AI agents to perform automated code reviews specifically for PostgreSQL database schemas and migrations. It analyzes SQL changes to identify potential issues, enforce best practices, and ensure schema integrity before deployment.

When to use it

• Before deploying a new migration script to production environments.
• When reviewing complex schema changes involving foreign keys or indexes.
• To validate that SQL queries adhere to your team's coding standards.
• During pull request workflows for database-related code changes.

Key capabilities

• Automated analysis of PostgreSQL schema modifications.
• Detection of common SQL anti-patterns and errors.
• Validation of migration logic for data integrity.
• Feedback generation on query performance implications.

Example prompts

• "Review this PostgreSQL migration script for potential syntax errors or logical flaws."
• "Analyze the provided schema change and suggest improvements based on database best practices."
• "Check if these foreign key constraints are correctly defined in my migration file."

Tips & gotchas

Ensure your AI agent has access to the full context of the PostgreSQL dialect being used, as specific syntax variations can affect review accuracy. This skill focuses on code quality and schema logic rather than runtime performance testing.