d
dbt
Run dbt models, tests and view manifest metadata.
·No reviews yet
Share:
About
Auto-generated
dbt is a Model Context Protocol server in the Data & Databases category. It lets AI assistants that speak MCP call its tools and read its resources over STDIO.
Example tools
Illustrative tool names — the actual tool set is defined by the server at runtime.
query
Run a read-only SQL query
list_tables
List tables in the connected database
describe_table
Return column info for a table
Screenshots
No screenshots yet.
Frequently Asked Questions
Common questions about dbt.
- What is the primary function of the dbt MCP?
- The dbt MCP allows users to run dbt models and tests. It also provides access to manifest metadata related to your dbt projects. This facilitates integration of dbt operations within an MCP-compatible environment.
- How can I install the dbt MCP using a client like Cursor?
- Installation typically involves adding the dbt MCP using your client's extension or plugin manager. Refer to your specific MCP client's documentation for the exact steps to add a new MCP from a community provider, often by specifying its repository URL.
- Does the dbt MCP require an API key or other credentials?
- No, the dbt MCP itself does not require an API key or other credentials for operation as its authentication type is listed as 'none'. Any credentials required would be for accessing your underlying data warehouse.
- What specific functionalities does this dbt MCP expose?
- This MCP exposes the ability to execute dbt models and run dbt tests. It also provides access to dbt manifest metadata, useful for understanding your dbt project's structure and lineage.
- Is there any cost associated with using the dbt MCP?
- The dbt MCP itself is provided by the community, implying it is open source and generally free to use. However, the cost of running dbt models will depend on your chosen underlying data warehouse and its pricing model.
- What is a common limitation or prerequisite for using the dbt MCP effectively?
- A key prerequisite for effective use is having an existing dbt project and a correctly configured dbt profile that connects to your data warehouse. The MCP assumes dbt is set up to interact with your data environment.
Install dbt
Claude Desktop
Add this to claude_desktop_config.json.
{
"mcpServers": {
"dbt": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-dbt"
]
}
}
}Cursor
Add this to ~/.cursor/mcp.json.
{
"mcpServers": {
"dbt": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-dbt"
]
}
}
}VS Code
Add this to your workspace settings.json.
{
"mcp.servers": {
"dbt": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-dbt"
]
}
}
}Reviews
Sign in to leave a review.
No reviews yet. Be the first!
Discussion(0)
No comments yet.