Come usare
- Copia il comando e controlla il pacchetto prima di installarlo nel tuo ambiente agente.
- Controlla strumenti, credenziali e ambienti richiesti nel documento originale.
- Descrivi input e risultato desiderato; confronta l’output con le fonti.
npx skills add https://github.com/jshsakura/awesome-opencode-skills --skill postgres-proPrima di iniziare
- L’installazione non include abbonamenti, quote API o accesso ai file.
- Stelle e installazioni indicano attività, non un test indipendente di qualità o sicurezza.
Documento Skill originale
Contenuto dal repository con titoli, esempi, codice, tabelle, link e immagini preservati.
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.
