PostgreSQL MCP Server

Example Use Cases

• 1

  Safe, read-only access to PostgreSQL databases via MCP protocol.

• 2

  Integrate PostgreSQL querying capabilities over stdio or HTTP transports.

• 3

  That require protection against destructive SQL commands while querying.

Description

pg-mcp is a PostgreSQL MCP server implemented in Go that allows safe querying of PostgreSQL databases with read-only permissions. It supports listing and describing tables, and executing only safe SELECT or WITH queries, blocking all write operations. The server can run in stdio mode for CLI/agent integration or HTTP mode for service exposure, and is available as Docker images for arm64 and amd64 architectures.