LangChain sheetsdata mcp Prompt/second-source
How to: LangChain sheetsdata mcp second-source
Add sheetsdata mcp to LangChain
-
01
Open pip install langchain-mcp-adapters and merge this in. Keep any servers already there.
from langchain_mcp_adapters.client import MultiServerMCPClient
client = MultiServerMCPClient({
"sheetsdata-mcp": {
"transport": "streamable_http",
"url": "https://mcp.sheetsdata.com/mcp",
}
})
tools = await client.get_tools()
-
02
Save the file and restart LangChain.
-
03
second-source is surfaced through the client's prompt API, fetched by name. Unlike a tool, you invoke it deliberately — LangChain will not call it for you.
-
04
If it does not appear, check that sheetsdata mcp is connected and that you are looking at its prompts rather than its tools.
get_tools() returns the server's tools as LangChain tools, ready for an agent. LangChain docs
Set these first
sheetsdata mcp will not start until these are set, so it never reaches LangChain.
-
SHEETSDATA_API_KEY
Same prompt, other clients
Read from the server itself, by connecting to it and calling prompts/list on 24 September 2026.
A listing does not declare its prompts, so asking is the only way to know them, and this
is what the server actually offers rather than what its listing claims. Names only are
stored; connect the server for each prompt's arguments.