Claude Code Just Got Smarter for dbt Projects

Using the dbt Agent Skills and dbt MCP Server (or dbt CLI) from dbt Labs will help give Claude Code and your other coding assistants (Cursor, Codex, etc.) better context for it to be more successful when building, auditing, enhancing, and fixing your dbt projects and pipelines in about 10 minutes.

This is a step-by-step setup guide for analytics/data engineers who want to integrate Claude Code (or Cursor or Codex) into their dbt workflow. I'm walking through this as I build a dbt repo from scratch, so there is some helpful troubleshooting to some problems you might encounter present in this demo. The setup and troubleshooting is worth it, as this integration will be game-changing for your data flows.

In this video, you'll learn:
1) How to utilize Claude Code and other AI coding tools to their best of their abilities with dbt to create, audit, and enhance projects
2) How to get this demo dbt project running locally with DuckDB and Claude Code in minutes
3) How to install dbt Agent Skills with one command and what it adds to your AI assistant's context
4) How to configure the dbt MCP Server so Claude Code and other AI coding agents can query your project's live lineage, schemas, and test coverage at runtime
5) Why both tools matter together: Skills are the conventions (the textbook), MCP is the live project metadata (the codebase)
6) How to troubleshoot setup with the dbt MCP

~~~~~
RESOURCES

Repos:
- dbt Agentic Development: https://github.com/kyle-chalmers/dbt-agentic-development
- dbt Agent Skills (GitHub): https://github.com/dbt-labs/dbt-agent-skills
- dbt MCP Server (GitHub): https://github.com/dbt-labs/dbt-mcp

Setup & Documentation:
- Integrate Claude with dbt MCP (official guide): https://docs.getdbt.com/docs/dbt-ai/integrate-mcp-claude
- Set up local dbt MCP Server: https://docs.getdbt.com/docs/dbt-ai/setup-local-mcp
- dbt Core Documentation: https://docs.getdbt.com/
- Claude Code: https://code.claude.com/docs
- DuckDB: https://duckdb.org/
- dbt Agent Skills announcement: https://docs.getdbt.com/blog/dbt-agent-skills
- dbt MCP Server announcement: https://docs.getdbt.com/blog/introducing-dbt-mcp-server

~~~~~
CHAPTERS

00:00 – Why You Should Watch This Video
00:59 – What dbt Agent Skills Do
02:02 – What dbt MCP Server Does
03:06 – Why Use dbt Agent Skills and dbt MCP Together for AI
03:49 – Using dbt CLI vs. dbt MCP
05:05 – Step 1: Setting Up dbt Project
05:48 – Reviewing dbt init Output and Terminal Setup
07:37 – Step 2.1: Installing dbt Agent Skills
09:21 – Step 2.2: Initial dbt MCP Server Install Attempt
10:06 – Step 2.2: Troubleshooting the dbt MCP
11:28 – Step 2.3: Final dbt MCP Setup
12:29 – Avoiding this dbt MCP Setup Error in the Future
12:58 – Validating the dbt Skills and MCP
14:03 – Why You Won’t Run Into Setup Issues Following My Instructionsl
14:31 – Building the dbt Model with Claude Code
17:03 – Reviewing Claude Code’s dbt Model Output
18:41 – Auditing and Enhancing the dbt Model with Claude Code
21:15 – Reviewing Claude Code’s dbt Audit and Enhancements
23:16 – Call to Action

~~~~~

I'm Kyle Chalmers and after 9+ years leading data teams, I'm here to make AI approachable for all data professionals and enthusiasts. Subscribe for weekly insights, demos, and lessons on the future of data work.

Contact me on my company's website: https://kclabs.ai/contact
Follow me on Substack: https://kylechalmerslabs.substack.com/
#dbt #claudecode #analyticsengineering #dataengineer #mcp #ai #dataengineering #aitools #dataskills #analyticsengineers #codex #cursor

Видео Claude Code Just Got Smarter for dbt Projects канала Kyle Chalmers | Data + AI