dbt MCP Server: Setup for Claude, Cursor and Other Apps

• Lists your defined metrics

  Retrieves all metrics defined in the dbt Semantic Layer.

  Try: “What metrics do we have?”

  Read · list_metrics

• Queries a metric with filters

  Runs a metric query with filtering and grouping options.

  Try: “Show monthly revenue by region for 2025.”

  Read · query_metrics

• Lists dimensions for metrics

  Gets the dimensions available for chosen metrics.

  Try: “What can I break revenue down by?”

  Read · get_dimensions

• Lists values of a dimension

  Gets the distinct values of a dimension, optionally for chosen metrics.

  Try: “Which regions exist?”

  Read · get_dimension_values

• Lists entities for metrics

  Gets the entities for chosen metrics.

  Try: “What entities does the revenue metric use?”

  Read · get_entities

• Shows the SQL behind a metric

  Returns compiled SQL for metrics without running the query.

  Try: “Show the SQL for monthly revenue.”

  Read · get_metrics_compiled_sql

• Lists saved metric queries

  Retrieves all saved queries.

  Try: “List the saved queries.”

  Read · list_saved_queries

• Runs SQL on dbt platform

  Runs SQL on dbt platform infrastructure with Semantic Layer support.

  Try: “Run a query to count orders by status.”

  Read · execute_sql

• Writes SQL from a plain question

  Generates SQL from natural language using your project context.

  Try: “Write SQL for total sales by month.”

  Read · text_to_sql

• Lists all models

  Retrieves the name and description of every model.

  Try: “List all models in my project.”

  Read · get_all_models

• Lists mart models

  Retrieves all mart models.

  Try: “Which mart models do we have?”

  Read · get_mart_models

• Lists sources and freshness

  Gets all sources with their freshness status.

  Try: “Which sources are stale?”

  Read · get_all_sources

• Lists macros

  Retrieves macros, optionally filtered by package.

  Try: “List the macros in the dbt_utils package.”

  Read · get_all_macros

• Lists dashboards and apps fed by dbt

  Gets all exposures, the downstream dashboards, apps or analyses.

  Try: “Which dashboards depend on our models?”

  Read · get_exposures

• Shows details of any dbt resource

  Gets full details for a model, source, exposure, test, seed, snapshot, macro or semantic model.

  Try: “Show details of the orders model.”

  Read · get_node_details

• Shows what feeds what

  Gets a lineage graph filtered by type, depth and direction.

  Try: “What sits upstream of the orders model?”

  Read · get_lineage

• Checks a model's health

  Gets run status, test results and upstream source freshness for a model.

  Try: “Is the orders model healthy?”

  Read · get_model_health

• Shows a model's run history

  Gets execution history for a model, optionally with test results.

  Try: “How long did the orders model take over the last 10 runs?”

  Read · get_model_performance

• Finds similar models

  Finds similar models using semantic search.

  Try: “Find models similar to customers.”

  Read · get_related_models

• Finds public models across projects

  Finds public dbt Mesh models across projects and confirms who produced them. Multi-project setups only.

  Try: “Find a public customers model in other projects.”

  Read · search_public_mesh_models

• Searches dbt resources (alpha)

  Searches for resources across the dbt project. Alpha and not generally available.

  Try: “Search for revenue.”

  Read · search

• Builds models, tests and seeds

  Runs models, tests, snapshots and seeds in dependency order with the dbt command line.

  Try: “Build the orders model and everything downstream.”

  Runs code · build

• Runs models

  Executes models to create tables and views in your database.

  Try: “Run the orders model.”

  Runs code · run

• Runs tests

  Runs tests to check data and model integrity.

  Try: “Run the tests on orders.”

  Runs code · test

• Compiles models to SQL

  Generates executable SQL from models, tests and analyses.

  Try: “Compile the orders model.”

  Runs code · compile

• Checks project files

  Parses and validates project files for syntax errors.

  Try: “Check my dbt project for errors.”

  Runs code · parse

• Lists project resources

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

  Try: “List all models tagged finance.”

  Runs code · list

• Runs SQL against your database

  Runs SQL against the database and returns results.

  Try: “Show 10 rows from the orders model.”

  Runs code · show

