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.
100
100%
Does it follow best practices?
Impact
Pending
No eval scenarios have been run
Passed
No known issues
Quality
Discovery
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 thoroughly enumerates specific T-SQL analytics capabilities while clearly stating when it should be used. It covers a comprehensive range of BI/reporting scenarios with natural trigger terms that users would actually employ. The description is well-structured, concise despite its detail, and occupies a clearly distinct niche.
| Dimension | Reasoning | Score |
|---|---|---|
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 for gap-filling, running totals and moving averages with window functions, year-over-year comparisons, materialized views for dashboards, and CSV/JSON exports. | 3 / 3 |
Completeness | Clearly answers both 'what' (the extensive list of specific T-SQL analytics capabilities) and 'when' with an explicit 'Use when writing T-SQL for business intelligence, analytics, or reporting' clause at the beginning. | 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, dashboards, CSV, JSON, SQL Server. These are terms a user working in BI/analytics would naturally use. | 3 / 3 |
Distinctiveness Conflict Risk | Highly distinctive with a clear niche: T-SQL specifically for BI/analytics/reporting on SQL Server. The combination of T-SQL dialect, BI-specific constructs (GROUPING SETS, CUBE, ROLLUP), and reporting-oriented tasks (dashboards, exports, YoY comparisons) makes it unlikely to conflict with general SQL skills or other database skills. | 3 / 3 |
Total | 12 / 12 Passed |
Implementation
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. It covers a broad domain (SQL BI & Reporting) with remarkable density — every section delivers executable code, comparison tables, and specific gotchas without wasting tokens on concepts Claude already knows. The progressive disclosure is textbook: concise patterns in the main file with clearly signaled references for deeper dives. The Common Mistakes table alone is worth significant value, covering 14 specific pitfalls with concrete fixes.
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | Every section is dense with actionable content. No unnecessary explanations of what SQL is or how databases work. The tables are compact and information-rich. The 'When NOT to use' section efficiently scopes the skill without over-explaining. | 3 / 3 |
Actionability | Provides fully executable T-SQL code for every pattern (running totals, moving averages, tally tables, gap filling, pivot/unpivot, JSON export). Includes both SQL Server 2022+ and pre-2022 alternatives. The Common Mistakes table pairs each mistake with a concrete fix. | 3 / 3 |
Workflow Clarity | The Validation Checklist provides explicit verification steps for BI queries covering subtotals, window frames, date filters, gap fills, dynamic PIVOT inspection, and export shape. The dynamic PIVOT section specifically calls out printing and inspecting generated SQL before execution. For a reference/pattern skill rather than a destructive multi-step process, this is thorough. | 3 / 3 |
Progressive Disclosure | Excellent structure: the main file provides concise patterns with executable examples, then clearly signals one-level-deep references for each topic area (aggregation-patterns.md, time-series.md, tally-tables.md, etc.). The Reference Files table at the end provides a clean navigation index with topic descriptions. | 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.
Validation — 11 / 11 Passed
Validation for skill structure
No warnings or errors.
Reviewed
Table of Contents