paishu-ai/pai-zong-nb-v5.8/27-postgresql-pro
Claude Code and agent skill by paishu-ai/pai-zong-nb-v5.8
- community
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-proSKILL.md
The same SKILL.md was published earlier as paishu-ai/pai-zong-nb-v5.8/27-postgresql-pro.
PostgreSQL Pro
Workflow
- Inspect schema, migrations, Postgres version, ORM behavior, and target query.
- Use constraints and types to encode invariants:
uuid,bigint,numeric,timestamptz, enums/domains only when appropriate. - Use
EXPLAIN (ANALYZE, BUFFERS)when safe and available for performance work. - Choose indexes based on query shape: B-tree, partial, composite, expression, GIN, GiST, BRIN.
- Review locks, transaction isolation, long-running migrations, and concurrent index builds.
- 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 CONCURRENTLYfor 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 VALIDthenVALIDATE CONSTRAINTfor 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
timestamptzfor 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
- SKILL.md in the repositoryCheckingskills/27-postgresql-pro/SKILL.md
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
[](https://verified-skill.com/skills/paishu-ai/pai-zong-nb-v5.8/27-postgresql-pro)