postgresql-code-review Skill for Claude Code: PostgreSQL-Specific Code Review

Skill that makes your assistant review code for PostgreSQL-specific pitfalls in JSONB, arrays, schema design, triggers and Row Level Security.

Installs: 12.7K; on skills.sh
Stars: 40.7K; on GitHub
Updated: Oct 2026; last repo commit

Ask for a review of a schema, query or function and the assistant checks it against PostgreSQL's own features instead of generic SQL rules. It flags unindexed JSONB and array queries, weak data types, inefficient trigger functions and loose privileges, and shows a better version of each.

SKILL.md reviews your selection, or the whole project if nothing is selected. It is one file and bundles no scripts.

Good for

Backend developers reviewing PostgreSQL schemas and migrations
Teams adopting Row Level Security and role-based privileges
Anyone tuning JSONB, array or trigger code

Install postgresql-code-review

Claude Code

Copy this prompt.

Install the postgresql-code-review skill in Claude Code. Run this command:

npx skills add https://github.com/github/awesome-copilot --skill postgresql-code-review

Then check that it loaded and tell me how to use it.

2
Paste it into Claude Code. It shows the change and asks before running it.

Requires Node.js.

From its listing on skills.sh. Source.

What's in the skill

When it loads

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).

Sections in SKILL.md

🎯 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
🎯 PostgreSQL Code Quality Checklist
Schema Design

Key facts

Author: GitHub community collection (awesome-copilot, described in its README as community-created)
License: MIT (crawl data)
Installs on skills.sh: 12,686 as of 2026-11-02
GitHub stars: 40,666 for the whole github/awesome-copilot repo, 2026-11-02
Last repo commit: 2026-10-30
Files: 1 file: SKILL.md; no scripts

What it includes

Flags unindexed ->> filters and prefers containment queries with GIN indexes.
Read · JSONB review
Prefers GIN-indexed containment queries over ANY() scans and bulk updates over loops.
Read · Array review
Prefers BIGSERIAL, CITEXT, TIMESTAMPTZ, JSONB and CHECK constraints.
Read · Schema design
Suggests ENUM types and domains for constrained values.
Read · Custom types and domains
Performance, schema design, and function and trigger issues.
Read · Anti-pattern lists
Checks use of uuid-ossp, pgcrypto and pg_trgm.
Read · Extension usage
Row Level Security policies and granular privileges instead of GRANT ALL.
Read · Security review
Four groups: schema design, performance, PostgreSQL features, security and compliance.
Read · Quality checklist
Seven focus areas, from data types to security implementation.
Read · Review guidelines

From the official docs

Questions

What does the postgresql-code-review skill do?

It makes your assistant review PostgreSQL code against PostgreSQL-specific best practices. It covers JSONB, arrays, schema design, custom types, functions, extensions and Row Level Security.

How do I install it?

Use the install box at the top of this page. The skill is one Markdown file. The repo README also documents a plugin route built for GitHub Copilot CLI: copilot plugin install database-data-management@awesome-copilot. That plugin adds 2 agents and 4 skills (postgresql-code-review, postgresql-optimization, sql-code-review, sql-optimization), so use the box above if you only want this one.

Does it need a database connection or API key?

SKILL.md names neither. It describes reviewing code you select or the project, and bundles no scripts.

Is it safe?

The skill is one Markdown file that bundles no scripts. Its examples include SQL such as CREATE INDEX, ALTER TABLE and GRANT, which your assistant shows as examples. Our advice: review any migration it writes before you run it.

Does it work in the Claude app or claude.ai?

No client list is documented for this skill. It is a single Markdown file, and the install box lists the ways to add it.

Does it only work for PostgreSQL?

Yes. SKILL.md says to focus on PostgreSQL-specific practices and to avoid treating it as a generic SQL database.

Information

updated Nov 2, 2026

Repository: github/awesome-copilot
Folder: skills/postgresql-code-review

github/awesome-copilot skills.sh

Sources

Docs, issue trackers and discussions this page is built from.

Show all 3

SKILL.md · github.com
README.md · github.com
database-data-management plugin.json · github.com