dbt_show

Preview data transformation results from a specific dbt model without materializing it. Use this tool to inspect, debug, or demonstrate processed data in JSON or other formats. Ideal for AI-driven analysis and verification.

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