Tools (25)

execute_sqltext_to_sqllist_metricsquery_metricsget_all_modelsget_all_sourcesget_lineageget_model_detailsget_model_childrenget_model_parentsget_model_healthsearchbuildcompileruntestlist_jobstrigger_job_runget_job_detailsget_job_run_detailsget_job_run_errorgenerate_model_yamlgenerate_sourcegenerate_staging_modelsearch_product_docs

Client configuration

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "dbt": {
      "command": "uvx",
      "args": [
        "dbt-mcp@2.2.1"
      ],
      "env": {
        "DBT_HOST": "your-dbt-host-here",
        "DBT_TOKEN": "your-dbt-token-here",
        "DBT_PROD_ENV_ID": "your-dbt-prod-env-id-here",
        "DBT_DEV_ENV_ID": "your-dbt-dev-env-id-here"
      }
    }
  }
}

VS Code (.vscode/mcp.json)

{
  "servers": {
    "dbt": {
      "command": "uvx",
      "args": [
        "dbt-mcp@2.2.1"
      ],
      "env": {
        "DBT_HOST": "your-dbt-host-here",
        "DBT_TOKEN": "your-dbt-token-here",
        "DBT_PROD_ENV_ID": "your-dbt-prod-env-id-here",
        "DBT_DEV_ENV_ID": "your-dbt-dev-env-id-here"
      },
      "type": "stdio"
    }
  }
}

Replace the placeholders before connecting. Authorize in your client when prompted.

The Cursor JSON also works in Claude Desktop's local MCP configuration. Install the required runtime and local software first.

Documentation →

dbt

Tags

Tools (25)

Client configuration

Cursor (.cursor/mcp.json)

VS Code (.vscode/mcp.json)

Related Servers