devopam/MCPg

Overview

devopam/MCPg is a Python-based Model Context Protocol (MCP) server that exposes a PostgreSQL database to MCP-compatible clients. It allows AI agents to query and interact with Postgres through a standardized interface.

Best for

Best for
Developers experimenting with MCP and needing a quick Postgres integration for AI agents

Use cases

• Let an AI assistant run SQL queries against a Postgres database
• Enable natural language database exploration via MCP clients
• Automate database reporting or data retrieval tasks

How to use

Install

pip install mcpg

Tools exposed

• MCPG_DATABASE_URL
• MCPG_ACCESS_MODE
• MCPG_TRANSPORT
• MCPG_LOG_LEVEL
• MCPG_HTTP_HOST
• MCPG_HTTP_PORT
• MCPG_ALLOW_DDL
• MCPG_ALLOW_SHELL
• MCPG_ALLOW_LISTEN
• MCPG_AUTH_MODE
• MCPG_HTTP_AUTH_TOKEN
• MCPG_OIDC_ISSUER
• MCPG_OIDC_AUDIENCE
• MCPG_OIDC_JWKS_URL
• MCPG_OIDC_ROLE_CLAIM
• MCPG_HTTP_MAX_BODY_BYTES
• MCPG_HTTP_ALLOWED_ORIGINS
• MCPG_HTTP_HSTS_MAX_AGE
• MCPG_HTTP_REQUEST_TIMEOUT_SECONDS
• MCPG_DEFAULT_ROLE

Tested with

Claude Desktop, Cursor, Windsurf, Cline, Continue, VS Code, ChatGPT

Notes

devopam/MCPg is a Python-based Model Context Protocol (MCP) server that exposes a PostgreSQL database to MCP-compatible clients. It allows AI agents to query and interact with Postgres through a standardized interface.

7 stars on GitHub. Last updated 2026-07-13. Licensed MIT.

Use cases

• Let an AI assistant run SQL queries against a Postgres database
• Enable natural language database exploration via MCP clients
• Automate database reporting or data retrieval tasks

Pros

• Simple, focused implementation for Postgres
• Leverages the MCP standard for interoperability
• Lightweight Python codebase easy to customize

Cons

• Very early stage with only 7 GitHub stars
• Limited documentation and community support
• No built-in authentication or access controls

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.