sql-transform-helper

Sql Transform Helper - Auto-activating skill for Data Pipelines. Triggers on: sql transform helper, sql transform helper Part of the Data Pipelines skill category.

0.98x

Quality

Does it follow best practices?

Impact

94%

0.98x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./planned-skills/generated/11-data-pipelines/sql-transform-helper/SKILL.md

Evaluation results

92%

E-Commerce Analytics: Transaction Transformation Pipeline

Output validation and data quality checks

Criteria

Without context

With context

Validation script exists

100%

NULL checks

100%

Duplicate detection

100%

Row count or completeness check

100%

Currency conversion handled

100%

Status filtering

50%

Production-ready SQL

100%

Error handling or idempotency

50%

Step-by-step pipeline doc

100%

Data quality rationale

100%

Without context: $0.4382 · 1m 56s · 21 turns · 21 in / 7,081 out tokens

With context: $0.4606 · 1m 52s · 23 turns · 314 in / 6,706 out tokens

100%

Daily Data Refresh: Multi-Step SQL Transformation Workflow

Workflow orchestration with SQL transforms

Criteria

Without context

With context

Uses orchestration framework

100%

Task dependency ordering

100%

Failure propagation

100%

SQL files are referenced

100%

Deduplication in staging

100%

Joins users for enrichment

100%

Idempotent aggregation

100%

Step-by-step README

100%

Extensibility guidance

100%

Production scheduling config

100%

Without context: $0.4576 · 1m 49s · 23 turns · 24 in / 7,423 out tokens

With context: $0.5528 · 2m 7s · 27 turns · 284 in / 8,338 out tokens

92%

-5%

Real-Time Fraud Detection: Streaming SQL Transform Pipeline

Streaming data SQL transformations

Criteria

Without context

With context

Uses streaming framework

100%

SQL transforms for rules

100%

75%

Windowing for velocity rule

70%

50%

Late data handling

100%

Schema definitions present

100%

flag_reason field populated

100%

Output sink configured

100%

Production-ready structure

100%

Step-by-step pipeline design doc

100%

Extensibility instructions

100%

Data engineering best practices

100%

Without context: $0.5867 · 2m 46s · 24 turns · 66 in / 10,421 out tokens

With context: $0.7354 · 3m 5s · 33 turns · 65 in / 11,720 out tokens

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

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

Table of Contents

E-Commerce Analytics: Transaction Transformation Pipeline Daily Data Refresh: Multi-Step SQL Transformation Workflow Real-Time Fraud Detection: Streaming SQL Transform Pipeline

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.