postgresql-code-review

What problem does it solve?

This Skill provides expert code review specifically for PostgreSQL, ensuring your database code adheres to best practices, avoids common anti-patterns, and leverages PostgreSQL's unique features for optimal performance and security.

Core Features & Use Cases

• Best Practice Enforcement: Analyzes code for PostgreSQL-specific best practices in areas like JSONB operations, array usage, schema design, and function optimization.
• Anti-Pattern Detection: Identifies and explains common performance and schema design pitfalls unique to PostgreSQL.
• Security Review: Checks for proper implementation of security features like Row Level Security (RLS) and granular privilege management.
• Use Case: Submit your complex PL/pgSQL functions or schema definitions for a thorough review to catch potential performance bottlenecks or security vulnerabilities before they impact your production environment.

Quick Start

Review the provided PostgreSQL code snippet for best practices and potential issues.