Skip to main content
Glama
Sign In
mcp-postgres

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

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    This server cannot be deployed

    Claude Code, inside the Godot 4 editorFlockbay puts an AI agent in the real Godot 4 editor: it writes GDScript, runs your game and fixes what breaks. Free, or bring your own Claude Code or Codex.flockbay.comAd

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community 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
      D
      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