Stats
Actions
Tags
From data-pipeline
Expert guidance for working with dbt Core. ALWAYS use before doing any task that requires knowledge specific to dbt, including building or modifying models, writing SQL transformations, configuring tests, running dbt CLI commands, or working with dbt project structure. Common triggers include references to dbt, models, ref(), source(), materializations, seeds, snapshots, dbt build/run/test, YAML schema files, or analytics engineering patterns.
How this skill is triggered — by the user, by Claude, or both
Slash command
/data-pipeline:dbt-expertThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Brief definitions only (see reference files for detailed examples):
Brief definitions only (see reference files for detailed examples):
.sql file) that dbt materializes into a view, table, or incremental object in the warehouse{{ source('schema', 'table') }}{{ ref('model_name') }} — which builds the DAG and handles schema resolutiondbt seeddbt snapshotdbt Core is invoked via the dbt CLI. Key commands:
dbt build — The preferred command. Runs models, tests, snapshots, and seeds in DAG order.dbt run — Materializes models only (no tests).dbt test — Runs tests only.dbt show — Compiles and runs a model/query, printing results to the terminal. Use for quick validation without materializing.dbt compile — Compiles SQL without executing. Useful for inspecting generated SQL.dbt debug — Validates project configuration and warehouse connectivity.Use --select and --exclude to target specific nodes:
dbt build --select my_model # single model
dbt build --select my_model+ # model and all downstream
dbt build --select +my_model # model and all upstream
dbt build --select +my_model+ # model with full lineage
dbt build --select tag:daily # all nodes with a tag
dbt build --exclude my_model # everything except this model
NEVER answer from memory or guess at dbt syntax, YAML schema, or CLI flags. ALWAYS read the relevant reference file(s) from the Reference Index below before responding.
For every question, identify which reference file(s) are relevant using the index descriptions, read them, then answer based on what you read.
npx claudepluginhub cdcoonce/claude-workflow --plugin data-pipelineSearches MemPalace before answering questions about past work, people, projects, or prior decisions. Returns verbatim stored content instead of guessing from model memory.
Guides Payload CMS config (payload.config.ts), collections, fields, hooks, access control, APIs. Debugs validation errors, security, relationships, queries, transactions, hook behavior.
Implements vector databases with Pinecone, Weaviate, Qdrant, Milvus, pgvector for semantic search, RAG, recommendations, and similarity systems. Optimizes embeddings, indexing, and hybrid search.