• Clones nodes between environments

  Clones selected nodes from a given state to target schemas.

  Try: “Clone production models to my dev schema.”

  Runs code · clone

• Generates project docs

  Generates documentation for the dbt project.

  Try: “Generate the docs.”

  Runs code · docs

• Shows lineage from your local project

  Retrieves lineage from the local manifest file, filtered by type and depth.

  Try: “What depends on stg_orders locally?”

  Read · get_lineage_dev

• Shows local node details

  Retrieves node details from the local manifest for models, seeds, snapshots and sources.

  Try: “Show the local definition of orders.”

  Read · get_node_details_dev

• Lists dbt platform projects

  Lists all projects in the dbt platform account.

  Try: “List our dbt projects.”

  Read · list_projects

• Lists jobs

  Lists jobs in a dbt platform account, optionally by project or environment.

  Try: “List jobs in the analytics project.”

  Read · list_jobs

• Shows a job's setup

  Gets a job's configuration, triggers, schedule and commands.

  Try: “Show how the nightly job is set up.”

  Read · get_job_details

• Lists job runs

  Lists job runs, filtered by job or status.

  Try: “Show failed job runs from today.”

  Read · list_jobs_runs

• Shows a job run

  Gets run status, timing, steps and artifacts.

  Try: “Show details of the last nightly run.”

  Read · get_job_run_details

• Explains why a run failed

  Gets error and warning details for a job run.

  Try: “Why did the last nightly run fail?”

  Read · get_job_run_error

• Lists a run's artifacts

  Lists the artifacts available from a job run.

  Try: “What artifacts did the last run produce?”

  Read · list_job_run_artifacts

• Downloads a run artifact

  Downloads one artifact from a job run, with optional jq filtering.

  Try: “Get run_results.json from the last run.”

  Read · get_job_run_artifacts

• Starts a job run

  Triggers a job run, optionally overriding git branch, schema or other settings.

  Try: “Run the nightly job now.”

  Runs code · trigger_job_run

• Retries a failed run

  Retries a failed job run.

  Try: “Retry the failed nightly run.”

  Runs code · retry_job_run

• Cancels a running job

  Cancels a job run that is in progress.

  Try: “Cancel the running nightly job.”

  Runs code · cancel_job_run

• Writes model YAML

  Generates model YAML with columns, optionally inheriting upstream descriptions.

  Try: “Generate YAML for the orders model.”

  Write · generate_model_yaml

• Writes source YAML

  Generates source YAML by reading database schemas.

  Try: “Generate source YAML for the raw schema.”

  Write · generate_source

• Writes a staging model

  Generates staging model SQL from a source table.

  Try: “Create a staging model for raw.orders.”

  Write · generate_staging_model

• Compiles SQL with Fusion

  Compiles SQL in project context through dbt platform.

  Try: “Compile this SQL against my project.”

  Read · fusion.compile_sql

• Traces a column's origin on the platform

  Traces column-level lineage through dbt platform.

  Try: “Where does orders.total come from?”

  Read · fusion.get_column_lineage

• Traces a column's origin locally

  Traces column-level lineage locally. Needs dbt-lsp from the dbt Labs VS Code extension.

  Try: “Trace orders.total locally.”

  Read · get_column_lineage

• Searches the dbt docs

  Searches docs.getdbt.com and returns titles, URLs and descriptions.

  Try: “How do I set up incremental models?”

  Read · search_product_docs

• Reads dbt doc pages

  Fetches the full Markdown of docs.getdbt.com pages.

  Try: “Open the incremental models doc.”

  Read · get_product_doc_pages

• Shows the server version

  Returns the version of the running dbt MCP server.

  Try: “Which dbt MCP version is running?”

  Read · get_mcp_server_version

• Shows the server's git branch

  Returns the git branch of the running dbt MCP server.

  Try: “Which branch is the dbt MCP server on?”

  Read · get_mcp_server_branch

Watch out for

• dbt commands can change your warehouse

  build, run and clone create or replace tables and views, and the SQL tools run what the assistant writes. Run against a development target, not production. raw.githubusercontent.com

• It can start and cancel platform jobs

  It can trigger, retry and cancel dbt platform job runs. Use a service token with only the permissions you need. raw.githubusercontent.com

Security advisories