Agent skill · research science · github
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).
Why this skill is useful
Provides PostgreSQL-specific best practices and anti-patterns that the AI wouldn't reliably generate on its own.
What it needs
About 4k tokens when loaded. Last updated 2026-08-07. 37,534 stars on the source repository.
What this skill does
PostgreSQL Code Review Assistant Expert PostgreSQL code review for ${selection} (or entire project if no selection). Focus on PostgreSQL-specific best practices, anti-patterns, and quality standards that are unique to PostgreSQL. 🎯 PostgreSQL-Specific Review Areas JSONB Best Practices Array Operations Review PostgreSQL Schema Design Review Custom Types and Domains 🔍 PostgreSQL-Specific Anti-Patterns Performance Anti-Patterns Avoiding PostgreSQL-specific indexes: Not using GIN/GiST for appropriate data types Misusing JSONB: Treating JSONB like a simple string field Ignoring array operators: Using inefficient array operations Poor partition key selection: Not leveraging PostgreSQL partitioning effectively Schema Design Issues Not using ENUM types: Using VARCHAR for limited value sets Ignoring constraints: Missing CHECK constraints for data validation Wrong data types: Using VARCHAR instead of TEXT or CITEXT Missing JSONB structure: Unstructured JSONB without validation Function and Trigger Issues 📊 PostgreSQL Extension Usage Review Extension Best Practices 🛡️ PostgreSQL Security Review Row Level Security (RLS) Privilege Management 🎯 PostgreSQL Code Quality Checklist Schema Design [ ] Using appropriate PostgreSQL data types (CITEXT, JSONB, arrays) [ ] Leveraging ENUM types for constrained values [ ] Implementing proper CHECK constraints [ ] Using TIMESTAMPTZ instead of TIMESTAMP [ ] Defining custom domains for reusable constraints Performance Considerations [ ] Appropriate index types (GIN for JSONB/arrays, GiST for ranges) [ ] JSONB queries using containment operators (@>, ?) [ ] Array operations using PostgreSQL-specific operators [ ] Proper use of window functions and CTEs [ ] Efficient use of PostgreSQL-specific functions PostgreSQL Features Utilization [ ] Using extensions where appropriate [ ] Implementing stored procedures in PL/pgSQL when beneficial [ ] Leveraging PostgreSQL's advanced SQL features [ ] Using PostgreSQL-specific optimization techniques [ ] …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills github/postgresql-code-review