Advertise
MCP.so
Sign In

Go MCP Postgres

@guoling2008

Repository

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

guoling2008

About 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

Go MCP Postgres config

Add this server to your MCP-compatible client using the configuration below.

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

Go MCP Postgres tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

1

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

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

2

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.

3

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.

4

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.

5

What languages are supported?

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

Comments

More Databases MCP servers

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

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

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

Elasticsearch MCP Server

elastic

685

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Advertise