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).
Profile →npx skills add github/awesome-copilot --skill postgresql-code-review --agent copilot
Same command for any agent — swap --agent for claude-code, codex, cursor.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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 ```sql -- ❌ BAD: Inefficient JSONB usage SELECT * FROM orders WHERE data->>'status' = 'shipped'; -- No index support -- ✅ GOOD: Indexable JSONB queries CREATE INDEX idx_orders_status ON orders USING gin((data->'status')); SELECT * FROM orders WHERE data @> '{"status": "shipped"}'; -- ❌ BAD: Deep nesting without consideration UPDATE orders SET data = data || '{"shipping":{"tracking":{"number":"123"}}}'; -- ✅ GOOD: Structured JSONB with validation ALTER TABLE orders ADD CONSTRAINT valid_status CHECK (data->>'status' IN ('pending', 'shipped', 'delivered')); ``` ### Array Operations Review ```sql -- ❌ BAD: Inefficient array operations SELECT * FROM products WHERE 'electronics' = ANY(categories); -- No index -- ✅ GOOD: GIN indexed array queries CREATE INDEX idx_products_categories ON products USING gin(categories); SELECT * FROM products WHERE categories @> ARRAY['electronics']; -- ❌ BAD: Array c
- 🎯 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
- Schema Design Issues
- Function and Trigger Issues
- 📊 PostgreSQL Extension Usage Review
- Extension Best Practices
- 🛡️ PostgreSQL Security Review
- Row Level Security (RLS)
- Privilege Management
What does the postgresql-code-review skill do?
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).
How do I install it?
Run `npx skills add github/awesome-copilot --skill postgresql-code-review --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From github/awesome-copilot, a repository with 37,432 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.