fix-pipeline-dbt-task

fix-pipeline-dbt-task is a skill for Claude Code from orchestra-hq/orchestra-skills. It costs 103 tokens per session (1,863 once invoked), scanned A, original, MIT.

A repair workflow for a failed dbt Core task in an Orchestra pipeline. dbt Core is a tool that turns SQL transformation code into managed data models.

In plain words
What is it for?
It is for inspecting the failed task, changing the relevant repository code or settings, validating the result on a branch, and confirming or merging the fix.
Why use it?
It separates dbt code or configuration failures from pipeline-platform failures and provides a path to validate the fix before merging it.

Skill for Claude Code

Written for Claude Code: shipped in a Claude Code plugin.

Part of the orchestra plugin — 19 skills, 1 hook shipped together

Good fit It is for inspecting the failed task, changing the relevant repository code or settings, validating the result on a branch, and confirming or merging the fix.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/orchestra-hq/orchestra-skills/fix-pipeline-dbt-task
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add orchestra-hq/orchestra-skills --skill fix-pipeline-dbt-task
Clone the repo
git clone --depth 1 https://github.com/orchestra-hq/orchestra-skills

Made for: Claude Code.

Or install orchestra, the plugin that ships this one along with the rest of its 19 skills, 1 hook.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for fix-pipeline-dbt-task

README.md
[![agentmods](https://agentmods.dev/badge/skills/orchestra-hq/orchestra-skills/fix-pipeline-dbt-task/github.svg)](https://agentmods.dev/skills/orchestra-hq/orchestra-skills/fix-pipeline-dbt-task)
Your own site
<a href="https://agentmods.dev/skills/orchestra-hq/orchestra-skills/fix-pipeline-dbt-task"><img src="https://agentmods.dev/badge/skills/orchestra-hq/orchestra-skills/fix-pipeline-dbt-task/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for fix-pipeline-dbt-task

Your own site · 80×15
<a href="https://agentmods.dev/skills/orchestra-hq/orchestra-skills/fix-pipeline-dbt-task"><img src="https://agentmods.dev/badge/skills/orchestra-hq/orchestra-skills/fix-pipeline-dbt-task.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 103 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,863 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00103 $0.01863
Opus 5.5 $0.00041 $0.00745
Sonnet 5.5 $0.00021 $0.00373
Haiku 4.5 $0.00010 $0.00186

Measured 1mo ago against content hash b6107b3732a0, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

fix-pipeline-dbt-task scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 1mo ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/orchestra/skills/fix-pipeline-dbt-task/SKILL.md · 96 lines

How it starts

The opening of the file, as written. The whole thing — 96 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Fix → validate on a branch → confirm → merge. Narrate each step briefly, like a data engineer. Never print secrets/tokens.

0. Access

MCP is preferred but optional. If the Orchestra MCP tools aren't present, use the public REST API directly with $ORCHESTRA_API_KEY (check the env — it's often already set). For git, $GITHUB_TOKEN is usually set too. If neither MCP nor a key is available, point the user at the Orchestra MCP setup docs (https://docs.getorchestra.io/docs/mcp) or ask for an API key, then stop.

Base: https://app.getorchestra.io/api/engine/public — header Authorization: Bearer $ORCHESTRA_API_KEY.

1. Inputs from identify-pipeline-error

identify-pipeline-error hands you: the pipeline run ID (RID), pipeline ID (PID), the failed dbt task run ID (TRID), integration=DBT_CORE, the run branch/commit, the task's taskParameters, and the cause classification (a dbt code/config issue). Use them directly — don't re-run the identification.

If invoked standalone (no handoff): run identify-pipeline-error first, or do its minimum yourself — GET /pipeline_runs?pipeline_run_ids=<RID> then GET /task_runs?pipeline_ids=<PID>&page_size=50 (filter to this RID client-side; the pipeline_run_ids filter does not work on /task_runs, 7-day window) to find the FAILED dbt task.

Capture taskParameters exactly — especially branch, commands, project_dir, use_state_orchestration. These are run inputs you must preserve on retry. The pipeline run's branch is where the Orchestra YAML lives; the dbt clone branch is a separate task param (commonly an input like dbt_branch).

Pull the logs you'll fix against:

GET /pipeline_runs/<RID>/task_runs/<TRID>/logs                                  # list filenames
GET /pipeline_runs/<RID>/task_runs/<TRID>/logs/download?filename=1/debug_task   # URL-encode spaces, e.g. 1/dbt%20run

debug_task = dbt debug (config/YAML validation); dbt run / dbt build = compile + execution.

Read the full file on GitHub · 96 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 1mo ago First seen · 96 lines · 103 tokens per session scan A b6107b3732a0

Subscribe to this mod's changes

fix-pipeline-dbt-task is a skill published in the GitHub repository orchestra-hq/orchestra-skills (9 stars, last pushed yesterday), licensed MIT. It adds 103 tokens to every session and 1,863 once invoked, about $0.0004 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-09.

Related

Other skills, from other repositories