postgresql-code-review
๐ฏSkillfrom github/awesome-copilot
|Reviews PostgreSQL code for best practices, anti-patterns, and quality standards with detailed improvement recommendations.
Overview
This skill provides PostgreSQL-specific code review focusing on features and best practices unique to PostgreSQL. It covers JSONB operations, array usage, custom types, schema design with PostgreSQL-optimized data types, function and procedure optimization, and PostgreSQL-exclusive security features like Row Level Security (RLS).
Key Features
- JSONB Best Practices - Reviews JSONB usage for proper GIN indexing, containment operators (@>), constraint validation, and efficient querying patterns instead of text extraction operators
- Array Operations Review - Evaluates array queries for GIN index support, bulk array operations, and proper use of array containment operators for optimal performance
- PostgreSQL Schema Optimization - Ensures use of PostgreSQL-specific types (UUID, TIMESTAMPTZ, TEXT, SERIAL/IDENTITY), proper constraint definitions, and optimized schema patterns
- Row Level Security (RLS) - Audits RLS policy implementations, FORCE ROW LEVEL SECURITY settings, and policy granularity for multi-tenant and role-based data access
- Function & Procedure Review - Analyzes PL/pgSQL functions for proper VOLATILE/STABLE/IMMUTABLE markings, security definer settings, and query plan optimization
Who is this for?
PostgreSQL developers and database architects who need code reviews focused specifically on PostgreSQL features rather than generic SQL best practices. Ideal for teams building applications on PostgreSQL who want to fully leverage its unique capabilities including JSONB, arrays, custom types, and Row Level Security.
Same repository
github/awesome-copilot(224 items)
Installation
npx vibeindex add github/awesome-copilot --skill postgresql-code-reviewnpx skills add github/awesome-copilot --skill postgresql-code-review~/.claude/skills/postgresql-code-review/SKILL.mdSKILL.md
More from this repository10
A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.
A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.
Generates comprehensive Product Requirements Documents (PRDs) by systematically analyzing requirements and crafting detailed technical specifications
A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.
Generates Excalidraw diagrams from natural language descriptions, creating visual representations of processes, systems, relationships, and ideas.
Expert technical writer guided by the Diataxis framework, creating tutorials, how-to guides, reference docs, and explanation pages for software documentation.
Automates browser interactions, debugging, and performance analysis using Chrome DevTools for comprehensive web page inspection and control.
Provides Spring Boot best practices covering project setup, dependency injection, REST API design, data access with JPA, security configuration, and testing strategies.
A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.
Manages GitHub Issues through the GitHub API, enabling creation, searching, labeling, and triaging of issues directly from the coding environment.