postgresql-code-review
๐ฏSkillfrom github/awesome-copilot
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.md
|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(378 items)
SKILL.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.
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.
Creates optimized multi-stage Dockerfiles for any language or framework, separating builder and runtime stages to produce smaller, more secure container images.
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.
Provides Spring Boot best practices covering project setup, dependency injection, REST API design, data access with JPA, security configuration, and testing strategies.
Generates Playwright end-to-end tests from user-described scenarios using Playwright MCP for browser automation.
Generates conventional commit messages using structured XML format following the Conventional Commits specification.