CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

fix-slow-queries

Diagnose and fix slow Paperclip PostgreSQL queries using Cloud and Neon evidence, local reproduction, performance and result comparisons, regression tests, and a PR with passing checks. Use for costly queries, repeated database work, or slow requests with a suspected database cause.

Quality

88%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

81%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A strong, mature instruction-only skill: it sequences a complex database-performance workflow with pervasive validation checkpoints, feedback loops, and checklist tables, and defers discovery and benchmark mechanics to well-signaled reference files. Minor weaknesses are the duplicated migration guidance, commands deferred to references, and a body heavier than a strict overview structure would call for.

DimensionReasoningScore

Conciseness

The ~190-line body is dense, imperative, and assumes Claude's competence with no concept explanations, but migration timing/budget rules are duplicated between section 5 ("First optimize a migration exceeding the roughly one-to-two-minute budget; flag it for human review") and the Constraints section, so minor trimming is possible.

4 / 5

Actionability

Concrete guidance throughout — "rg on distinctive SQL fragments", "EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON)", exact evidence to capture, and a full PR-content checklist — though most copy-paste commands (e.g. the pnpm benchmark invocation) live in the reference files rather than the body, leaving minor gaps.

4 / 5

Workflow Clarity

Eight numbered sections form a coherent sequence with explicit validation at every step ("Prove the baseline exhibits the suspected cost before editing", "Reject or revise the change if either proof fails", "Do not call an interrupted suite a pass", "Do not finish with 'CI pending.'"), feedback loops for error recovery, and checklists via the claims and regression-evidence tables.

5 / 5

Progressive Disclosure

Both references exist, are one level deep, and are clearly signaled at point of need ("Read [Cloud discovery](references/cloud-discovery.md) when starting from a hosted workspace"), but the main file is a full procedure manual with inlined detail (PR-checks loop micro-rules, the partially duplicative Constraints section) rather than a lean overview.

4 / 5

Total

17

/

20

Passed

Description

92%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A well-crafted description that clearly states what the skill does and when to use it, with concrete workflow actions and scoped, niche-specific triggers. The only gap is a handful of natural synonyms (e.g. "optimize", "database performance") that would make triggering even more reliable.

DimensionReasoningScore

Specificity

"Diagnose and fix slow Paperclip PostgreSQL queries using Cloud and Neon evidence, local reproduction, performance and result comparisons, regression tests, and a PR with passing checks" lists 7+ concrete actions covering the workflow end to end — comprehensive coverage matching the top anchor.

5 / 5

Completeness

It explicitly answers both what ("Diagnose and fix slow Paperclip PostgreSQL queries using…") and when ("Use for costly queries, repeated database work, or slow requests with a suspected database cause") with concrete trigger phrases in third-person voice.

5 / 5

Trigger Term Quality

Natural phrases like "costly queries", "slow requests", "repeated database work", and "suspected database cause" give good coverage, but common user phrasings such as "optimize", "query timeout", or "database performance" are missing.

4 / 5

Distinctiveness Conflict Risk

The description is scoped to Paperclip PostgreSQL queries with distinct triggers (costly queries, slow requests with a suspected database cause), forming a clear niche with minimal conflict risk against generic skills.

5 / 5

Total

19

/

20

Passed

Validation

93%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

relative_links

Relative link issues: 3 suspicious

Warning

Total

15

/

16

Passed

Repository

paperclipai/paperclip

Path

.agents/skills/fix-slow-queries/SKILL.md

Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.