Postgresql Expert Best Practices Code Review

PostgreSQL database design, migration, and performance optimization best practices. This skill should be used when writing, reviewing, or refactoring database schemas, migrations, or query patterns. Triggers on tasks involving PostgreSQL databases, schema design, migration optimization, or data modeling.

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add wispbit-ai/skills --skill postgresql-expert-best-practices-code-review
Manual install
git clone --depth 1 https://github.com/wispbit-ai/skills.git /tmp/skills
mkdir -p ~/.claude/skills
cp -r /tmp/skills/skills/postgresql-expert-best-practices-code-review ~/.claude/skills/postgresql-expert-best-practices-code-review

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# PostgreSQL Expert Best Practices

Simple, pragmatic, opinionated. Only what matters for writing production-grade PostgreSQL queries.

## When to Apply

Reference these guidelines when:
- Writing database migrations or schema changes
- Creating or modifying PostgreSQL tables and columns
- Adding indexes, constraints, or foreign keys
- Reviewing database schema for performance issues
- Refactoring existing database structures
- Optimizing query performance or database design

## Rule Categories by Priority

| Priority | Category | Impact | Prefix |
|----------|----------|--------|--------|
| 1 | Index Management | CRITICAL-HIGH | `only-concurrent-indexes`, `add-index-for-foreign-key` |
| 2 | Constraint Safety | HIGH | `unique-constraint`, `split-foreign-key`, `set-column-not-null` |
| 3 | Schema Design | MEDIUM | `only-jsonb`, `always-include-columns`, `limit-non-unique-index` |
| 4 | Naming Standards | LOW | `index-naming-standards`, `column-naming-standards` |

## Quick Reference

- `only-concurrent-indexes` - Always use CONCURRENTLY to prevent blocking writes during index creation
- `add-index-for-foreign-key` - Create indexes for foreign keys to improve query performance
- `unique-constraint` - Split unique constraint creation into concurrent index + constraint steps
- `split-foreign-key` - Add foreign keys without validation first, then validate separately
- `set-column-not-null` - Use check constraints before setting NOT NULL to avoid table locks
Read the full skill on GitHub

Details

Skill name
postgresql-expert-best-practices-code-review
Path
skills/postgresql-expert-best-practices-code-review/SKILL.md
Repo updated
11 February 2026

FAQ

What does the Postgresql Expert Best Practices Code Review skill do?

PostgreSQL database design, migration, and performance optimization best practices. This skill should be used when writing, reviewing, or refactoring database schemas, migrations, or query patterns. Triggers on tasks involving PostgreSQL databases, schema design, migration optimization, or data modeling.

How do I install the Postgresql Expert Best Practices Code Review skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add wispbit-ai/skills --skill postgresql-expert-best-practices-code-review. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Postgresql Expert Best Practices Code Review popular?

It lives in wispbit-ai/skills, which has 9 GitHub stars and 0 forks.

Related skills

Graphql Expert Best Practices

9

wispbit-ai/skills

GraphQL performance optimization and best practices for building scalable APIs. This skill should be used when writing, reviewing, or refactoring GraphQL schemas, resolvers, or query execution code. Triggers on tasks involving GraphQL APIs, resolver optimization, query performance, or data fetching patterns.

Software Development

Python Expert Best Practices Code Review

9

wispbit-ai/skills

Python best practices for writing production-grade code. This skill should be used when writing, reviewing, or refactoring Python code. Triggers on tasks involving Python development, error handling patterns, dictionary operations, and code quality improvements.

Software Development

Rust Expert Best Practices Code Review

9

wispbit-ai/skills

Rust best practices and code quality guidelines for writing idiomatic, safe, and performant Rust code. This skill should be used when writing, reviewing, or refactoring Rust code. Triggers on tasks involving Rust programming, code review, error handling, type safety, or performance optimization.

Software Development

Prismatic Embedded

9

prismatic-io/agent-skills

Embed Prismatic in a customer-facing web application, including a backend endpoint that signs embedded-user JWTs, frontend setup of the @prismatic-io/embedded SDK, and the integration marketplace or other embedded screens. Use when a user wants their customers to find, activate, or configure integrations inside the user's own app, or asks about embedded authentication, signing keys, or the embedded SDK.

Software Development

Implement Folder Architecture

9

Drakaniia/skills

Execute a large-scale folder architecture refactor based on an audit report or user-defined architecture. Moves files into correct locations, splits oversized folders, refactors imports, updates barrel files, and verifies builds after each phase. Use after audit-codebase has generated its structural report, or when a systematic folder reorganization is needed.

Software Development

Prismatic Integrations

9

prismatic-io/agent-skills

Build, update, and verify a Prismatic Code Native Integration (CNI), including local checks and iterative platform testing. Use for new integration requirements, ongoing CNI development, and debugging flow executions. For assessing or replacing an existing non-Prismatic integration system, prefer prismatic-migrate when available.

Software Development

Browse the most popular Claude skills, all software development skills, or write your own with the skills generator.