I have the same need.
IS there a way to add the option to set STDIO configuration tu execute locally some MCP servers like it is the case with the MCP Client node from this repo: GitHub - nerding-io/n8n-nodes-mcp: n8n custom node for MCP ?
It took most of the night and some heavy back and forth with Cursor to learn how to do this, but I now have an MCP installed locally on my digital droplet server using the SSE endpoint. Man, I am so grateful you posted this little workflow, thank you so much.
edit: I just figured out how to get the MCP working with the new HTTP streamable method. Supergateway is such a cool find.