Dbt MCP

execute_sql

Executes SQL on dbt Platform infrastructure with Semantic Layer support.

text_to_sql

Generates SQL from natural language using project context.

get_dimension_values

Gets distinct values for a dimension; option to scope to specific metrics.

get_dimensions

Gets dimensions for specified metrics.

get_entities

Gets entities for specified metrics.

get_metrics_compiled_sql

Returns compiled SQL for metrics without executing the query.

list_metrics

Retrieves all defined metrics.

list_saved_queries

Retrieves all saved queries.

query_metrics

Executes metric queries with filtering and grouping options.

get_all_macros

Retrieves macros; option to filter by package or return package names only.

get_all_models

Retrieves name and description of all models.

get_all_sources

Gets all sources with freshness status; option to filter by source name.

get_exposure_details

(deprecated — use get_node_details instead)

get_exposures

Gets all exposures (downstream dashboards, apps, or analyses).

get_lineage

Gets a bounded lineage graph with type, depth, and direction filtering.

get_macro_details

(deprecated — use get_node_details instead)

get_mart_models

Retrieves all mart models.

get_model_children

(deprecated — use get_lineage instead)

get_model_details

(deprecated — use get_node_details instead)

get_model_health

Gets health signals: run status, test results, and upstream source freshness.

get_model_parents

(deprecated — use get_lineage instead)

get_model_performance

Gets execution history for a model; option to include test results.

get_node_details

Gets full details for any dbt resource type (model, source, exposure, test, seed, snapshot, macro, semantic_model).

get_related_models

Finds similar models using semantic search.

get_seed_details

(deprecated — use get_node_details instead)

get_semantic_model_details

(deprecated — use get_node_details instead)

get_snapshot_details

(deprecated — use get_node_details instead)

get_source_details

(deprecated — use get_node_details instead)

get_test_details

(deprecated — use get_node_details instead)

search

[Alpha] Searches for resources across the dbt project (not generally available).

build

Executes models, tests, snapshots, and seeds in DAG order.

clone

Clones selected nodes from the specified state to the target schema(s).

compile

Generates executable SQL from models/tests/analyses; useful for validating Jinja logic.

docs

Generates documentation for the dbt project.

get_lineage_dev

Retrieves lineage from local manifest.json with type and depth filtering.

get_node_details_dev

Retrieves node details from local manifest.json (models, seeds, snapshots, sources).

list

Lists resources in the dbt project by type with selector support.

parse

Parses and validates project files for syntax correctness.

run

Executes models to materialize them in the database.

show

Executes SQL against the database and returns results.