CtrlK
BlogDocsLog inGet started
Tessl Logo

id-graph-canonical-id-size

Query ID graph to analyze canonical ID group sizes. Use when debugging over-stitching by checking how many individual IDs are mapped to each canonical ID, or when canonical ID groups seem too large.

67

Quality

80%

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

78%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 tight, single-purpose skill that delivers an executable SQL query with just enough schema and database context to run it. The main gaps are an undocumented time column referenced by the partition filter and no guidance on interpreting the resulting unique_id_count values to actually conclude over-stitching.

Suggestions

Document the time column used by td_interval(time, '-7d') in the Schema section so the filter is fully executable from the documented columns.

Add a short interpretation note (e.g., what unique_id_count magnitude suggests over-stitching or a typical healthy range) so the query output leads to a diagnosis.

Trim conversational filler such as "This is where you can plug in the parent segment the user gives in the request" and the redundant LIMIT troubleshooting bullet, since the core query already includes LIMIT 100.

DimensionReasoningScore

Conciseness

The body is generally lean and domain-focused, but contains minor padding such as "This is where you can plug in the parent segment the user gives in the request" and a troubleshooting bullet about LIMIT clauses that the core query already satisfies with LIMIT 100. This matches anchor 4 (efficient with minor trimmable instances) rather than anchor 5, where every token earns its place.

4 / 5

Actionability

The core SQL query is concrete and near copy-paste ready, with the database-name format (cdp_audience_273509) explaining the <parent_segment_id> placeholder. It falls short of anchor 5 because td_interval(time, '-7d') relies on a time column that is not in the documented schema, leaving a minor gap for execution.

4 / 5

Workflow Clarity

As a single-purpose read-only diagnostic under 50 lines, the action (substitute the parent segment ID, run the query) is unambiguous, matching the simple-skill exception. It stays at 4 rather than 5 because there is no guidance for interpreting results, such as what unique_id_count magnitude signals over-stitching.

4 / 5

Progressive Disclosure

The skill is under 50 lines with no need for external references, and its well-organized sections (Requirements, Database, Schema, Core Query, Troubleshooting) make navigation trivial. Per the rubric's simple-skill guideline, this earns the top score on section organization alone.

5 / 5

Total

17

/

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 strong description that clearly states a concrete capability and pairs it with explicit, natural 'Use when...' triggers tied to the over-stitching debugging scenario. The only weakness is that it describes a single core action rather than enumerating several specific capabilities, and it lacks synonym coverage for related terminology.

DimensionReasoningScore

Specificity

"Query ID graph to analyze canonical ID group sizes" names the domain plus 1-2 concrete actions but does not list several specific actions, matching the anchor for a non-comprehensive capability list. A score of 4 would require multiple distinct specific actions with only minor coverage gaps.

3 / 5

Completeness

It explicitly answers what ("Query ID graph to analyze canonical ID group sizes") and when ("Use when debugging over-stitching... or when canonical ID groups seem too large") with concrete trigger phrases. This matches the top anchor; anchor 4 would require the 'when' clause to be less explicit or specific.

5 / 5

Trigger Term Quality

Natural domain phrases like "debugging over-stitching", "canonical ID groups seem too large", and "how many individual IDs are mapped to each canonical ID" mirror what an affected user would say, though common synonyms such as "ID stitching" or "identity resolution" are absent. This sits above anchor 3 (relevant keywords but missing variations) but below anchor 5 (comprehensive synonyms).

4 / 5

Distinctiveness Conflict Risk

Highly niche terms ("ID graph", "canonical ID", "over-stitching") create a clear trigger territory with minimal overlap risk against other skills. It clearly matches the 'clear niche with distinct triggers' anchor rather than the minor-overlap anchor at 4.

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
treasure-data/td-skills
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.