configuring-dbt-mcp-server

Enables Claude to automatically assist with dbt workflows including model development, testing, semantic layer creation, and platform operations through natural language prompts.

Transforms data using dbt's analytics engineering principles, building modular models, tests, and pipelines with software engineering best practices.

Answers business data questions by intelligently querying dbt semantic layers, models, and project metadata to provide precise insights.

Diagnoses and resolves dbt Cloud job failures by systematically investigating error types, logs, and potential root causes using MCP tools and CLI commands.

Guides users in creating and configuring dbt Semantic Layer components like semantic models, metrics, and dimensions using MetricFlow.

Validates dbt model SQL logic by testing specific input scenarios and expected outputs before full model materialization.

Retrieves and searches dbt documentation efficiently by converting URLs to markdown and using specialized search techniques.

A dbt commands skill from dbt Agent Skills by dbt Labs, helping AI agents with analytics engineering, semantic layer, platform operations, and project migration workflows.

Guides users through migrating a dbt Core project to the Fusion engine, identifying and resolving compatibility issues automatically.

Automates comprehensive data warehouse auditing by analyzing dbt models, detecting schema changes, and identifying potential data quality risks.