Skip to main content
Glama
mgcrea

mcp-postgres

by mgcrea
OverviewSchemaRelated ServersScoreDiscussions
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 installed

A
license - permissive license
-
quality - not tested
D
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

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.
    Last updated
    3

  • postgresdb-mcp

    nayzo
    A
    license
    -
    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.
    Last updated
    1
    MIT

View all related MCP servers

Related MCP Connectors

View all MCP Connectors

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/mgcrea/mcp-postgres'

If you have feedback or need assistance with the MCP directory API, please join our Discord server