CtrlK
BlogDocsLog inGet started
Tessl Logo

sql-patterns

Quick reference for common SQL patterns, CTEs, window functions, and indexing strategies. Triggers on: sql patterns, cte example, window functions, sql join, index strategy, pagination sql.

84

1.00x
Quality

75%

Does it follow best practices?

Impact

100%

1.00x

Average score across 3 eval scenarios

SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./data/skills-md/0xdarkmatter/claude-mods/sql-patterns/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

72%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.

The body is a tight, executable SQL cheat-sheet with excellent actionability and conciseness, but it has no multi-step workflow and its two "Additional Resources" links point to files that are not bundled, breaking the progressive-disclosure navigation it advertises.

Suggestions

Either create the referenced ./references/window-functions.md and ./references/indexing-strategies.md files, or remove the "Additional Resources" section to avoid dead links.

If the skill is ever extended to cover destructive or batch SQL (UPDATE/DELETE migrations), add an explicit validate-then-execute workflow with checkpoints so workflow_clarity can rise above 3.

DimensionReasoningScore

Conciseness

The body is lean: tight tables for window functions, joins, index types, and anti-patterns with minimal prose and copy-paste SQL, assuming Claude already knows SQL; the only trimming target is the redundant opening line "Quick reference for common SQL patterns." which restates the description, keeping it just below the anchor-5 "every token earns its place" bar.

4 / 5

Actionability

Multiple complete, executable SQL blocks (single CTE, chained CTE, a window-function query using LAG/SUM OVER, and both OFFSET and keyset pagination) are copy-paste ready and cover the common cases, matching the anchor-5 "fully executable; specific examples cover the common cases" example.

5 / 5

Workflow Clarity

This is a reference card with no multi-step process, so there is no sequenced workflow or validation checkpoint to evaluate; it is well organized into sections but, being a multi-topic lookup rather than a single-task skill, it does not meet the simple-skill exception for a 5 and lands at the anchor-3 middle where sequence/checkpoints are absent (appropriately, since the patterns are read-only and non-destructive).

3 / 5

Progressive Disclosure

The body is well sectioned and signals one-level-deep references in "Additional Resources" ("./references/window-functions.md", "./references/indexing-strategies.md"), but those referenced files do not exist in the bundle (no references/ directory), so the signaled navigation is dead — a real navigation failure that pulls it below anchor 4 despite good in-file structure.

3 / 5

Total

15

/

20

Passed

Description

78%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.

The description cleanly answers both what the skill does and when to use it via an explicit Triggers-on clause with natural keywords, placing it well above average. Its main weakness is specificity: it lists topics rather than concrete actions, and trigger coverage lacks synonyms/extensions.

Suggestions

Replace the generic "Quick reference for" framing with concrete verbs, e.g. "Write and optimize common SQL patterns: CTEs, window functions, joins, pagination, and indexes."

Broaden trigger terms with natural synonyms and extensions users say, such as "recursive CTE", "query optimization", ".sql", or "slow query".

DimensionReasoningScore

Specificity

Quotes "Quick reference for common SQL patterns, CTEs, window functions, and indexing strategies" name the SQL domain plus several concrete topics, but the only action is the generic verb "reference for", lacking multiple distinct concrete actions like the anchor-4 "extracts/fills/converts" example; it sits above anchor 2 (which would name only the domain) yet below anchor 4 (which requires several specific actions).

3 / 5

Completeness

It states a clear "what" ("Quick reference for common SQL patterns, CTEs, window functions, and indexing strategies") and an explicit "when" via the "Triggers on:" clause with concrete trigger phrases, directly matching the anchor-5 pattern of answering both what and when with concrete triggers; the "Use when" cap at 3 does not apply because explicit trigger guidance is present.

5 / 5

Trigger Term Quality

The explicit "Triggers on: sql patterns, cte example, window functions, sql join, index strategy, pagination sql" gives good natural keyword coverage a user would actually say, but it stops short of anchor-5 comprehensive coverage because it omits synonyms and file extensions (e.g. no .sql, no "recursive CTE", no "query optimization").

4 / 5

Distinctiveness Conflict Risk

The SQL-patterns niche with distinct triggers (CTEs, window functions, joins, indexing, pagination) is clearly distinguishable from non-SQL skills, but terms like "sql join" and "window functions" could overlap with a broader general database/SQL skill, so it is "mostly distinct; minor overlap risk" rather than the minimal-conflict anchor 5.

4 / 5

Total

16

/

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.

Validation16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository
NeverSight/skills_feed
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.