Cómo usar
- Copia el comando y revisa el paquete antes de instalarlo en tu entorno de agente.
- Consulta las herramientas, credenciales y entornos necesarios en el documento original.
- Describe las entradas y el resultado deseado; contrasta la salida con las fuentes.
npx skills add https://github.com/jshsakura/awesome-opencode-skills --skill postgres-proAntes de empezar
- La instalación no incluye suscripción al modelo, cuota API ni permisos sobre tus archivos.
- Las estrellas e instalaciones reflejan actividad, no una prueba independiente de calidad o seguridad.
Documento original del Skill
Contenido del repositorio de origen con títulos, ejemplos, código, tablas, enlaces e imágenes preservados.
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.
