CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

dbt-bigquery

Expert guidance for creating, modifying, and optimizing dbt pipelines for BigQuery. Use this skill whenever user asks for generating or modifying a dbt model or project. Activate this skill when the user - Creates, modifies, or troubleshoots **dbt models or pipelines** - Needs to **optimize SQL** within a dbt project - Is **setting up a new dbt project** or configuring existing one

Quality

82%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

67%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A highly actionable, well-sequenced expert workflow with concrete commands, validation checkpoints, and appropriate delegation to external skill protocols. Its main weaknesses are redundancy (repeated safety rules and mandates), a padded persona section, and several markdown formatting glitches that impede readability.

Suggestions

State the 'never run dbt run without confirmation' rule and the mandatory cleaning/optimization requirements once (in Execution Constraints / Operational Rules) instead of repeating them across Steps 3 and 5.

Remove or shrink the 'Role & Persona' section — instructions like 'Be direct, objective, and fact-driven' add tokens without adding capability-specific guidance.

Fix the malformed markdown: the blockquote embedded in Step 4's bullet, the collapsed 'Propose with Confirmation' bullet list, and the wrapped 'References & Sources' table rows.

DimensionReasoningScore

Conciseness

Mostly efficient directives with no conceptual padding, but it could be tightened: the 'NEVER execute dbt run without explicit user confirmation' rule appears three times, the cleaning/optimization mandate is duplicated between Step 3 and Operational Rules, and the 'Role & Persona' section is padding Claude does not need.

3 / 5

Actionability

Mostly executable guidance with concrete commands (`bq show --schema --format=prettyjson`, `dbt init --skip-profile-setup`, `gcloud config get-value project`), a concrete rewrite table (IN -> EXISTS), working config/YAML examples, and exact confirmation prompts; minor gaps include `gcloud logging read` lacking the actual filter syntax and the absence of a dbt unit-test YAML example.

4 / 5

Workflow Clarity

Steps 0-6 are clearly sequenced with explicit validation (Step 5: compile, test, fix errors) and a feedback loop (Step 6: 'Repeat steps 4-5'), plus a hard safety gate on `dbt run`; minor gaps are the thin Step 4, the hedged 'Run dbt test... if applicable' checkpoint, and inconsistent step header styles.

4 / 5

Progressive Disclosure

Good single-file structure with clear thematic sections and protocols delegated to clearly-named external skills (@skill:data-autocleaning, @skill:developing-with-bigquery) instead of being inlined; however, niche content (BigLake 4-part naming, remote-DAG troubleshooting) sits inline in a ~280-line file and malformed formatting (broken 'Propose with Confirmation' list, mangled References & Sources table) slightly hurts navigation.

4 / 5

Total

15

/

20

Passed

Description

87%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong description that clearly states what the skill does and when to activate it, with concrete dbt-specific trigger phrases and minimal conflict risk. Keyword coverage is good but could add common synonyms and variations to reach full mark.

DimensionReasoningScore

Specificity

Lists several concrete actions — 'creating, modifying, and optimizing dbt pipelines', 'Creates, modifies, or troubleshoots dbt models or pipelines', 'setting up a new dbt project' — but the verbs are somewhat generic and coverage has minor gaps (testing, profiles, specific artifacts), matching anchor 4 rather than the comprehensive anchor 5.

4 / 5

Completeness

Explicitly answers both 'what' ('Expert guidance for creating, modifying, and optimizing dbt pipelines for BigQuery') and 'when' with concrete trigger phrases ('Use this skill whenever user asks for generating or modifying a dbt model or project. Activate this skill when the user - Creates, modifies, or troubleshoots...'), matching the anchor 5 example pattern exactly.

5 / 5

Trigger Term Quality

Good natural keyword coverage — 'dbt model', 'dbt project', 'dbt pipelines', 'BigQuery', 'optimize SQL' — that users would actually say, but common synonyms and variations ('data build tool', 'dbt-core', '.sql models') are missing, so it falls short of anchor 5.

4 / 5

Distinctiveness Conflict Risk

Clear niche with distinct triggers: 'dbt' paired with 'BigQuery' throughout, and 'optimize SQL within a dbt project' is explicitly scoped, minimizing conflict with generic SQL or BigQuery skills.

5 / 5

Total

18

/

20

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 — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository

saski/arnesto

Path

.agents/skills/dbt-bigquery/SKILL.md

Reviewed

Table of Contents

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.