postgres-mcp-server
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
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.0Path:
POST /mcpPlatform: ARM64 container
Framework: Python FastMCP
Related MCP server: PostgreSQL MCP Server
Tools
Tool | Description |
| Execute read-only SQL queries (runs in |
| List tables in a schema with row counts and sizes |
| Column details, constraints, and indexes for a table |
| List all non-system database schemas |
| Get EXPLAIN plan for a query (optionally with ANALYZE) |
| Row counts, sizes, scan stats, vacuum info |
| Top slow queries from pg_stat_statements |
Environment Variables
Variable | Required | Description |
| Yes* | PostgreSQL connection string |
| Yes* | Alternative name for connection string |
*One of POSTGRES_URL or DATABASE_URI is required.
Security
All queries execute inside
READ ONLYtransactionsPoint
POSTGRES_URLat a read replica for hard DB-level enforcementUse 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-mcpDeploy 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"}'Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
Related MCP Connectors
Hosted PostgreSQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
Query PostgreSQL databases in plain English — LLM-generated, safety-validated SQL.
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
Related MCP Servers
- -licenseNot gradedqualityBmaintenanceA 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.139,311 npm91,952MIT
- AlicenseNot gradedqualityDmaintenanceA Model Context Protocol server providing LLMs read-only access to PostgreSQL databases for inspecting schemas and executing queries.139,311 npm27MIT
- AlicenseNot gradedqualityDmaintenanceA Model Context Protocol server that enables interaction with PostgreSQL databases to list tables, retrieve schemas, and execute read-only SQL queries.11 npmMIT
- AlicenseNot gradedqualityDmaintenanceA 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