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.
安全与权限
0 个平台
0 项功能
安装
uvx kenning-pg-mcp
把上面的配置写入 MCP 客户端的配置文件(Claude Desktop 为 claude_desktop_config.json),重启客户端后生效。
{
"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>"
}
}
}
}把上面的配置写入 MCP 客户端的配置文件(Claude Desktop 为 claude_desktop_config.json),重启客户端后生效。
数据来源:公开的 MCP Server 目录。本站为独立第三方目录,与各 MCP Server 维护方均无隶属或背书关系;名称与简介如实标注,介绍文案由本站再加工。