# Postgresql code review

> Postgresql code review is an open-source agent skill for databases. PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. It is available on Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose.

- **Kind:** Skill
- **Pricing:** Open source
- **Platforms:** Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
- **Website:** https://github.com/github/awesome-copilot/tree/main/skills/postgresql-code-review
- **Repository:** https://github.com/github/awesome-copilot
- **GitHub stars:** 41,254
- **License:** MIT
- **Skill name:** postgresql-code-review
- **Collection:** https://github.com/github/awesome-copilot
- **Categories:** databases, developer tools
- **Listing updated:** 2026-11-17

## About

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

## When your agent uses it

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

## What it can access

From a static check of the files on GitHub; nothing was run.

- [Instructions only, no scripts](https://github.com/github/awesome-copilot/tree/HEAD/skills/postgresql-code-review)
- [License: MIT](https://github.com/github/awesome-copilot/tree/HEAD/skills/postgresql-code-review)

## Install

### Claude Code

Copy the skill folder to `~/.claude/skills/postgresql-code-review` to use it in all your projects:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/github/awesome-copilot.git "$tmp" &&
mkdir -p ~/.claude/skills &&
rm -rf ~/.claude/skills/postgresql-code-review &&
cp -R "$tmp/skills/postgresql-code-review" ~/.claude/skills/postgresql-code-review &&
rm -rf "$tmp"
```

For one project only, put the folder in `.claude/skills/postgresql-code-review` inside it instead.

### Codex

Copy the skill folder to `~/.agents/skills/postgresql-code-review` to use it in every repository:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/github/awesome-copilot.git "$tmp" &&
mkdir -p ~/.agents/skills &&
rm -rf ~/.agents/skills/postgresql-code-review &&
cp -R "$tmp/skills/postgresql-code-review" ~/.agents/skills/postgresql-code-review &&
rm -rf "$tmp"
```

For one repository only, put the folder in `.agents/skills/postgresql-code-review` inside it instead.

### Cursor

Copy the skill folder to `~/.cursor/skills/postgresql-code-review` to use it in every project:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/github/awesome-copilot.git "$tmp" &&
mkdir -p ~/.cursor/skills &&
rm -rf ~/.cursor/skills/postgresql-code-review &&
cp -R "$tmp/skills/postgresql-code-review" ~/.cursor/skills/postgresql-code-review &&
rm -rf "$tmp"
```

For one project only, put the folder in `.cursor/skills/postgresql-code-review` inside it instead.

### Gemini CLI

Run in a terminal (add `--scope workspace` to install it for the current workspace only):

```sh
gemini skills install https://github.com/github/awesome-copilot.git --path skills/postgresql-code-review
```

Or copy the folder to `~/.gemini/skills/postgresql-code-review` yourself.

### VS Code

For GitHub Copilot in VS Code, copy the skill folder to `~/.copilot/skills/postgresql-code-review`:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/github/awesome-copilot.git "$tmp" &&
mkdir -p ~/.copilot/skills &&
rm -rf ~/.copilot/skills/postgresql-code-review &&
cp -R "$tmp/skills/postgresql-code-review" ~/.copilot/skills/postgresql-code-review &&
rm -rf "$tmp"
```

For one project only, put the folder in `.github/skills/postgresql-code-review` inside it instead.

### Other agents

Get the folder:

```sh
git clone --depth 1 https://github.com/github/awesome-copilot.git
```

Then copy `awesome-copilot/skills/postgresql-code-review` into your agent's skills folder as `postgresql-code-review`. Agents that support SKILL.md read one folder per skill.

## FAQ

### How do I install Postgresql code review in Claude Code?

Copy the skill folder from GitHub to ~/.claude/skills/postgresql-code-review to use it in all your projects, or to .claude/skills/postgresql-code-review in one project.

### Does Postgresql code review run scripts?

No. It is instructions only, with no scripts. This comes from a static check of the files on GitHub; nothing was run. Read the files before you install it.

### Which AI agents can use Postgresql code review?

Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose. Each reads skills in the SKILL.md format from its own folder; the install steps on this page list them.

### What are the best alternatives to Postgresql code review?

The closest alternatives to Postgresql code review are Rea changelog update, Code review, Gem devops guidelines, Github codespaces efficiency and Github copilot starter.

## Alternatives

- [Rea changelog update](https://ai-powered.com/skills/rea-changelog-update): Rea changelog update is an open-source agent skill for developer tools.
- [Code review](https://ai-powered.com/skills/code-review-mattpocock): Code review is an open-source agent skill for developer tools.
- [Gem devops guidelines](https://ai-powered.com/skills/gem-devops-guidelines): Gem devops guidelines is an open-source agent skill for cloud and infrastructure.
- [Github codespaces efficiency](https://ai-powered.com/skills/github-codespaces-efficiency): Github codespaces efficiency is an open-source agent skill for developer tools.
- [Github copilot starter](https://ai-powered.com/skills/github-copilot-starter): Github copilot starter is an open-source agent skill for developer tools.
- [Reviewing oracle to postgres migration](https://ai-powered.com/skills/reviewing-oracle-to-postgres-migration): Reviewing oracle to postgres migration is an open-source agent skill for databases.
- [Pinecone rag](https://ai-powered.com/skills/pinecone-rag): Pinecone rag is an open-source agent skill for knowledge and memory.
- [SQL optimization](https://ai-powered.com/skills/sql-optimization): SQL optimization is an open-source agent skill for databases.

---
Source: https://ai-powered.com/skills/postgresql-code-review
