Langgraph-MCP Client for Postgresql Example

@BrianCusack

代码仓库

基本信息

分类

推理

传输方式

stdio

作者

BrianCusack

关于 Langgraph-MCP Client for Postgresql Example

LangGraph implementation interacting with a PostgreSQL MCP Server

Langgraph-MCP Client for Postgresql Example 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "LangGraph-MCP-Client": {
      "command": "uv",
      "args": [
        "sync"
      ]
    }
  }
}

Langgraph-MCP Client for Postgresql Example 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Langgraph-MCP Client for Postgresql Example?

This repository demonstrates a low-level example of how to interact with an MCP server as a Docker image, connected to a PostgreSQL database for LangGraph agents. It is intended for developers who want to integrate PostgreSQL data sources with LangGraph using the Model Context Protocol (MCP).

How to use Langgraph-MCP Client for Postgresql Example?

Clone the repository, create a .env file with database credentials (DB_HOST, DB_PORT, DB_USER, DB_PASSWORD, DB_NAME), install the UV package globally, and build the MCP Postgres Docker image. Then run uv sync followed by uv run queryagent to start the query agent, optionally passing a natural language query as an argument (e.g., uv run queryagent "Who holds the most funds in their account?").

Key features of Langgraph-MCP Client for Postgresql Example

Connects to a PostgreSQL database via an MCP server.
Uses langchain_mcp_adapters.tools.load_mcp_tools to create MCP tools.
Employs LangGraph's create_react_agent for fast agent templating.
Outputs the agent’s stream to a file.
Accepts user queries via command line.

Use cases of Langgraph-MCP Client for Postgresql Example

Querying a banking database using natural language questions.
Learning how to integrate a PostgreSQL MCP server with LangGraph agents.
Prototyping a LangGraph agent that uses database tools over MCP.

常见问题

What are the prerequisites for running this project?

You need Docker, a running PostgreSQL database, and the MCP Servers repository (to build the Postgres MCP image). The UV package manager must also be installed globally.

How do I set up the database connection?

Create a `.env` file in the repository root with the variables `DB_HOST`, `DB_PORT`, `DB_USER`, `DB_PASSWORD`, and `DB_NAME`, replacing placeholders with your actual credentials.

What should I do if I encounter UV package errors?

Ensure the UV CLI is installed globally and that the `uv sync` command completes without errors.

How do I build the PostgreSQL MCP Server Docker image?

Clone the MCP Servers repository, navigate to its directory, and run `docker build -t mcp/postgres -f src/postgres/Dockerfile .`

How can I run the query agent with a specific question?

Run `uv run queryagent "your question"` from the project directory, replacing `"your question"` with the desired natural language query.

推理分类下的更多 MCP 服务器

MCP Sandbox

JohanLi233

Python sandboxes for llms

Code Reasoning MCP Server

mettamatt

A code reasoning MCP server, a fork of sequential-thinking

255

n8n Workflow Builder MCP Server

makafeli

AI assistant integration for n8n workflow automation through Model Context Protocol (MCP). Connect Claude Desktop, ChatGPT, and other AI assistants to n8n for natural language workflow management.

530

Agentic Tools MCP Server

Pimzino

A comprehensive Model Context Protocol (MCP) server providing AI assistants with powerful task management and agent memories capabilities with project-specific storage.

MCP Servers

junfanz1

This project demonstrates a decoupled real-time agent architecture that connects LangGraph agents to remote tools served by custom MCP (Modular Command Protocol) servers. The architecture enables a flexible and scalable multi-agent system where each tool can be hosted independent