Skip to main content
Glama
madhurprash

postgres-mcp-server

by madhurprash
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python

postgres-mcp-server

A Postgres MCP server built for AWS Bedrock AgentCore Runtime.

AgentCore Protocol Compliance

  • Transport: Stateless streamable-http (stateless_http=True)

  • Port: 8000 on 0.0.0.0

  • Path: POST /mcp

  • Platform: ARM64 container

  • Framework: Python FastMCP

Related MCP server: PostgreSQL MCP Server

Tools

Tool

Description

query

Execute read-only SQL queries (runs in READ ONLY transaction)

list_tables

List tables in a schema with row counts and sizes

describe_table

Column details, constraints, and indexes for a table

list_schemas

List all non-system database schemas

explain_query

Get EXPLAIN plan for a query (optionally with ANALYZE)

get_table_stats

Row counts, sizes, scan stats, vacuum info

get_slow_queries

Top slow queries from pg_stat_statements

Environment Variables

Variable

Required

Description

POSTGRES_URL

Yes*

PostgreSQL connection string

DATABASE_URI

Yes*

Alternative name for connection string

*One of POSTGRES_URL or DATABASE_URI is required.

Security

  • All queries execute inside READ ONLY transactions

  • Point POSTGRES_URL at a read replica for hard DB-level enforcement

  • Use a Postgres user with SELECT-only grants for defense in depth

Local Development

# Run directly
POSTGRES_URL="postgresql://user:pass@localhost:5432/mydb" python server.py

# Run with Docker
docker build -t postgres-mcp .
docker run -e POSTGRES_URL="postgresql://user:pass@host:5432/mydb" -p 8000:8000 postgres-mcp

Deploy to AgentCore

# Build for ARM64
docker buildx build --platform linux/arm64 -t <ecr-uri>/pgmcp:latest --push .

# Create runtime
aws bedrock-agentcore-control create-agent-runtime \
  --agent-runtime-name "mcp_postgres" \
  --agent-runtime-artifact '{"containerConfiguration":{"containerUri":"<ecr-uri>/pgmcp:latest"}}' \
  --protocol-configuration '{"serverProtocol":"MCP"}' \
  --environment-variables '{"POSTGRES_URL":"postgresql://...","PORT":"8000"}' \
  --network-configuration '{"networkMode":"VPC","networkModeConfig":{"securityGroups":["sg-xxx"],"subnets":["subnet-xxx"]}}' \
  --role-arn "arn:aws:iam::xxx:role/agentcore-execution"

Test

# Health check (via MCP initialize)
curl -X POST http://localhost:8000/mcp \
  -H "Content-Type: application/json" \
  -H "Accept: application/json, text/event-stream" \
  -d '{"jsonrpc":"2.0","id":1,"method":"initialize","params":{"protocolVersion":"2025-03-26","capabilities":{},"clientInfo":{"name":"test","version":"1.0"}}}'

# List tools
curl -X POST http://localhost:8000/mcp \
  -H "Content-Type: application/json" \
  -H "Accept: application/json, text/event-stream" \
  -d '{"jsonrpc":"2.0","id":2,"method":"tools/list"}'

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • PostgreSQL

    modelcontextprotocol
    -
    license
    Not graded
    quality
    A
    maintenance
    A Model Context Protocol server that provides read-only access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
    78,432 npm
    90,196
    MIT

  • PostgreSQL MCP Server

    hthuong09
    A
    license
    Not graded
    quality
    C
    maintenance
    A Model Context Protocol server that enables interaction with PostgreSQL databases to list tables, retrieve schemas, and execute read-only SQL queries.
    7 npm
    MIT

  • PostgreSQL MCP Server

    abdou-ghonim
    A
    license
    Not graded
    quality
    D
    maintenance
    A Model Context Protocol server that provides AI assistants with secure, read-only access to PostgreSQL databases while offering comprehensive tools for schema exploration, query validation, and performance optimization.
    MIT