window-function-generator
Install with Tessl CLI
npx tessl i github:jeremylongshore/claude-code-plugins-plus-skills --skill window-function-generatorWindow Function Generator - Auto-activating skill for Data Analytics. Triggers on: window function generator, window function generator Part of the Data Analytics skill category.
Overall
score
19%
Does it follow best practices?
Validation for skill structure
Activation
7%This description is severely underdeveloped - it's essentially just a title with redundant trigger terms and a category label. It provides no information about what window functions the skill can generate, what SQL dialects it supports, or what specific user needs it addresses. The auto-generated boilerplate format adds no value for skill selection.
Suggestions
Add specific capabilities: 'Generates SQL window functions including ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, SUM OVER, and running totals for analytical queries.'
Include a 'Use when...' clause with natural trigger terms: 'Use when the user needs to rank rows, calculate running totals, access previous/next row values, or write PARTITION BY clauses.'
Add common user phrases as triggers: 'running total', 'rank results', 'previous row', 'cumulative sum', 'partition by', 'analytical SQL'
| Dimension | Reasoning | Score |
|---|---|---|
Specificity | The description only names the domain ('Window Function Generator', 'Data Analytics') 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 redundant trigger phrase. There's no explicit 'Use when...' clause explaining when Claude should select this skill. | 1 / 3 |
Trigger Term Quality | The trigger terms are redundant ('window function generator' listed twice) and overly specific. Missing natural variations users would say like 'running total', 'rank rows', 'partition by', 'LAG', 'LEAD', 'ROW_NUMBER', or 'SQL analytics'. | 1 / 3 |
Distinctiveness Conflict Risk | The term 'window function' is fairly specific to SQL analytics, which provides some distinctiveness. However, 'Data Analytics' is broad and could overlap with other analytics skills. The lack of specific use cases increases conflict risk. | 2 / 3 |
Total | 5 / 12 Passed |
Implementation
0%This skill content is an empty template with no actual instructional value. It contains only meta-descriptions of what a skill should do without any concrete guidance on window functions, SQL syntax, examples, or workflows. The content fails every dimension by providing zero actionable information.
Suggestions
Add concrete SQL window function examples (ROW_NUMBER, RANK, LAG, LEAD, SUM OVER, etc.) with executable code snippets
Include a clear workflow for constructing window functions: identify partition columns, define ordering, select appropriate function, validate results
Provide specific syntax patterns and common use cases (running totals, rankings, moving averages) instead of generic capability claims
Remove all boilerplate meta-descriptions and replace with actual technical content that teaches window function construction
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | The content is entirely boilerplate with no actual technical substance. It repeats 'window function generator' multiple times without providing any real information, and the generic descriptions add no value Claude doesn't already know. | 1 / 3 |
Actionability | There is zero concrete guidance - no SQL examples, no window function syntax, no executable code. The content only describes what the skill claims to do rather than actually instructing how to do it. | 1 / 3 |
Workflow Clarity | No workflow is defined. Claims to provide 'step-by-step guidance' but includes no actual steps, sequences, or validation checkpoints for generating window functions. | 1 / 3 |
Progressive Disclosure | The content is a flat, repetitive structure with no meaningful organization. There are no references to detailed materials, examples, or related documentation - just placeholder text. | 1 / 3 |
Total | 4 / 12 Passed |
Validation
69%Validation — 11 / 16 Passed
Validation for skill structure
| Criteria | Description | Result |
|---|---|---|
description_trigger_hint | Description may be missing an explicit 'when to use' trigger hint (e.g., 'Use when...') | Warning |
allowed_tools_field | 'allowed-tools' contains unusual tool name(s) | Warning |
metadata_version | 'metadata' field is not a dictionary | Warning |
frontmatter_unknown_keys | Unknown frontmatter key(s) found; consider removing or moving to metadata | Warning |
body_steps | No step-by-step structure detected (no ordered list); consider adding a simple workflow | Warning |
Total | 11 / 16 Passed | |
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.