From devops-data
Provides dbt patterns for building staging, intermediate, and marts data models, incremental materializations, schema tests, and transformation pipelines in analytics engineering.
How this skill is triggered — by the user, by Claude, or both
Slash command
/devops-data:dbtThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
This skill provides dbt patterns for analytics engineering.
This skill provides dbt patterns for analytics engineering.
dbt_project/
├── dbt_project.yml
├── models/
│ ├── staging/
│ │ └── stg_customers.sql
│ ├── intermediate/
│ │ └── int_customer_orders.sql
│ └── marts/
│ └── fct_orders.sql
├── seeds/
├── macros/
├── tests/
└── snapshots/
-- models/staging/stg_customers.sql
with source as (
select * from {{ source('raw', 'customers') }}
),
renamed as (
select
id as customer_id,
lower(email) as email,
created_at
from source
)
select * from renamed
-- models/marts/fct_orders.sql
{{
config(
materialized='incremental',
unique_key='order_id'
)
}}
select *
from {{ ref('stg_orders') }}
{% if is_incremental() %}
where updated_at > (select max(updated_at) from {{ this }})
{% endif %}
# models/schema.yml
models:
- name: stg_customers
columns:
- name: customer_id
tests:
- unique
- not_null
- name: email
tests:
- unique
source()ref()npx claudepluginhub jpoutrin/product-forge --plugin devops-dataProvides production-ready patterns for dbt including model organization, testing, documentation, and incremental processing for analytics engineering.
Provides production-ready dbt patterns for model organization into layers, testing strategies, documentation, incremental processing, and project structure.
Provides dbt patterns for model organization in staging, intermediate, and marts layers, including project structure, sources, configs, SQL examples, and testing setups. Useful for data transformation projects.