跳到正文
TakoAPI
返回技能列表

jarvis-db-query-doctor-01

由 xammarie 提供

Browser & Automation
407下载量由 clawskills.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 或你在用的任意编程智能体里。

链接