Submit
mgcrea

mcp-postgres

Community mgcrea
Updated

MCP tool server providing PostgreSQL database access for AI agents.

mcp-postgres

MCP tool server providing PostgreSQL database access for AI agents.

Tools

Tool Description
postgres_query Execute SQL queries (read-only by default)
postgres_list_tables List all tables in a schema
postgres_describe_table Get table structure (columns, types, constraints)

Quick Start

cp .env.example .env
# Edit .env with your Postgres connection details
make install
make server

Environment Variables

Variable Default Description
POSTGRES_HOST localhost PostgreSQL host
POSTGRES_PORT 5432 PostgreSQL port
POSTGRES_USER postgres Database user
POSTGRES_PASSWORD Database password
POSTGRES_DB postgres Database name
POSTGRES_READONLY true Enforce read-only queries
MCP_TRANSPORT http Transport: http, stdio
MCP_PORT 8080 Server port (http only)

Set POSTGRES_READONLY=false to enable read/write mode (INSERT, UPDATE, DELETE, etc.).

Endpoints

Path Method Description
/healthz GET Health check for K8s probes
/ GET Server info (name, version, transports)
/mcp POST MCP Streamable-HTTP transport
/sse GET MCP SSE transport (legacy)

Usage with .mcp.json

{
  "mcpServers": {
    "postgres": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run", "--rm", "-i",
        "-e", "MCP_TRANSPORT=stdio",
        "-e", "POSTGRES_HOST=host.docker.internal",
        "-e", "POSTGRES_PORT=5432",
        "-e", "POSTGRES_USER=postgres",
        "-e", "POSTGRES_PASSWORD=secret",
        "-e", "POSTGRES_DB=mydb",
        "ghcr.io/mgcrea/mcp-postgres"
      ]
    }
  }
}

Use host.docker.internal to connect to a PostgreSQL instance running on the host machine.

Docker

make docker-build
make docker-run

MCP Server · Populars

MCP Server · New