cte-query-builder

Cte Query Builder - Auto-activating skill for Data Analytics. Triggers on: cte query builder, cte query builder Part of the Data Analytics skill category.

1.05x

Quality

Does it follow best practices?

Impact

98%

1.05x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./planned-skills/generated/12-data-analytics/cte-query-builder/SKILL.md

Evaluation results

100%

Sales Performance Deep Dive

Multi-step CTE query construction

Criteria

Without context

With context

Uses WITH clause

100%

Multiple named CTEs

100%

Step-by-step decomposition

100%

Descriptive CTE names

100%

Production-ready formatting

100%

Inline comments present

100%

Avoids correlated subqueries

100%

Final SELECT from CTE

100%

Validation note included

100%

Without context: $0.2927 · 1m 11s · 16 turns · 16 in / 4,234 out tokens

With context: $0.5050 · 2m 9s · 24 turns · 57 in / 7,481 out tokens

95%

Employee Reporting Structure Explorer

Recursive CTE for hierarchical data

Criteria

Without context

With context

Recursive CTE syntax

100%

Anchor member present

100%

Recursive member present

100%

UNION ALL connector

100%

Depth or level tracking

100%

Path or lineage column

100%

Step-by-step decomposition

50%

Production-ready formatting

100%

Validation check included

80%

100%

Avoids procedural loops

100%

Without context: $0.1496 · 49s · 11 turns · 12 in / 2,444 out tokens

With context: $0.3708 · 1m 20s · 22 turns · 21 in / 4,474 out tokens

100%

12%

Customer Retention Metrics for the Weekly BI Dashboard

BI analytics with statistical CTEs

Criteria

Without context

With context

Uses WITH clause

100%

Multiple named CTEs

100%

Statistical metric computed

100%

Window function used

100%

Step-by-step decomposition

100%

Production-ready formatting

100%

BI context output

100%

Validation approach documented

100%

Inline comments or notes

100%

Does not repeat raw logic

100%

Without context: $0.2133 · 1m 7s · 12 turns · 15 in / 3,921 out tokens

With context: $0.4436 · 1m 38s · 25 turns · 57 in / 5,766 out tokens

Repository: jeremylongshore/claude-code-plugins-plus-skills
Commit: 0c08951

Evaluated: 18 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Sales Performance Deep Dive Employee Reporting Structure Explorer Customer Retention Metrics for the Weekly BI Dashboard

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.