window-function-generator
Window Function Generator - Auto-activating skill for Data Analytics. Triggers on: window function generator, window function generator Part of the Data Analytics skill category.
36
Quality
3%
Does it follow best practices?
Impact
97%
1.00xAverage score across 3 eval scenarios
Passed
No known issues
Optimize this skill with Tessl
npx tessl skill review --optimize ./planned-skills/generated/12-data-analytics/window-function-generator/SKILL.mdQuality
Discovery
7%Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.
This description is essentially a placeholder with minimal useful content. It names the skill category but provides no concrete actions, no explanation of capabilities, and redundant trigger terms. The description would fail to help Claude distinguish when to use this skill versus other data analytics skills.
Suggestions
Add specific concrete actions the skill performs, e.g., 'Generates SQL window functions including ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, and aggregate functions with OVER clauses'
Add a 'Use when...' clause with natural trigger terms like 'ranking rows', 'running totals', 'partition data', 'OVER clause', 'cumulative sum', 'row numbering'
Remove the redundant duplicate trigger term and expand with variations users would naturally say when needing window function help
| Dimension | Reasoning | Score |
|---|---|---|
Specificity | The description only names the domain ('Window Function Generator') but provides no concrete actions. It doesn't explain what the skill actually does - no mention of generating SQL, specific window functions like ROW_NUMBER, RANK, LAG, etc. | 1 / 3 |
Completeness | The description fails to answer 'what does this do' beyond the name, and the 'when' guidance is just a duplicate trigger phrase. No explicit 'Use when...' clause or meaningful trigger guidance is provided. | 1 / 3 |
Trigger Term Quality | The trigger terms are redundant ('window function generator' repeated twice) and overly specific. Missing natural variations users would say like 'SQL window function', 'OVER clause', 'partition by', 'running total', 'rank rows', etc. | 1 / 3 |
Distinctiveness Conflict Risk | The term 'window function' is fairly specific to SQL/data analytics, which provides some distinctiveness. However, the generic 'Data Analytics' category mention could cause overlap with other analytics skills. | 2 / 3 |
Total | 5 / 12 Passed |
Implementation
0%Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.
This skill content is entirely placeholder/boilerplate text with no actual technical value. It describes what a window function generator skill would do without providing any SQL syntax, examples, patterns, or concrete guidance. The content fails to teach Claude anything about window functions (ROW_NUMBER, RANK, LAG, LEAD, SUM OVER, etc.) that it doesn't already know.
Suggestions
Add concrete SQL window function examples with executable code (e.g., ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC))
Include a quick reference table of common window functions (ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, SUM/AVG OVER) with syntax patterns
Provide 2-3 real-world use case examples showing input data and expected output (running totals, ranking within groups, comparing to previous rows)
Remove all meta-description text ('This skill provides...', 'When to Use...') and replace with actual technical content
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | The content is entirely boilerplate with no actual technical substance. It explains what the skill does in abstract terms without providing any concrete SQL window function syntax, examples, or patterns that Claude doesn't already know. | 1 / 3 |
Actionability | No executable code, SQL examples, or concrete commands are provided. The content only describes capabilities in vague terms ('provides step-by-step guidance', 'generates production-ready code') without actually demonstrating any window function syntax or usage patterns. | 1 / 3 |
Workflow Clarity | No workflow or steps are defined. The skill claims to provide 'step-by-step guidance' but contains zero actual steps for generating or using window functions. There are no validation checkpoints or process sequences. | 1 / 3 |
Progressive Disclosure | The content is a monolithic block of meta-description with no references to detailed materials, examples, or related documentation. There's no structure that would help Claude navigate to actual window function implementation details. | 1 / 3 |
Total | 4 / 12 Passed |
Validation
81%Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.
Validation — 9 / 11 Passed
Validation for skill structure
| Criteria | Description | Result |
|---|---|---|
allowed_tools_field | 'allowed-tools' contains unusual tool name(s) | Warning |
frontmatter_unknown_keys | Unknown frontmatter key(s) found; consider removing or moving to metadata | Warning |
Total | 9 / 11 Passed | |
- Commit
0c08951
- 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.