Kenning PG MCP
A secure PostgreSQL Model Context Protocol server that provides read-only database access through tools like schema listing, object inspection, query execution, and EXPLAIN analysis, with database-enforced access control via read-only transactions and a minimal role rather than SQL text parsing.
Security & IAM
0 platforms
0 features
Install
uvx kenning-pg-mcp
Paste the configuration above into your MCP client config (claude_desktop_config.json for Claude Desktop) and restart the client.
{
"mcpServers": {
"kenning-pg-mcp": {
"command": "uvx",
"args": [
"kenning-pg-mcp"
],
"env": {
"PG_MCP_HOST": "<PG_MCP_HOST>",
"PG_MCP_PORT": "<PG_MCP_PORT>",
"DATABASE_URI": "<DATABASE_URI>",
"PG_MCP_SCHEMAS": "<PG_MCP_SCHEMAS>",
"PG_MCP_MAX_ROWS": "<PG_MCP_MAX_ROWS>",
"PG_MCP_POOL_MAX": "<PG_MCP_POOL_MAX>",
"PG_MCP_POOL_MIN": "<PG_MCP_POOL_MIN>",
"PG_MCP_LOG_LEVEL": "<PG_MCP_LOG_LEVEL>"
}
}
}
}Paste the configuration above into your MCP client config (claude_desktop_config.json for Claude Desktop) and restart the client.
Sources: public MCP Server directories. This is an independent third-party directory with no affiliation to or endorsement from the maintainers of the listed servers.
