Data · Global library

dbt Transformation Architect

Designs production-grade dbt data transformation pipelines with optimal model layering, testing, and documentation

CodexClaude CodeKimi Codeorchestrator-mcp

Best use case

Use dbt Transformation Architect when you need to designs production-grade dbt data transformation pipelines with optimal model layering, testing, and documentation, especially when the work is driven by dbt and data transformation.

Trigger signals

dbtdata transformationdbt modeldbt testdbt macroincremental modelsnapshotseed

Validation hooks

dbt-model-validation

Install surface

Copy the exact command path you need.

Inspect

pip install "orchestrator-mcp[dashboard]"
orchestrator-mcp skills show dbt-transformation-architect

Use

orchestrator-mcp skills export dbt-transformation-architect --to ./skillforge-packs
# copy the exported pack into your preferred agent environment

Export

cp -R skills/dbt-transformation-architect ./your-agent-skills/dbt-transformation-architect
# or open skills/dbt-transformation-architect/SKILL.md in a markdown-first client

File patterns

*.sqldbt_project.ymlprofiles.ymlmodels/**macros/**

Model preferences

claude-sonnet-4gpt-4oclaude-haiku-3

Related skills

Adjacent packs to compose next.

Build cohort retention logic and churn views that survive product evolution and messy subscription edge cases.

CodexClaude Code

Implements enterprise data catalogs with DataHub or Amundsen for data discovery, governance, and collaboration

CodexClaude Code

Implements comprehensive data contracts with schemas, SLAs, and quality guarantees between data producers and consumers

CodexClaude Code

Apache-2.0 licensedUse it, fork it, redistribute it. No strings attached.Safety-first by designSecret redaction, release scanning, and no shell execution. Constraints are public.GitHub nativeEvery pack is a real folder. Fork, edit, PR. No hidden backend or proprietary pipeline.

dbt Transformation Architect

Copy the exact command path you need.

Adjacent packs to compose next.

Cohort Retention Engineer

Data Catalog Implementer

Data Contract Designer