dbt_show

Preview transformation results from a specific dbt model without materializing it. Use this tool to inspect data, debug issues, or demonstrate processed data outputs in JSON or other formats, avoiding changes to the target database.

Instructions

Preview the results of a model. An AI agent should use this tool when it needs to preview data from a specific model without materializing it. This helps inspect transformation results, debug issues, or demonstrate how data looks after processing without modifying the target database.

    Returns:
        Output from the dbt show command, defaulting to JSON format if not specified
    

Input Schema

Name	Required	Description	Default
`limit`	No	Limit the number of rows returned
`models`	Yes	Specific model to show. For model references, use standard dbt syntax like 'model_name'. For inline SQL, use the format 'select * from {{ ref("model_name") }}' to reference other models.
`output`	No	Output format (json, table, etc.)	json
`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 '.')	.

Input Schema (JSON Schema)

{
  "properties": {
    "limit": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Limit the number of rows returned",
      "title": "Limit"
    },
    "models": {
      "description": "Specific model to show. For model references, use standard dbt syntax like 'model_name'. For inline SQL, use the format 'select * from {{ ref(\"model_name\") }}' to reference other models.",
      "title": "Models",
      "type": "string"
    },
    "output": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": "json",
      "description": "Output format (json, table, etc.)",
      "title": "Output"
    },
    "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"
    }
  },
  "required": [
    "models"
  ],
  "title": "dbt_showArguments",
  "type": "object"
}

dbt CLI MCP Server

dbt_show

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from dbt CLI MCP Server

Related Tools

MCP directory API