AF hap-mongodb-slowlog-analysis
Analyze MongoDB 4.4.x slow logs from pasted slow-log text, uploaded log files, or mongodb.log content and produce practical query optimization advice, index recommendations, evidence-backed reasoning, and ready-to-run Mongo shell index commands. The skill is AI-first and should analyze logs directly in conversation without relying on local PowerShell by default. It should also be able to group repeated entries by namespace, deduplicate repeated query shapes, and summarize repeated patterns before giving advice. Only treat DOCX or PDF export as optional conversion steps that may require local tooling. Prefer Chinese output by default, but support English when requested. For HAP worksheet collections whose names start with ws, treat _id, utime, rowid, and ctime single-field indexes as existing defaults and never recommend recreating those single-field indexes. Treat status as a low-cardinality field with only 1 and 9, where 1 means active/in-use, and do not include status in recommended index definitions.
As a process F 43/100 · Will not run — References files that are not bundled: scripts/extract-slowlog-signals.ps1, scripts/generate-slowlog-report.ps1, scripts/extract-slowlog-signals.ps1
How to improve
- The text references files that are not there: add them or drop the references.
- Your own cases (evals/evals.json, 4–6 real requests with expected answers): the full check would then run those instead of a model-drafted suite.
- A spec.yaml with trigger phrases and assertions — a behaviour contract for CI; `skilltest init` writes a template.
Guard findings · 0
✓ No critical or high findings
Files scanned: 6. Evidence is masked. Grey chips explain why severity was lowered.
Against the Agent Skills spec
- warning
missing-refreference to a missing file: scripts/extract-slowlog-signals.ps1 - warning
missing-refreference to a missing file: scripts/generate-slowlog-report.ps1 - warning
missing-refreference to a missing file: scripts/extract-slowlog-signals.ps1 - warning
missing-refreference to a missing file: scripts/generate-slowlog-report.ps1
Process rating: all ten parameters 43/100
- 0Tools and files. 4 referenced file(s) missing: scripts/extract-slowlog-signals.ps1, scripts/generate-slowlog-report.ps1, scripts/extract-slowlog-signals.ps1
- 0Inputs and preconditions. Does not say what the process needs to start
- 0Failures and branches. Linear process with no failure handling
- 20When it triggers. No condition that starts the skill
- 30Running it twice. 11 mutating operations with no state check
- 60Result and completion. Output format stated, no completion criterion
- 100Steps. 254 steps
- 100Consistency. Name and required fields are in place
- 100Execution cost. Instruction body is 2787 tokens
- 100Progress reporting. Reports progress
- low 18 top-level sections: this looks like several domains in one skill
Everything here is measured from the skill text rather than judged by a model, so the numbers are checkable. A parameter weighs more when it is a more common reason for the process to stall.
Quality signals
- +5Description has no quoted example phrases that should trigger the skill
- +4Description does not say when NOT to use the skill (false activations)
- +3Description length 1018: 120–800 characters recommended
- +1No license
- +2Single-language instructions
- +4Structure: 20 headings
- +3Step-by-step instructions: 254 items
- +3Output format is stated explicitly
- +4Has examples (3 code blocks)
- +4Reference files are cited in the instructions (1 of 1)
Quality base 70; lint remarks subtract, signals add up to 100. Result: 76.