postgresql-code-review
PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. Covers JSONB operations, array usage, custom types, schema design, function optimization, and PostgreSQL-exclusive security features like Row Level Security (RLS).
Security Assessment
About postgresql-code-review
The 'postgresql-code-review' skill serves as an expert assistant for conducting code reviews in PostgreSQL. It focuses on evaluating SQL code specifically tailored to PostgreSQL, ensuring adherence to PostgreSQL best practices, avoiding anti-patterns, and optimizing code for performance. The skill addresses common issues such as improper JSONB usage, inefficient array operations, poor schema design, and lack of PostgreSQL-specific security features like Row Level Security (RLS). This skill helps developers improve code quality and streamline PostgreSQL-specific implementations, making it easier to identify potential inefficiencies or errors in database schema and queries.
FAQ
How does the PostgreSQL Code Review assistant work?
The assistant reviews SQL code for PostgreSQL-specific best practices, checking for common anti-patterns, performance issues, and misuses of PostgreSQL features such as JSONB and array operations. It provides recommendations for improvements and offers sample code snippets for better practices.
Is this skill compatible with all versions of PostgreSQL?
The skill focuses on PostgreSQL best practices and features that are widely supported, but some advanced functionalities may require specific PostgreSQL versions (e.g., newer features in JSONB or Row Level Security). Make sure your PostgreSQL version supports the used features.
Can this skill review entire PostgreSQL projects or only individual SQL statements?
The skill can review both individual SQL queries and entire PostgreSQL projects. If no specific selection is made, it will review the entire project, focusing on PostgreSQL best practices and standards.
Are there any limitations in terms of performance with large databases?
While the skill emphasizes efficient PostgreSQL code, performance issues in very large databases or highly complex queries might require additional manual optimizations. The skill suggests best practices, but scalability concerns may need a deeper analysis of the environment.
Install postgresql-code-review
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill
Repository
github/awesome-copilot