# Dbt Transformation Patterns > Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or ... Use when this capability is needed. - Skill: `tomevault-io/dbt-transformation-patterns-2` (Agent Skill, multi-file: 2 files) - Install (CLI): `npx skillmds@latest add tomevault-io/dbt-transformation-patterns-2` - Raw SKILL.md: https://api.skillmd.com/api/skills/tomevault-io/dbt-transformation-patterns-2/raw - Safety review: pending - Works with: Claude Code, Claude.ai, OpenAI Codex - Category: Data & Analytics - Author: tomevault-io (https://skillmd.com/u/tomevault-io) - Updated: 2026-09-17 - Page: https://skillmd.com/skills/tomevault-io/dbt-transformation-patterns-2 --- # 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.md` for detailed dbt patterns and examples. --- ## AGI Framework Integration > **Adapted for [@techwavedev/agi-agent-kit](https://www.npmjs.com/package/@techwavedev/agi-agent-kit)** > Original source: [antigravity-awesome-skills](https://github.com/sickn33/antigravity-awesome-skills) ### Memory-First Protocol Retrieve prior API design decisions, database schema choices, and error handling patterns. Cache API response templates for consistent error formatting. ```bash # Check for prior backend/API context before starting python3 execution/memory_manager.py auto --query "API design patterns and architecture decisions for Dbt Transformation Patterns" ``` ### Storing Results After completing work, store backend/API decisions for future sessions: ```bash python3 execution/memory_manager.py store \ --content "API architecture: REST with HATEOAS, JWT auth, rate limiting at 100 req/min per tenant" \ --type decision --project \ --tags dbt-transformation-patterns backend ``` ### Multi-Agent Collaboration Share API contract changes with frontend agents so they update their client code, and with QA agents for test coverage. ```bash python3 execution/cross_agent_context.py store \ --agent "" \ --action "Implemented API endpoints — 5 new routes with OpenAPI spec and integration tests" \ --project ``` ### Agent Team: Code Review After implementation, dispatch `code_review_team` for two-stage review (spec compliance + code quality) before merging. --- > Converted and distributed by [TomeVault](https://tomevault.io/claim/techwavedev) — claim your Tome and manage your conversions.