본문으로 건너뛰기
TakoAPI
스킬로 돌아가기

jarvis-db-query-doctor-01

xammarie 제작

Browser & Automation
407clawskills.sh가 보고한 다운로드 수
1조회수
좋아요 0개로그인하면 이 스킬에 좋아요를 누를 수 있습니다
—아직 평가 없음
내 평가

요약

Diagnose slow SQL and rewrite queries for safer performance.

설명

이 스킬이 하는 일

Diagnoses slow SQL queries and rewrites them for safer performance. Applies a structured playbook with checkpoints and quality gates to development tasks that need repeatable steps and practical outputs. Returns ranked findings, action plans with risk mitigations, and exact commands or checklists.

The built-in quality gates and fallback requirements prevent shipping unverified fixes, reducing the risk of regressions from ad-hoc query changes.

사용 시점

  • Diagnosing an 8-second dashboard query before a production deploy
  • Rewriting a report query that times out under load
  • Creating a phased refactor plan for a slow legacy schema
  • Getting a risk-ranked fix list for a database performance incident
  • Turning vague slowness complaints into a prioritized action sequence

예시 워크플로

입력

User asks: My dashboard query takes 8 seconds on a 2M-row table. Here are the query and the EXPLAIN output.

에이전트
  1. 1

    Define success criteria: query must run under 500ms on production data

  2. 2

    Identify the smallest fix path, starting with missing indexes before considering rewrites

  3. 3

    Execute each candidate fix in a staging checkpoint and record EXPLAIN ANALYZE output

  4. 4

    Apply quality gate: confirm no full-table scans remain and a rollback script is ready

  5. 5

    Return ranked findings, today/this-week action plan, and exact index or rewrite commands

출력

Situation summary, top bottlenecks ranked by impact, specific ALTER/CREATE INDEX commands, risk mitigations, and a fallback rollback plan

설치

clawhub install xammarie/jarvis-db-query-doctor-01

CLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.

링크