fvanevski/postgres_mcpA Python MCP 2.0 server for self-hosted PostgreSQL instances, providing schema/relation discovery, SQL query and controlled transactional execution tools with security features like read-only transactions, role hardening guidance, and optional human approval for write commands.
DATABASE_URLstringREQUIREDMCP_PG_ENV_FILEstringOPTIONALMCP_PG_LOG_LEVELstringOPTIONALdefault: INFOMCP_PG_TRANSPORTstringOPTIONALdefault: stdioMCP_PG_POOL_MAX_SIZEstringOPTIONALdefault: 5MCP_PG_POOL_MIN_SIZEstringOPTIONALdefault: 1MCP_PG_APPLICATION_NAMEstringOPTIONALdefault: mcp-postgres-serverMCP_PG_ALLOW_WRITE_COMMANDSstringOPTIONALdefault: falseMCP_PG_CONFIRM_WRITE_COMMANDSstringOPTIONALdefault: trueMCP_PG_POOL_OPEN_TIMEOUT_SECONDSstringOPTIONALdefault: 20MCP_PG_POOL_ACQUIRE_TIMEOUT_SECONDSstringOPTIONALdefault: 10Create a free RNWY account to connect your on-chain identity to this server. MCP server claiming is coming; register now and you'll be first in line.
Create your account →