CtrlK
BlogDocsLog inGet started
Tessl Logo

alonso-skills/sql-bi-reporting

Use when writing T-SQL for business intelligence, analytics, or reporting. Includes building summary reports with GROUPING SETS, ROLLUP, and CUBE, writing time-series queries with date bucketing, creating pivot/unpivot transformations, generating tally/numbers tables for gap-filling, building running totals and moving averages with window functions, writing year-over-year comparisons, designing materialized views for dashboards, or producing CSV/JSON exports from SQL Server.

80

Quality

100%

Does it follow best practices?

Impact

No eval scenarios have been run

SecuritybySnyk

Passed

No known issues

Overview
Quality
Evals
Security
Files

Quality

Content

100%

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

This is an exceptionally well-crafted skill file that covers a broad domain (SQL BI & Reporting) with remarkable density and clarity. Every section delivers executable code, concrete patterns, and explicit anti-patterns without wasting tokens on concepts Claude already knows. The progressive disclosure structure — concise overview with working examples in the main file, detailed references linked one level deep — is textbook quality, and the validation checklist plus common mistakes table provide strong guardrails.

DimensionReasoningScore

Conciseness

Every section is dense with actionable information. No unnecessary explanations of what SQL is or how databases work. Tables are used effectively to compress information. The 'Common Mistakes' table is particularly efficient — each row delivers a concrete anti-pattern and fix without padding.

3 / 3

Actionability

Nearly every pattern includes executable T-SQL code — running totals, moving averages, tally tables, gap filling, pivot/unpivot, JSON export all have copy-paste ready examples. The comparison tables (e.g., 2022+ vs pre-2022 date bucketing) give concrete alternatives. SARGable vs non-SARGable examples show both good and bad patterns with clear labels.

3 / 3

Workflow Clarity

The validation checklist provides explicit verification steps for each major pattern area (subtotal rows, window frames, date filters, gap fills, dynamic pivot, export shape). The tally table section includes a bolded safety constraint ('Every tally CTE must include WHERE N <= <limit>'). The 'Common Mistakes' table serves as an additional error-recovery reference. For a reference/pattern skill rather than a sequential process skill, this is well-structured.

3 / 3

Progressive Disclosure

The SKILL.md provides a comprehensive but concise overview of each pattern with working examples, then clearly signals deeper references via 'Full reference:' links at the end of each section. The reference files table at the bottom provides a complete navigation index. References are one level deep and clearly signaled. Note: bundle files were not provided to verify the referenced paths exist, but the structure itself is exemplary.

3 / 3

Total

12

/

12

Passed

Description

100%

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 is an excellent skill description that clearly communicates both when to use it and what it does. It leads with an explicit 'Use when' trigger clause, lists numerous specific and concrete capabilities using natural terminology that BI/analytics users would employ, and is clearly scoped to T-SQL and SQL Server, minimizing conflict risk with other skills.

DimensionReasoningScore

Specificity

Lists numerous specific concrete actions: building summary reports with GROUPING SETS/ROLLUP/CUBE, time-series queries with date bucketing, pivot/unpivot transformations, tally/numbers tables, running totals and moving averages with window functions, year-over-year comparisons, materialized views, and CSV/JSON exports.

3 / 3

Completeness

Opens with an explicit 'Use when...' clause that clearly states when to select this skill (writing T-SQL for BI/analytics/reporting), and the rest of the description thoroughly covers what it does with specific capabilities.

3 / 3

Trigger Term Quality

Excellent coverage of natural terms users would say: T-SQL, business intelligence, analytics, reporting, summary reports, GROUPING SETS, ROLLUP, CUBE, time-series, pivot, unpivot, running totals, moving averages, window functions, year-over-year, materialized views, dashboards, CSV, JSON, SQL Server. These are terms a user working in BI/analytics would naturally use.

3 / 3

Distinctiveness Conflict Risk

Clearly scoped to T-SQL and SQL Server for business intelligence and analytics use cases. The combination of T-SQL, BI-specific constructs (GROUPING SETS, ROLLUP, CUBE), and SQL Server makes it highly distinct from general SQL skills or other database skills.

3 / 3

Total

12

/

12

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.

Validation11 / 11 Passed

Validation for skill structure

No warnings or errors.

Reviewed

Table of Contents