MCP.so
登录

go-mcp-postgres

@guoling2008

代码仓库

关于 go-mcp-postgres

Zero burden, ready-to-use Model Context Protocol (MCP) server for interacting with postgresql and automation with sse / stdio mode and i18n support

#postgres#database#automation

基本信息

分类

数据库

许可证

MIT

运行时

go

传输方式

stdio

发布者

guoling2008

配置

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

{
  "mcpServers": {
    "postgres": {
      "command": "go-mcp-postgres",
      "args": [
        "--dsn",
        "postgresql://user:pass@host:port/db"
      ]
    }
  }
}

工具

未检测到工具

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

概览

What is go-mcp-postgres?

go-mcp-postgres is a lightweight, standalone Model Context Protocol (MCP) server for interacting with PostgreSQL databases. It requires no Node.js or Python runtime and provides tools for CRUD operations, schema management, and read-only queries. It is intended for developers and AI agents who need zero‑burden database automation.

How to use go-mcp-postgres?

Download the latest binary from the releases page or install via go install -v github.com/guoling2008/go-mcp-postgres@latest. Configure it in your MCP client using the --dsn flag for stdio mode, or use --t sse --ip <ip> --port <port> for SSE mode. Optional flags include --read-only (disables write tools) and --with-explain-check (forces EXPLAIN before every query).

Key features of go-mcp-postgres

  • Single binary, no Node.js or Python required
  • Full CRUD operations on PostgreSQL databases and tables
  • Read‑only mode to prevent accidental writes
  • Optional EXPLAIN‑based query plan check
  • Multi‑language support (en/zh‑CN via --lang)
  • Schema tools: list databases, tables, describe, create, alter

Use cases of go-mcp-postgres

  • AI‑assisted database schema exploration and management
  • Automating read‑only data extraction and reporting
  • Safe database administration with read‑only mode enabled
  • Multi‑language environments needing English or Chinese tool descriptions

FAQ from go-mcp-postgres

Does go-mcp-postgres need Node.js or Python?

No. It is a standalone Go binary with no external runtime dependencies.

What is the difference between stdio and SSE modes?

Stdio mode is the default, suitable for local MCP integrations. SSE mode (--t sse) listens on a specified IP and port for remote connections.

How does the EXPLAIN check work?

By default, every write query is preceded by an EXPLAIN statement to verify the query plan matches expected patterns. Use --with-explain-check to disable this behavior.

Can I use go-mcp-postgres in a production environment?

The README notes this is a work in progress and may not yet be ready for production use.

What languages are supported?

Currently English (en) and Chinese (zh‑CN) are built‑in. Custom language files can be added in the locales folder.

评论

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

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

mcp-server-duckdb

ktanaka101

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities

177

Database Gateway

centralmind

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

531

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412