A PostgreSQL MCP (Model Context Protocol) server built in Go.
This server provides a safe interface for querying PostgreSQL databases with read-only access.

It exposes MCP tools for:

• Listing tables
• Describing tables
• Executing safe SELECT or WITH queries

Write operations (INSERT, UPDATE, DELETE, DROP, etc.) are blocked by default.

• Safe query execution (only SELECT and WITH queries allowed)
• Protection against destructive SQL (DROP, DELETE, TRUNCATE, ALTER, etc.)
• Schema discovery when queries fail
• Two transport modes:
  • stdio (default) for CLI/agent integration
  • http for HTTP-based usage
• Docker-ready

git clone https://github.com/root27/pg-mcp.git
cd pg-mcp
go build -o pg-mcp

Database connection is configured using environment variables:

Example:

export DB_HOST=localhost
export DB_PORT=5432
export DB_USER=postgres
export DB_PASSWORD=secret
export DB_NAME=mydb
export DB_SSLMODE=disable

This is the default mode. It runs over stdio, which is useful for direct MCP integrations (e.g., when an agent launches the server as a subprocess).

./pg-mcp

You can also run the server over HTTP, which is useful if you want to expose it as a service.

./pg-mcp -t http

# or

./pg-mcp --transport http

The server will listen on

http://localhost:8080/mcp

You can pull the images for arm64 and amd64

docker pull ghcr.io/root27/pg-mcp:arm64

docker run -it  \
  -e DB_HOST=host.docker.internal \
  -e DB_PORT=5432 \
  -e DB_USER=postgres \
  -e DB_PASSWORD=secret \
  -e DB_NAME=mydb \
  -e DB_SSLMODE=disable \
  -p 8080:8080 \
  ghcr.io/root27/pg-mcp:arm64 --transport http

docker pull ghcr.io/root27/pg-mcp:amd64

docker run -it  \
  -e DB_HOST=host.docker.internal \
  -e DB_PORT=5432 \
  -e DB_USER=postgres \
  -e DB_PASSWORD=secret \
  -e DB_NAME=mydb \
  -e DB_SSLMODE=disable \
  -p 8080:8080 \
  ghcr.io/root27/pg-mcp:amd64 --transport http

The server is accessible at http://localhost:8080/mcp