Skip to content
LangChain

PostgreSQL for LangChain

io.github.antonorlov/mcp-postgres-server

MCP server for PostgreSQL: local, Docker, RDS, Neon, Supabase, or behind an SSH bastion.

client:LangChain transport:stdio runtime:npm

Install PostgreSQL in LangChain

pip install langchain-mcp-adapters

from langchain_mcp_adapters.client import MultiServerMCPClient

client = MultiServerMCPClient({
        "mcp-postgres-server": {
            "transport": "stdio",
            "command": "npx",
            "args": ["-y", "mcp-postgres-server"],
        }
})

tools = await client.get_tools()

get_tools() returns the server's tools as LangChain tools, ready for an agent. LangChain docs

PostgreSQL in other clients