Enables natural language querying of PostgreSQL databases, converting natural language to SQL, executing queries, and providing schema introspection and safety validation.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@pg-mcp show me the total sales per product for the last quarter"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
基于自然语言的 PostgreSQL 查询 MCP 服务。接入 DeepSeek 大模型，自动将自然语言转化为 SQL 并执行。
pip install -e .复制 .env.example 为 .env，填写以下必填项：
PG_MCP_DEEPSEEK_API_KEY=sk-your-key
PG_MCP_DATABASES='[{"name":"mydb","dsn":"postgresql://user:pass@localhost:5432/mydb","default":true}]'或单库模式：
PG_MCP_DEEPSEEK_API_KEY=sk-your-key
PG_MCP_DATABASE_URL=postgresql://user:pass@localhost:5432/mydbpg-mcp或
python -m pg_mcp.serverRelated MCP server: nl2sql-mcp
Tool | 功能 |
| 自然语言 → SQL / 查询结果（核心） |
| 自然语言解释 SQL 功能 |
| 手动刷新数据库 Schema 缓存 |
| 列出所有可访问数据库 |
在 mcp.json 中添加：
{
"mcpServers": {
"pg-mcp": {
"command": "python",
"args": ["-m", "pg_mcp.server"],
"env": {
"PG_MCP_DEEPSEEK_API_KEY": "${DEEPSEEK_API_KEY}",
"PG_MCP_DATABASES": "[{\"name\":\"mydb\",\"dsn\":\"postgresql://user:pass@localhost:5432/mydb\",\"default\":true}]"
}
}
}
}三重防线：
sqlglot AST 分析 — 自动拦截 DDL/DML/DCL 及危险表引用
正则兜底 — 处理解析器无法识别的边界情况
数据库只读用户 — 从数据库层面杜绝写入
Fail-Closed 原则：任何 SQL 解析失败、异常 → 一律拒绝执行，绝不默认放行。
# 安装开发依赖
pip install -e ".[dev]"
# 运行测试
pytest tests/ -v
pytest tests/test_sql_validator.py -v # 安全校验（最重要）
# 跳过集成测试
pytest -m "not integration" -vFastMCP 3.4.x — MCP Server 框架
asyncpg — PostgreSQL 异步驱动
sqlglot — SQL 解析与安全校验
DeepSeek (openai SDK) — LLM 生成 SQL
pydantic-settings — 配置管理
structlog — 结构化日志
This server cannot be deployed
GibsonAI MCP server: manage your databases with natural language
Query PostgreSQL databases in plain English — LLM-generated, safety-validated SQL.
Analytical memory for AI agents: a real Postgres queried in plain English over MCP. One command.
