dbt_run

dbt_run

Execute dbt models to transform data and build analytical tables in the data warehouse. Use to refresh data or implement new data transformations in a project, returning command output as text.

Instructions

Run dbt models. An AI agent should use this tool when it needs to execute dbt models to transform data and build analytical tables in the data warehouse. This is essential for refreshing data or implementing new data transformations in a project.

    Returns:
        Output from the dbt run command as text (this command does not support JSON output format)
    

Input Schema

Name	Required	Description	Default
`exclude`	No	Models to exclude
`full_refresh`	No	Whether to perform a full refresh
`models`	No	Specific models to run, using the dbt selection syntax (e.g., "model_name+")
`profiles_dir`	No	Directory containing the profiles.yml file (defaults to project_dir if not specified)
`project_dir`	No	ABSOLUTE PATH to the directory containing the dbt project (e.g. '/Users/username/projects/dbt_project' not '.')	.
`selector`	No	Named selector to use

Input Schema (JSON Schema)

{
  "properties": {
    "exclude": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Models to exclude",
      "title": "Exclude"
    },
    "full_refresh": {
      "default": false,
      "description": "Whether to perform a full refresh",
      "title": "Full Refresh",
      "type": "boolean"
    },
    "models": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Specific models to run, using the dbt selection syntax (e.g., \"model_name+\")",
      "title": "Models"
    },
    "profiles_dir": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Directory containing the profiles.yml file (defaults to project_dir if not specified)",
      "title": "Profiles Dir"
    },
    "project_dir": {
      "default": ".",
      "description": "ABSOLUTE PATH to the directory containing the dbt project (e.g. '/Users/username/projects/dbt_project' not '.')",
      "title": "Project Dir",
      "type": "string"
    },
    "selector": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Named selector to use",
      "title": "Selector"
    }
  },
  "title": "dbt_runArguments",
  "type": "object"
}

dbt CLI MCP Server

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from dbt CLI MCP Server

Related Tools

MCP directory API