CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

dbt-core-prefect-to-orchestra

Use this skill when the user wants to convert a Prefect task that runs dbt Core commands — DbtCoreOperation block, ShellOperation running dbt CLI, run_dbt_build / run_dbt_test tasks, or DbtCloudJob — into an equivalent Orchestra pipeline task. Triggers: any mention of migrating or rewriting Prefect dbt tasks to Orchestra; any Prefect flow code importing from prefect_dbt; ShellOperation commands starting with 'dbt '.

Quality

85%

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

75%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.

The body is highly actionable: complete executable YAML for both dbt variants, a concrete before/after example, and precise Orchestra-specific gotchas with exact syntax for semicolon joining, env-var naming, and MANUAL flags. Its main weaknesses are redundancy — the project_dir and package_manager rules are each restated three or four times across the table, steps, and gotchas — and the absence of any bundle references despite a body over 150 lines, leaving the linked-connections detail inline.

Suggestions

State each rule once: keep the Parameter Mapping table as the single source for project_dir and package_manager guidance, and trim the verbatim repeats in Conversion Steps and Gotchas to short cross-references.

Move the 'Warehouse Credentials: Link, Don't Copy' section (env-var naming scheme, profiles.yml example, failure modes) into a references/ file (e.g. references/linked-connections.md) linked from a brief summary, reducing SKILL.md toward an overview.

Add an explicit final validation step to Conversion Steps, e.g. 'Render the YAML and confirm the trailing semicolon, connection name, and any # MANUAL: flags with the user before considering the migration done.'

DimensionReasoningScore

Conciseness

The body is dense with Orchestra-specific facts Claude would not know (integration names, env-var naming scheme, linked-connection behavior) and does not explain dbt/Prefect basics. However, the same rules are repeated across sections — project_dir guidance appears in the mapping table, Conversion Steps, Gotchas, and comments in both YAML examples; package_manager inference appears three times — which is more than minor over-explanation, fitting anchor 3 rather than 4.

3 / 5

Actionability

Provides two complete copy-paste YAML examples (dbt Core and dbt Cloud), a full before/after Python-to-YAML pair, an exact '# MANUAL:' comment pattern for the ambiguous package_manager case, and an executable env_var() profiles.yml snippet. Fully executable and covering the common cases, matching anchor 5.

5 / 5

Workflow Clarity

Conversion Steps is a clearly sequenced checklist with variant branching (dbt Core vs dbt Cloud) and flag-don't-guess checkpoints for package_manager and unsupported Python versions. There is no explicit post-conversion validation step (e.g. confirming the YAML or reviewing output with the user), so it fits anchor 4 rather than 5; the task is code generation, not destructive/batch, so the workflow-clarity cap at 3 does not apply.

4 / 5

Progressive Disclosure

No bundle files exist, so everything is inline in a ~170-line body. Section headers are clear, external doc links are grouped under References, and alert handling is appropriately offloaded to the prefect-alerts-to-orchestra skill. Because the body exceeds 50 lines and all content (including the detailed linked-connections section) is inline with no well-signaled reference files, it fits anchor 4 rather than 5.

4 / 5

Total

16

/

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.

The description is strong: it states a precise conversion capability, enumerates the exact Prefect constructs it handles, and gives explicit, natural trigger guidance in third person. Its only weaknesses are minor — the action list is a single conversion applied to variants, and a few common phrasings (e.g. 'move Prefect flows to Orchestra') are absent from the triggers.

DimensionReasoningScore

Specificity

Names the concrete action ('convert a Prefect task that runs dbt Core commands ... into an equivalent Orchestra pipeline task') and enumerates specific source constructs (DbtCoreOperation, ShellOperation, run_dbt_build / run_dbt_test, DbtCloudJob). It is one core action with enumerated variants rather than multiple distinct actions, so it fits anchor 4 better than 5.

4 / 5

Completeness

Explicitly answers both what ('convert ... into an equivalent Orchestra pipeline task') and when ('Use this skill when...' plus a concrete 'Triggers:' list). Both are explicit with concrete trigger phrases, matching anchor 5; score 4 would require the 'when' to be less explicit than it is.

5 / 5

Trigger Term Quality

Triggers include natural phrases users would say — 'migrating or rewriting Prefect dbt tasks to Orchestra', 'Prefect flow code importing from prefect_dbt', "ShellOperation commands starting with 'dbt '". A few natural variants (e.g. 'move Prefect flows to Orchestra', 'dbt Cloud job') are missing, matching anchor 4 rather than 5.

4 / 5

Distinctiveness Conflict Risk

Clear niche (Prefect dbt tasks to Orchestra) with distinctive triggers (prefect_dbt imports, DbtCoreOperation, DbtCloudJob, 'dbt ' ShellOperation commands) that are unlikely to fire for unrelated skills. Minimal conflict risk, matching anchor 5.

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

orchestra-hq/orchestra-skills

Path

skills/migrate-to-orchestra/skills/dbt-core-prefect-to-orchestra/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.