complex-join-helper

Complex Join Helper - Auto-activating skill for Data Analytics. Triggers on: complex join helper, complex join helper Part of the Data Analytics skill category.

1.00x

Quality

Does it follow best practices?

Impact

100%

1.00x

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/complex-join-helper/SKILL.md

Evaluation results

100%

Retail Sales Analytics Report

Production-ready multi-table join SQL

Criteria

Without context

With context

Explicit JOIN syntax

100%

Meaningful aliases

100%

Production-ready completeness

100%

Multi-table join coverage

100%

Step-by-step breakdown

100%

Aggregation correctness

100%

Validation query included

100%

JOIN type appropriateness

100%

Column qualification

100%

Script is runnable

100%

Without context: $0.6116 · 2m 54s · 26 turns · 26 in / 10,683 out tokens

With context: $0.6537 · 2m 38s · 29 turns · 29 in / 9,604 out tokens

100%

Employee Reporting Chain Analysis

Self-join with step-by-step guidance

Criteria

Without context

With context

Self-join present

100%

Explicit JOIN syntax

100%

Distinct aliases for self-join

100%

Step-by-step approach

100%

Handles NULL manager

100%

Production-ready completeness

100%

Column qualification

100%

Validation or sanity check

100%

Runnable script

100%

Aggregation with hierarchy

100%

Without context: $0.3545 · 1m 26s · 20 turns · 2,817 in / 4,927 out tokens

With context: $0.5743 · 2m 8s · 32 turns · 321 in / 7,362 out tokens

100%

E-commerce Product Catalogue Analytics

Many-to-many join with output validation

Criteria

Without context

With context

Junction table join

100%

Explicit JOIN syntax

100%

Duplicate-aware aggregation

100%

Validation query

100%

Step-by-step explanation

100%

Production-ready completeness

100%

Column qualification

100%

Meaningful aliases

100%

Aggregation across many-to-many

100%

Runnable script

100%

Without context: $0.6712 · 2m 55s · 30 turns · 31 in / 10,757 out tokens

With context: $0.6574 · 2m 41s · 31 turns · 194 in / 9,880 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

Retail Sales Analytics Report Employee Reporting Chain Analysis E-commerce Product Catalogue Analytics

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.