Como usar
- Copie o comando e verifique o pacote antes de instalar no seu ambiente de agente.
- Consulte no original as ferramentas, credenciais e ambientes necessários.
- Descreva os dados de entrada e a entrega esperada; confira a saída com as fontes.
npx skills add https://github.com/jshsakura/awesome-opencode-skills --skill postgres-proAntes de começar
- A instalação não inclui assinatura de modelo, franquia API ou acesso aos seus arquivos.
- Estrelas e instalações indicam atividade, não um teste independente de qualidade ou segurança.
Documento original do Skill
Renderizado do repositório de origem, preservando títulos, exemplos, código, tabelas, links e imagens.
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.
