MCP PostgreSQL 服务器

MCP PostgreSQL 服务器

一个支持 AI 模型与 PostgreSQL 数据库交互的标准化接口服务。

快速入门

安装

手动安装:

npm install mcp-postgres-server

或直接运行:

npx mcp-postgres-server

配置

设置以下环境变量以配置服务器:

{
  "mcpServers": {
    "postgres": {
      "type": "stdio",
      "command": "npx",
      "args": ["-y", "mcp-postgres-server"],
      "env": {
        "PG_HOST": "your_host",
        "PG_PORT": "5432",
        "PG_USER": "your_user",
        "PG_PASSWORD": "your_password",
        "PG_DATABASE": "your_database"
      }
    }
  }
}

使用工具

连接数据库:

use_mcp_tool({
  server_name: "postgres",
  tool_name: "connect_db",
  arguments: {
    host: "localhost",
    port: 5432,
    user: "your_user",
    password: "your_password",
    database: "your_database"
  }
});

执行查询:

use_mcp_tool({
  server_name: "postgres",
  tool_name: "query",
  arguments: {
    sql: "SELECT * FROM users WHERE id = $1",
    params: [1]
  }
});