CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

update-sqlx

How to safely update SQLx offline query cache. MUST use when SQL queries change.

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

88%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 highly actionable, well-validated workflow for a genuinely dangerous operation, with copy-paste commands, explicit checkpoints, and hard-won failure diagnostics. The main weaknesses are repetition of the cache-deletion warning across three sections and structural overlap/ordering between the two procedures.

Suggestions

Consolidate the repeated warning that 'prepare' deletes .sqlx/ before regenerating (currently in 'Before You Run Anything', 'The Problem', and 'What NOT to Do') into a single stated-once callout.

Reorder sections so 'The Problem' precedes the procedures, and explicitly relate the backup/graft flow to the origin/main-checkout flow so the reader knows when to use which.

The procedure depends on .agents/skills/update-sqlx/sqlx-cache.sh, which is not part of this skill bundle — ship the script in scripts/ (or document a manual fallback) so the guidance is self-contained.

DimensionReasoningScore

Conciseness

The body is lean and operational with no explanation of concepts Claude already knows, but the destructive nature of 'prepare' is stated three times ('deletes .sqlx/ before regenerating', 'deletes all existing cache files', 'it will delete EE caches') and 'The Problem' section re-covers ground, so minor trimming is possible.

4 / 5

Actionability

Fully executable copy-paste commands throughout: the sqlx-cache.sh backup/newq/restore invocations, the complete cargo sqlx prepare command with expected-failure note, the git ls-tree/comm restore pipeline, and both SQLX_OFFLINE verification checks, with appropriately parameterized placeholders (<this worktree's db>, <your-crate>).

5 / 5

Workflow Clarity

The destructive workflow is clearly sequenced (backup, confirm DATABASE_URL, prepare, read newq output, restore, verify lib and test targets) with explicit validation checkpoints and error-recovery feedback loops, so the destructive-operation cap at 3 does not apply.

5 / 5

Progressive Disclosure

Clear section headers and one-level-deep, clearly signaled references (sqlx-cache.sh, AGENTS.md, CLAUDE.md), but roughly 150 lines are entirely inline with two overlapping procedures (backup/graft vs. origin/main checkout) and a 'The Problem' section placed after the solutions, leaving organization gaps beyond minor.

4 / 5

Total

18

/

20

Passed

Description

82%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 concise, well-targeted description that answers both what and when with an explicit MUST-use trigger and a clearly distinct niche. It could name more concrete actions and a few more trigger variations (e.g., 'cargo sqlx prepare', '.sqlx') to strengthen specificity and keyword coverage.

DimensionReasoningScore

Specificity

The description names the domain ('SQLx offline query cache') and one concrete action ('safely update'), matching the 1-2 concrete actions anchor; it does not list several actions, so it is not a 4.

3 / 5

Completeness

'How to safely update SQLx offline query cache' explicitly answers what it does, and 'MUST use when SQL queries change' is an explicit concrete when-clause, satisfying the anchor for both clearly present.

5 / 5

Trigger Term Quality

'SQLx', 'SQL queries', and 'query cache' are natural terms a user in a Rust/SQLx repo would say, but common variations like 'cargo sqlx prepare' or '.sqlx' are missing, matching good-but-incomplete keyword coverage.

4 / 5

Distinctiveness Conflict Risk

SQLx offline query cache maintenance is a narrow niche with distinct triggers ('SQLx', 'query cache', 'SQL queries'), so it is clearly distinguishable from other skills with minimal conflict risk.

5 / 5

Total

17

/

20

Passed

Validation

100%

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

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository

windmill-labs/windmill

Path

.agents/skills/update-sqlx/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.