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"
}