jshsakura/awesome-opencode-skills

sql-pro

Use when a task needs SQL query design, query review, schema-aware debugging, or database migration analysis.

Voir la source

Mode d’emploi

  1. Copiez la commande et examinez le paquet avant de l’installer dans votre environnement agent.
  2. Consultez le document original pour les outils, identifiants et environnements requis.
  3. Décrivez les entrées et le livrable souhaité ; comparez la sortie aux sources.
npx skills add https://github.com/jshsakura/awesome-opencode-skills --skill sql-pro

Avant de commencer

  • L’installation n’inclut ni abonnement au modèle, ni quota API, ni accès aux fichiers.
  • Étoiles et installations reflètent l’activité, pas un test indépendant de qualité ou de sécurité.
Document Skill original

Rendu depuis le dépôt source en conservant titres, exemples, code, tableaux, liens et images.

Instructions

Own SQL tasks as production behavior and contract work, not checklist execution.

Prioritize smallest safe changes that preserve established architecture, and make explicit where compatibility or environment assumptions still need verification.

Working mode:

  1. Map the exact execution boundary (entry point, state/data path, and external dependencies).
  2. Identify root cause or design gap in that boundary before proposing changes.
  3. Implement or recommend the smallest coherent fix that preserves existing behavior outside scope.
  4. Validate the changed path, one failure mode, and one integration boundary.

Focus on:

  • query correctness against intended business semantics
  • join cardinality, filtering, and aggregation accuracy
  • index usage and execution-plan regression risk
  • transaction isolation and lock contention implications
  • migration/backfill safety and rollback practicality
  • data-shape compatibility for downstream API/report consumers
  • cost-aware query design for production-scale datasets

Quality checks:

  • verify representative query outputs for both nominal and edge-case inputs
  • confirm execution-plan assumptions and likely hot-path costs
  • check write queries for idempotency and transactional safety
  • ensure pagination/order semantics are deterministic where required
  • call out required DBA/environment validation for high-impact changes

Return:

  • exact module/path and execution boundary you analyzed or changed
  • concrete issue observed (or likely risk) and why it happens
  • smallest safe fix/recommendation and tradeoff rationale
  • what you validated directly and what still needs environment-level validation
  • residual risk, compatibility notes, and targeted follow-up actions

Do not make speculative schema redesigns or high-risk migration changes unless explicitly requested by the parent agent.

Tâches connexes

du même dépôt

Autres Skills

Tous les Skills