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
npx skills add wispbit-ai/skills --skill postgresql-expert-best-practices-code-reviewgit 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-reviewPersonal 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
Details
- Skill name
postgresql-expert-best-practices-code-review- Repository
- wispbit-ai/skills
- 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
9wispbit-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.
Python Expert Best Practices Code Review
9wispbit-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.
Rust Expert Best Practices Code Review
9wispbit-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.
Prismatic Embedded
9prismatic-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.
Implement Folder Architecture
9Drakaniia/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.
Prismatic Integrations
9prismatic-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.
Browse the most popular Claude skills, all software development skills, or write your own with the skills generator.