LangChain Supabase execute_sql
How to: LangChain Supabase execute_sql
Add Supabase 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({
"mcp-server-supabase": {
"transport": "stdio",
"command": "npx",
"args": ["-y", "@supabase/mcp-server-supabase"],
}
})
tools = await client.get_tools()
-
02
Save the file and restart LangChain.
-
03
Ask for something execute_sql does. LangChain lists the server's tools on connect and calls execute_sql itself — you do not invoke it by name.
-
04
If nothing happens, check the server is running and that Supabase's identifier in your config matches the one above exactly.
get_tools() returns the server's tools as LangChain tools, ready for an agent. LangChain docs
Set these first
Supabase will not start until these are set, so execute_sql never becomes available.
-
SUPABASE_ACCESS_TOKEN
Same tool, other clients
Mutating and Read-only are read off each tool's name, not its schema — a hint, not a guarantee. The registry stores tool names only; connect the server for its live schemas.