Agent skill
tidb-profiler-analyzer
Processes and analyzes TiDB profiler zip packages (CPU or heap) for components like TiDB, TiKV, PD, or TiFlash. It unzips, aggregates the profiler data, and uses `go tool pprof` to report on the most time-consuming functions (CPU) or highest memory allocations (heap).
Install this agent skill to your Project
npx add-skill https://github.com/hawkingrei/tidb-dev-prompt/tree/main/tidb-profiler-analyzer
SKILL.md
TiDB Profiler Analyzer Skill
Your primary goal is to organize and analyze profiler data from various TiDB component (tidb, pd, tikv, tiflash) .zip archives.
Follow these steps meticulously:
- Unzip all the zip files: Locate and extract the contents of all
.zipfiles present in the current working directory. Each zip file should be unzipped into a separate, appropriately named directory. - Create 'profiler_data' directory: Create a new directory named
'profiler_data'at the root of the current working directory. This directory will house all collected profiler files. - Move profiler files: Recursively search through all the directories created in step 1. Identify and move all files found within these unzipped directories to the newly created
'profiler_data'directory. - Analyze Profiler Data:
a. Identify the type of profiler data in the
'profiler_data'directory (CPU or Heap). You can often infer this from filenames (e.g., containing "cpu" vs "heap"). If unsure, you may need to ask the user. b. Use thego tool pprofto analyze the collected data. * For CPU profiles: Rungo tool pprof -top <path_to_profiler_file>to find the most time-consuming functions. * For Heap profiles: Rungo tool pprof -top --alloc_space <path_to_profiler_file>to find the functions with the most memory allocations. c. Present a summary of the analysis results to the user. - Confirmation and Cleanup: After the analysis is complete, you must prompt the user for confirmation before proceeding with cleanup. If the user approves, delete the original
.zipfiles and the now empty unzipped directories to tidy up the workspace.
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
tidb-optimizer-bugfix
Fix TiDB optimizer bugs with minimal diffs, hypothesis-driven validation, and regression tests aligned with tidb-test-guidelines. Use when reproducing, fixing, and validating planner/optimizer behavior bugs.
plan-replayer-testing
Expertise in adding new test cases for the TiDB plan replayer. Use when the user provides a plan replayer zip file and wants to create a new test.
pr-review-helper
Gather PR review context: all comments (including review suggestions), diff context, and CI status; download GitHub Actions logs on failures. Prefer GitHub MCP for reads, fall back to gh CLI when needed.
tidb-doc-finder
TiDB-specific documentation lookup guided by this repo's llms.txt hub: read llms.txt, pick the best linked source (tidb-dev-guide llms-full.txt, TiDB user guide llms.txt, or Uber Go style guide), fetch it, then search within it to answer with precise references. Use when asked to find docs, research, or provide doc-grounded answers about TiDB development or usage.
context-management
Use for projects, tasks, or code that involve context engineering and context management for AI agents: keep prompt prefixes stable for KV-cache, use append-only context, prefer tool masking over tool removal, offload large observations into filesystem memory, recite goals/todos to control attention, preserve errors for recovery, and avoid few-shot pattern lock-in. Use when building or debugging agent loops, prompt/context schemas, memory strategies, or tool-availability policies.
edit-article
Edit and improve articles by restructuring sections, improving clarity, and tightening prose. Use when user wants to edit, revise, or improve an article draft.
Didn't find tool you were looking for?