Loading...
{
"mcpServers": {
"dbt-mcp": {
"command": "uvx",
"args": [
"--env-file",
"<path-to-.env-file>",
"dbt-mcp"
]
},
}
}execute_sqlExecutes SQL queries on dbt Platform infrastructure, leveraging Semantic Layer support.
Direct SQL execution can modify or expose sensitive data.
text_to_sqlGenerates SQL from natural language, using the dbt project context for assistance.
Poorly generated SQL could lead to inefficient queries or unintended data access.
get_model_detailsRetrieves detailed information about a specific dbt model, including compiled SQL and column definitions.
Read-only access to model metadata.
buildExecutes dbt models, tests, snapshots, and seeds in the order defined by the DAG.
Can modify data and project state.
trigger_job_runTriggers a dbt Cloud job run, with options to override settings like git branch and schema.
Can trigger unintended or malicious job executions.
generate_model_yamlGenerates model YAML files with column definitions, optionally inheriting descriptions from upstream models.
Modifies dbt project structure.
get_mcp_server_versionReturns the current version of the dbt MCP server.
Provides version information only.
The dbt MCP server offers powerful capabilities, but requires careful configuration and monitoring. Read-only tools are generally safe, while tools that modify data or execute code should be used with caution. Proper access controls and monitoring are essential to mitigate risks.