dbt_test

Validate data quality and integrity by running tests in a dbt project. Ensures data transformations meet business rules and constraints for accurate analysis and reporting.

Instructions

Run dbt tests. An AI agent should use this tool when it needs to validate data quality and integrity by running tests defined in a dbt project. This helps ensure that data transformations meet expected business rules and constraints before being used for analysis or reporting.

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

Input Schema

Name	Required	Description	Default
`exclude`	No	Models to exclude
`models`	No	Specific models to test, using the dbt selection syntax
`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"
    },
    "models": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Specific models to test, using the dbt selection syntax",
      "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_testArguments",
  "type": "object"
}

dbt CLI MCP Server

dbt_test

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from dbt CLI MCP Server

Related Tools

MCP directory API