postgresql-code-review

What problem does it solve?

This Skill enhances PostgreSQL database code by identifying anti-patterns, optimizing performance, and ensuring adherence to best practices specific to PostgreSQL.

Core Features & Use Cases

• Best Practice Enforcement: Analyzes SQL and PL/pgSQL for PostgreSQL-specific optimizations and anti-patterns.
• Performance Tuning: Identifies inefficient queries, indexing strategies, and data type usage.
• Security Auditing: Reviews security configurations like Row Level Security (RLS) and privilege management.
• Use Case: Submit your complex PL/pgSQL functions or schema definitions for a thorough review to ensure they are performant, secure, and idiomatic to PostgreSQL.

Quick Start

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