paishu-ai/pai-zong-nb-v5.8/27-postgresql-pro

Claude Code and agent skill by paishu-ai/pai-zong-nb-v5.8

Trust tier 3
  • community
Source check pending

Checking that the SKILL.md file is still in the repository.

PostgreSQL-specific professional development and optimization. Use for Postgres schema design, migrations, indexes, EXPLAIN, JSONB, full-text search, constraints, transactions, locks, isolation, RLS, partitioning, generated columns, extensions, and query tuning.

Install

npx vskill@latest install paishu-ai/pai-zong-nb-v5.8/27-postgresql-pro

SKILL.md

The same SKILL.md was published earlier as paishu-ai/pai-zong-nb-v5.8/27-postgresql-pro.

PostgreSQL Pro

Workflow

  1. Inspect schema, migrations, Postgres version, ORM behavior, and target query.
  2. Use constraints and types to encode invariants: uuid, bigint, numeric, timestamptz, enums/domains only when appropriate.
  3. Use EXPLAIN (ANALYZE, BUFFERS) when safe and available for performance work.
  4. Choose indexes based on query shape: B-tree, partial, composite, expression, GIN, GiST, BRIN.
  5. Review locks, transaction isolation, long-running migrations, and concurrent index builds.
  6. Consider RLS, tenant isolation, and audit requirements for sensitive data.

Index Guidance

  • Put equality filters before range/sort columns in composite indexes when appropriate.
  • Use partial indexes for common filtered subsets.
  • Use GIN for JSONB containment or full-text search when query patterns justify it.
  • Use CREATE INDEX CONCURRENTLY for large production tables when available and safe.
  • Avoid duplicate and low-selectivity indexes without evidence.

Migration Guidance

  • Avoid table rewrites and long exclusive locks on large tables.
  • Add nullable columns, backfill in batches, then enforce not-null where needed.
  • Add constraints as NOT VALID then VALIDATE CONSTRAINT for large existing data when appropriate.
  • Be careful with enum changes and irreversible DDL.

Query Guidance

  • Watch for N+1 queries, sequential scans on large tables, bad estimates, and sort spill.
  • Prefer keyset pagination for large changing datasets.
  • Use timestamptz for absolute times.
  • Keep JSONB for flexible attributes, not as a replacement for relational modeling.

Output

State Postgres-specific choice, query plan concern, migration lock risk, and exact verification command when available.

Security

  • Security scanPassed, 95 of 100Pattern checks on the skill's files.
  • Model reviewPassed

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

Source

Popularity

Repository stars
1
Repository forks
1
7-day trend score
8

Stars and forks are for the whole GitHub repository, not this skill alone. Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/paishu-ai/pai-zong-nb-v5.8/27-postgresql-pro/badge)](https://verified-skill.com/skills/paishu-ai/pai-zong-nb-v5.8/27-postgresql-pro)

Something wrong with this skill or its page? Tell us.