dbt-test-creator

Dbt Test Creator - Auto-activating skill for Data Pipelines. Triggers on: dbt test creator, dbt test creator Part of the Data Pipelines 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/11-data-pipelines/dbt-test-creator/SKILL.md

Evaluation results

100%

E-Commerce Order Pipeline Test Coverage

Production-ready dbt schema tests

Criteria

Without context

With context

Valid YAML version header

100%

Primary key unique test

100%

Primary key not_null test

100%

Referential integrity test

100%

Accepted values test

100%

No placeholder content

100%

All three models covered

100%

Multiple test types used

100%

Numeric column validation

100%

Test plan documentation

100%

Without context: $0.2726 · 1m 12s · 13 turns · 14 in / 4,122 out tokens

With context: $0.4789 · 1m 51s · 26 turns · 288 in / 6,536 out tokens

100%

ETL Pipeline Data Quality Validation

Custom singular test for ETL data quality

Criteria

Without context

With context

SQL files in tests/ directory

100%

Failure-row convention

100%

Uses ref() macro

100%

Transaction count reconciliation test

100%

Currency orphan test

100%

No hardcoded values

100%

Step-by-step documentation

100%

ETL-relevant concerns addressed

100%

Complete, runnable SQL

100%

Without context: $0.5203 · 2m 25s · 26 turns · 24 in / 8,490 out tokens

With context: $0.5198 · 2m 13s · 27 turns · 287 in / 7,697 out tokens

100%

Real-Time Sensor Data Pipeline Test Suite

dbt tests for streaming and workflow orchestration models

Criteria

Without context

With context

Valid YAML structure

100%

Duplicate detection test

100%

Not-null primary key

100%

All three models in YAML

100%

Out-of-range or value validation

100%

Streaming-specific concern addressed

100%

No placeholders

100%

Custom singular test present

100%

Pipeline-level documentation

100%

Device-level validation

100%

Without context: $0.6060 · 2m 41s · 30 turns · 30 in / 9,798 out tokens

With context: $0.6987 · 3m 9s · 34 turns · 67 in / 11,325 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

E-Commerce Order Pipeline Test Coverage ETL Pipeline Data Quality Validation Real-Time Sensor Data Pipeline Test Suite

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.