Claude Code Just Got Smarter for dbt Projects скачать в хорошем качестве

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-... dbt Agent Skills (GitHub): https://github.com/dbt-labs/dbt-agent... 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/i... Set up local dbt MCP Server: https://docs.getdbt.com/docs/dbt-ai/s... 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-agen... dbt MCP Server announcement: https://docs.getdbt.com/blog/introduc... ~~~~~ 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