Sezzlee PostgreSQL

Name: Sezzlee PostgreSQL
Author: sezzlee

sezzlee

开始使用源码仓库官网与文档

Explore and query PostgreSQL read-only: catalogue search, schema introspection and bounded queries.

接入配置

选择客户端，复制配置，再按项目文档补齐环境变量。

一键添加到 Cursor 一键添加到 VS Code

claude mcp add sezzlee-postgresql --env SEZZLEE_POSTGRES_SERVER='<SEZZLEE_POSTGRES_SERVER>' --env SEZZLEE_POSTGRES_DATABASE='<SEZZLEE_POSTGRES_DATABASE>' --env SEZZLEE_POSTGRES_USER='<SEZZLEE_POSTGRES_USER>' --env SEZZLEE_POSTGRES_PASSWORD='<SEZZLEE_POSTGRES_PASSWORD>' -- npx -y @sezzlee/postgres-mcp

~/.codex/config.toml

[mcp_servers.sezzlee-postgresql]
command = "npx"
args = ["-y", "@sezzlee/postgres-mcp"]
env = { SEZZLEE_POSTGRES_SERVER = "<SEZZLEE_POSTGRES_SERVER>", SEZZLEE_POSTGRES_DATABASE = "<SEZZLEE_POSTGRES_DATABASE>", SEZZLEE_POSTGRES_USER = "<SEZZLEE_POSTGRES_USER>", SEZZLEE_POSTGRES_PASSWORD = "<SEZZLEE_POSTGRES_PASSWORD>" }

# codex mcp add sezzlee-postgresql --env SEZZLEE_POSTGRES_SERVER='<SEZZLEE_POSTGRES_SERVER>' --env SEZZLEE_POSTGRES_DATABASE='<SEZZLEE_POSTGRES_DATABASE>' --env SEZZLEE_POSTGRES_USER='<SEZZLEE_POSTGRES_USER>' --env SEZZLEE_POSTGRES_PASSWORD='<SEZZLEE_POSTGRES_PASSWORD>' -- npx -y @sezzlee/postgres-mcp

~/.cursor/mcp.json

{
  "mcpServers": {
    "sezzlee-postgresql": {
      "command": "npx",
      "args": [
        "-y",
        "@sezzlee/postgres-mcp"
      ],
      "env": {
        "SEZZLEE_POSTGRES_SERVER": "<SEZZLEE_POSTGRES_SERVER>",
        "SEZZLEE_POSTGRES_DATABASE": "<SEZZLEE_POSTGRES_DATABASE>",
        "SEZZLEE_POSTGRES_USER": "<SEZZLEE_POSTGRES_USER>",
        "SEZZLEE_POSTGRES_PASSWORD": "<SEZZLEE_POSTGRES_PASSWORD>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "sezzlee-postgresql": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@sezzlee/postgres-mcp"
      ],
      "env": {
        "SEZZLEE_POSTGRES_SERVER": "<SEZZLEE_POSTGRES_SERVER>",
        "SEZZLEE_POSTGRES_DATABASE": "<SEZZLEE_POSTGRES_DATABASE>",
        "SEZZLEE_POSTGRES_USER": "<SEZZLEE_POSTGRES_USER>",
        "SEZZLEE_POSTGRES_PASSWORD": "<SEZZLEE_POSTGRES_PASSWORD>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "sezzlee-postgresql": {
      "command": "npx",
      "args": [
        "-y",
        "@sezzlee/postgres-mcp"
      ],
      "env": {
        "SEZZLEE_POSTGRES_SERVER": "<SEZZLEE_POSTGRES_SERVER>",
        "SEZZLEE_POSTGRES_DATABASE": "<SEZZLEE_POSTGRES_DATABASE>",
        "SEZZLEE_POSTGRES_USER": "<SEZZLEE_POSTGRES_USER>",
        "SEZZLEE_POSTGRES_PASSWORD": "<SEZZLEE_POSTGRES_PASSWORD>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "sezzlee-postgresql": {
      "command": "npx",
      "args": [
        "-y",
        "@sezzlee/postgres-mcp"
      ],
      "env": {
        "SEZZLEE_POSTGRES_SERVER": "<SEZZLEE_POSTGRES_SERVER>",
        "SEZZLEE_POSTGRES_DATABASE": "<SEZZLEE_POSTGRES_DATABASE>",
        "SEZZLEE_POSTGRES_USER": "<SEZZLEE_POSTGRES_USER>",
        "SEZZLEE_POSTGRES_PASSWORD": "<SEZZLEE_POSTGRES_PASSWORD>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "sezzlee-postgresql": {
      "command": "npx",
      "args": [
        "-y",
        "@sezzlee/postgres-mcp"
      ],
      "env": {
        "SEZZLEE_POSTGRES_SERVER": "<SEZZLEE_POSTGRES_SERVER>",
        "SEZZLEE_POSTGRES_DATABASE": "<SEZZLEE_POSTGRES_DATABASE>",
        "SEZZLEE_POSTGRES_USER": "<SEZZLEE_POSTGRES_USER>",
        "SEZZLEE_POSTGRES_PASSWORD": "<SEZZLEE_POSTGRES_PASSWORD>"
      }
    }
  }
}

需要的环境变量

SEZZLEE_POSTGRES_SERVER
SEZZLEE_POSTGRES_DATABASE
SEZZLEE_POSTGRES_USER
SEZZLEE_POSTGRES_PASSWORD

把占位值换成你自己的密钥；不要把密钥提交到代码仓库。

接入配置

需要的环境变量

相关推荐