jshsakura/awesome-opencode-skills

sql-pro

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

Ver código-fonte

Como usar

  1. Copie o comando e verifique o pacote antes de instalar no seu ambiente de agente.
  2. Consulte no original as ferramentas, credenciais e ambientes necessários.
  3. 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 sql-pro

Antes 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 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.

Relacionados por tarefa

do mesmo repositório

Mais Skills

Todos os Skills