compile

MCP tool from Dbt MCP by dbt-labs

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

How to use it

compile is exposed by the Dbt MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the compile tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

FULL DBT MCP LISTING

Other tools in Dbt MCP (39)

build

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

clone

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

docs

Generates documentation for the dbt project.

execute_sql

Executes SQL on dbt Platform infrastructure with Semantic Layer support.

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_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_exposure_details

(deprecated — use getnodedetails instead)

get_exposures

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

get_lineage

Gets full lineage graph (ancestors and descendants) with type and depth filtering.

get_lineage_dev

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

get_macro_details

(deprecated — use getnodedetails instead)

get_mart_models

Retrieves all mart models.

get_metrics_compiled_sql

Returns compiled SQL for metrics without executing the query.

get_model_children

(deprecated — use getlineage instead)

get_model_details

(deprecated — use getnodedetails instead)

get_model_health

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

get_model_parents

(deprecated — use getlineage 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, semanticmodel).

get_node_details_dev

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

get_related_models

Finds similar models using semantic search.

get_seed_details

(deprecated — use getnodedetails instead)

get_semantic_model_details

(deprecated — use getnodedetails instead)

get_snapshot_details

(deprecated — use getnodedetails instead)

get_source_details

(deprecated — use getnodedetails instead)

get_test_details

(deprecated — use getnodedetails instead)

list

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

list_metrics

Retrieves all defined metrics.

list_saved_queries

Retrieves all saved queries.

parse

Parses and validates project files for syntax correctness.

query_metrics

Executes metric queries with filtering and grouping options.

run

Executes models to materialize them in the database.

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

show

Executes SQL against the database and returns results.

text_to_sql

Generates SQL from natural language using project context.