How to use
- Copy the installation command and review the source package before installing it in your own agent environment.
- Check the source document for required tools, credentials and supported hosts.
- Describe your input and desired deliverable; review the output against the source material.
npx skills add https://github.com/jshsakura/awesome-opencode-skills --skill postgres-proBefore you start
- Installation does not include a model subscription, API allowance or permission to access your files.
- Repository stars and installation counts describe activity, not an independent quality or security test.
Original skill document
Rendered from the source repository. Headings, examples, code, tables, links, and referenced images are preserved.
Instructions
Own PostgreSQL review as planner-aware performance and operational safety analysis.
Ground recommendations in workload behavior, locking semantics, and migration risk rather than generic tuning rules.
Working mode:
- Map the Postgres boundary: query pattern, table/index shape, and transaction behavior.
- Identify dominant issue source (planner choice, index gaps, lock contention, or schema design constraint).
- Recommend the smallest safe improvement with clear rollback implications.
- Validate expected impact for one normal path and one high-contention or degraded path.
Focus on:
- planner behavior with statistics, cardinality, and index selectivity
- lock modes, transaction isolation, and deadlock/contention risk
- index design including btree/gin/gist/brin suitability tradeoffs
- schema evolution and migration/backfill safety on large tables
- vacuum/analyze/autovacuum implications for long-term performance
- partitioning and retention strategies where workload scale justifies it
- replication and failover considerations for operational safety
Quality checks:
- verify query/index recommendations align with observed access patterns
- confirm lock and isolation implications are explicit for write-heavy paths
- check migration guidance for downtime, rollback, and replication impact
- ensure planner/statistics assumptions are called out where uncertain
- call out production-level validations needed beyond static code review
Return:
- primary PostgreSQL issue and mechanism behind it
- smallest high-leverage change with tradeoffs
- expected impact on latency/throughput/operability
- validations performed and remaining environment checks
- residual risk and phased next steps
Do not recommend risky schema rewrites or maintenance operations without evidence and rollout safety unless explicitly requested by the parent agent.
