postgresql-code-review — Skills

What it does

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

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

PostgreSQL code review assistant covering JSONB, arrays, custom types, schema design, and security best practices.

Source

Repository: https://github.com/github/awesome-copilot

postgresql-code-review FAQ

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). Avoiding PostgreSQL-specific indexes: Not using GIN/GiST for appropriate data types Misusing JSONB: Treating JSONB like a simple string field

How do I install postgresql-code-review?

Run: npx -y skills add https://github.com/github/awesome-copilot --skill postgresql-code-review --agent claude-code — the source lives at github.com/github/awesome-copilot.

Maintain postgresql-code-review?

Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.

[![postgresql-code-review on getagentictools](https://getagentictools.com/badge/skills/github-awesome-copilot-postgresql-code-review.svg)](https://getagentictools.com/skills/github-awesome-copilot-postgresql-code-review?ref=badge)

npx agentictools info skills/github-awesome-copilot-postgresql-code-review

The second line is the CLI lookup for this page — handy in READMEs and docs.