Hi everyone,
Has anyone tried connecting dbt MCP with n8n?
I’ve seen some discussion in the dbt community, but I couldn’t find n8n-specific documentation. A few things that came up in that thread:
-
n8n’s built-in MCP client currently only supports the deprecated SSE protocol, while dbt MCP requires streamable HTTP.
-
Two possible workarounds mentioned:
-
Use a proxy like supergateway
-
Or use the community custom node for n8n with the remote dbt MCP server.
-
-
Setting the environment variable
N8N_COMMUNITY_PACKAGES_ALLOW_TOOL_USAGE=trueis necessary to get the MCP server working as a tool. -
Headers in n8n flows need to be configured carefully (one per line, with
key=valueformat).
Where I’m stuck right now:
-
I can connect and list tools, but I run into errors when trying to call specific ones like
text_to_sql. It seems n8n isn’t always passing the right payloads to MCP tools by default. -
Some folks suggested manually specifying tool parameters, but that feels brittle.
Has anyone here managed to get dbt MCP tools working smoothly in n8n? In particular, how are you handling tool payloads like text_to_sql?
Would love to hear if others have tried this, or if there’s an easier way to set it up. Thanks in advance!