广告合作
MCP.so
登录

PostgreSQL MCP Server

@leixiaotian1

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

leixiaotian1

关于 PostgreSQL MCP Server

一款用golang实现的操作pg数据库的mcp server，支持创建表、查询表、插入数据，查看数据，分析sql语句等功能，欢迎共建！！！

PostgreSQL MCP Server 配置

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

{
  "mcpServers": {
    "pgsql-mcp-server": {
      "command": "docker",
      "args": [
        "network",
        "create",
        "sql-mcp-network"
      ]
    }
  }
}

PostgreSQL MCP Server 工具

工具列表暂未提供

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

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

概览

What is PostgreSQL MCP Server?

PostgreSQL MCP Server is a Model Context Protocol server that provides tools for AI assistants to interact with a PostgreSQL database. It enables executing SQL queries, explaining statements, creating tables, and listing tables via the MCP protocol.

How to use PostgreSQL MCP Server?

Clone the repository, install dependencies with go mod download, and build with go build -o pgsql-mcp-server. Configure database connection via environment variables in a .env file (e.g., DB_HOST, DB_PORT, DB_NAME, DB_USER, DB_PASSWORD, DB_SSLMODE, SERVER_MODE). Run the server with ./pgsql-mcp-server or configure it in your MCP client’s JSON settings.

Key features of PostgreSQL MCP Server

  • Interact with PostgreSQL databases through AI assistants.
  • Separate read and write operations for security (read_query, write_query).
  • Create tables and list existing tables (create_table, list_tables).
  • Analyze query execution plans (explain_query).
  • Supports multiple transport modes: stdio, SSE, and streamableHttp.
  • Environment-based configuration via .env file.

Use cases of PostgreSQL MCP Server

  • Let an AI assistant query and analyze PostgreSQL data.
  • Allow AI to create database tables based on user requests.
  • Enable AI to review query execution plans for optimization.
  • Manage database schemas through natural language prompts.

常见问题

1

What dependencies are required?

Go 1.23 or later and a running PostgreSQL database server are required.

2

How do I configure the database connection?

Set environment variables in a `.env` file: `DB_HOST`, `DB_PORT`, `DB_NAME`, `DB_USER`, `DB_PASSWORD`, `DB_SSLMODE`, and optionally `SERVER_MODE`. These can also be passed directly in the MCP client’s configuration JSON.

3

What transport modes does the server support?

Three modes are supported: `stdio` (default), `sse` (Server-Sent Events over HTTP), and `streamableHttp`. Select the mode by setting the `SERVER_MODE` environment variable.

4

How are read and write operations separated?

The server exposes distinct tools: `read_query` for SELECT queries, `write_query` for INSERT/UPDATE/DELETE, and `create_table` for CREATE TABLE statements. This allows clients to authorize each operation type separately.

5

Is there a Docker deployment guide?

Yes, the README includes a detailed Docker deployment guide with steps to create a shared network, start a PostgreSQL container, and build/run the application container using the provided `Makefile`.

评论

数据库 分类下的更多 MCP 服务器

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531
广告合作