en es ja ko zh

dbt-mcp

Official

by dbt-labs

Python

Apache 2.0

134

Overview InspectNew Schema Related Servers Reviews Score

Need Help?View Source Code Report Issue

show

Execute SQL queries to debug and inspect data in dbt projects, with an optional limit parameter to control result size.

Instructions

dbt show executes an arbitrary SQL statement against the database and returns the results. It is useful for debugging and inspecting data in your dbt project. Use the limit argument in place of a SQL LIMIT clause

Input Schema

Name	Required	Description	Default
`limit`	No
`sql_query`	Yes

Input Schema (JSON Schema)

{
  "properties": {
    "limit": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Limit"
    },
    "sql_query": {
      "title": "Sql Query",
      "type": "string"
    }
  },
  "required": [
    "sql_query"
  ],
  "title": "showArguments",
  "type": "object"
}

You must be authenticated.

Other Tools from dbt-mcp

Related Tools

test
@dbt-labs/dbt-mcp
list
@dbt-labs/dbt-mcp
list_metrics
@dbt-labs/dbt-mcp
get_model_details
@dbt-labs/dbt-mcp
get_all_models
@dbt-labs/dbt-mcp

ID: 4g56yk3tar