dbt Cloud
Expose dbt Semantic Layer, lineage, CLI, and job control to AI agents.
dbt Cloud
Expose dbt Semantic Layer, lineage, CLI, and job control to AI agents. With Lunar.dev MCPX, the MCP Gateway for secure and governed tool access, you connect the dbt Cloud MCP server to Claude, ChatGPT, Cursor, and any MCP client through one gateway that routes, authenticates, and governs every dbt Cloud tool call against your policies.
Why MCPX
MCPX is Lunar.dev's MCP Gateway. It sits between your AI agents and your MCP servers as a single gateway for every tool call, routing, authenticating, and governing traffic against your policies. Connect dbt Cloud once and govern it everywhere: role-based access per agent with on-behalf-of attribution, real-time visibility, and an immutable audit trail of who did what, all deployable inside your own VPC.
Tools content
- execute_sql · Read-only
Executes SQL on dbt Platform infrastructure with Semantic Layer support. - text_to_sql · Read-only
Generates SQL from natural language using project context. - list_metrics · Read-only
Retrieves all defined metrics. - list_saved_queries · Read-only
Retrieves all saved queries. - get_dimensions · Read-only
Gets dimensions for specified metrics. - get_entities · Read-only
Gets entities for specified metrics. - get_dimension_values · Read-only
Gets distinct values for a dimension; option to scope to specific metrics. - query_metrics · Read-only
Executes metric queries with filtering and grouping options. - get_metrics_compiled_sql · Read-only
Returns compiled SQL for metrics without executing the query. - get_mart_models · Read-only
Retrieves all mart models. - get_all_models · Read-only
Retrieves name and description of all models. - get_model_details · Read-only
Gets model details including compiled SQL, columns, and schema. - get_model_parents · Read-only
Gets upstream dependencies of a model. - get_model_children · Read-only
Gets downstream dependents of a model. - get_model_health · Read-only
Gets health signals: run status, test results, and upstream source freshness. - get_model_performance · Read-only
Gets execution history for a model; option to include test results. - get_lineage · Read-only
Gets full lineage graph (ancestors and descendants) with type and depth filtering. - get_exposures · Read-only
Gets all exposures (downstream dashboards, apps, or analyses). - get_exposure_details · Read-only
Gets exposure details including owner, parents, and freshness status. - get_all_sources · Read-only
Gets all sources with freshness status; option to filter by source name.
Frequently asked questions
What is the dbt Cloud MCP server?
Expose dbt Semantic Layer, lineage, CLI, and job control to AI agents. Through Lunar.dev MCPX, dbt Cloud connects to any MCP-compatible AI client behind a single governed gateway.
How do I connect dbt Cloud to MCPX?
Add the dbt Cloud server in the MCPX control plane or your app.yaml, then point your AI client at your MCPX gateway. MCPX handles Token and routes every dbt Cloud call through the gateway.
Is the dbt Cloud MCP server official?
Yes. dbt Cloud is an official, vendor-published MCP server, and MCPX governs it like any other server in your catalog.
What authentication does dbt Cloud use with MCPX?
dbt Cloud uses Token. MCPX enforces authentication at the gateway with token-based auth, OAuth, and role-based profiles, so you control which agents can invoke it.
How many tools does dbt Cloud expose in MCPX?
dbt Cloud exposes 61 tools. In MCPX you can enable or disable each tool per agent for least-privilege access.
