dbt-transformation-patterns – Data & Science skill for AI agents
Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing.
Install the dbt-transformation-patterns skill with one command
Pick the tool you use, copy the command and paste it in your terminal. The skill lands in that tool's skills folder and is ready in your next session.
Claude Code
mkdir -p ~/.claude/skills && curl -fsSL https://skill.dn1nguoi.com/z/dbt-transformation-patterns-b5805.tgz | tar xz -C ~/.claude/skills
Call it in Claude Code: /dbt-transformation-patterns – then describe the task you want done.
Codex
mkdir -p ~/.codex/skills && curl -fsSL https://skill.dn1nguoi.com/z/dbt-transformation-patterns-b5805.tgz | tar xz -C ~/.codex/skills
Call it in Codex: $dbt-transformation-patterns – then describe the task you want done.
Hermes Agent
mkdir -p ~/.hermes/skills && curl -fsSL https://skill.dn1nguoi.com/z/dbt-transformation-patterns-b5805.tgz | tar xz -C ~/.hermes/skills
Call it in Hermes Agent: /dbt-transformation-patterns – then describe the task you want done.
DeepSeek
mkdir -p ~/.deepcode/skills && curl -fsSL https://skill.dn1nguoi.com/z/dbt-transformation-patterns-b5805.tgz | tar xz -C ~/.deepcode/skills
Call it in DeepSeek: /dbt-transformation-patterns – then describe the task you want done.
SKILL.md content
dbt Transformation Patterns
Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing.
Use this skill when
- Building data transformation pipelines with dbt
- Organizing models into staging, intermediate, and marts layers
- Implementing data quality tests and documentation
- Creating incremental models for large datasets
- Setting up dbt project structure and conventions
Do not use this skill when
- The project is not using dbt or a warehouse-backed workflow
- You only need ad-hoc SQL queries
- There is no access to source data or schemas
Instructions
- Define model layers, naming, and ownership.
- Implement tests, documentation, and freshness checks.
- Choose materializations and incremental strategies.
- Optimize runs with selectors and CI workflows.
- If detailed patterns are required, open
resources/implementation-playbook.md.
Resources
resources/implementation-playbook.mdfor detailed dbt patterns and examples.
Limitations
- Use this skill only when the task clearly matches the scope described above.
- Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
- Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.
Related skills
- serving-llms-vllm – vLLM: high-throughput LLM serving, OpenAI API, quantization.
- scikit-bio – Biological data toolkit. Sequence analysis, alignments, phylogenetic trees, diversity…
- spark-environment-setup – Set up a working ML training/inference environment on NVIDIA DGX Spark (GB10, aarch64…
- scikit-learn – Supports machine learning in Python with scikit-learn. Applies when working with…
- deep-research – Run autonomous research tasks that plan, search, read, and synthesize information into…
- deep-research-framework – Framework for deep research reports: define the question and tier sources first…
- dependency-analysis – Analyze internal and package dependencies using Ontoly graph traversal. Use when asked…
- spark-optimization – Optimize Apache Spark jobs with partitioning, caching, shuffle optimization, and memory…