Skip to main content
Glama
mgcrea

mcp-postgres

by mgcrea
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Remote

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)

Related MCP server: PostgreSQL MCP Server

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

This server cannot be deployed

RayrunBuild, deploy, and operate MCP servers without becoming an infrastructure team.ray.runAd

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • PostgreSQL MCP Server

    KannaKim
    F
    license
    A
    quality
    D
    maintenance
    Enables AI agents to inspect and query PostgreSQL databases safely, with features like listing tables, retrieving schemas, and running read-only SQL queries.
    3
    -

  • postgresdb-mcp

    nayzo
    A
    license
    Not graded
    quality
    C
    maintenance
    Enables AI assistants to interact with PostgreSQL databases, providing tools for querying, table listing, schema exploration, and multi-environment management with write protection and schema scoping.
    1
    MIT