PostgreSQL SSH MCP Server
A secure PostgreSQL MCP server with built-in SSH tunneling. Connect to databases through bastion hosts automatically — no manual required.
接入你的智能体
發布者自己的指令。不是 PlugMCP 端點。
用我們的金鑰與日誌託管一份副本。
npx -y @iflow-mcp/[email protected]Claude Code 沒有本機指令的安裝連結。複製下方指令並在終端機中執行。
claude mcp add iflow-mcp-zlash65-postgresql-ssh-mcp -- npx -y @iflow-mcp/zlash65-postgresql-ssh-mcp@1.2.1在終端機中執行。
{ "mcpServers": { "iflow-mcp-zlash65-postgresql-ssh-mcp": { "command": "npx", "args": [ "-y", "@iflow-mcp/[email protected]" ] } }}claude_desktop_config.json
遠端 URL 還是本機指令? 兩種安裝方式的差異
ssh -L
Add to your Claude Desktop config:
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": ["-y", "@zlash65/postgresql-ssh-mcp"],
"env": {
"DATABASE_URI": "postgresql://user:password@localhost:5432/mydb"
}
}
}
}
DATABASE_URI="postgresql://user:pass@localhost:5432/mydb" npx @zlash65/postgresql-ssh-mcp-http
Then configure ChatGPT to connect to https://your-subdomain.example.com/mcp.
Note: ChatGPT requires HTTPS. Use a tunnel (ngrok, Cloudflare Tunnel) for local testing.
*Either DATABASE_URI or all individual connection variables are required.
*Required when SSH_ENABLED=true
**Either SSH_PRIVATE_KEY_PATH or SSH_PASSWORD is required
*Required when MCP_AUTH_MODE=oauth
docker build --target runtime -t postgresql-mcp .
docker run -e DATABASE_URI="postgresql://..." postgresql-mcp
docker build --target runtime-http -t postgresql-mcp-http .
docker run -p 3000:3000 -e DATABASE_URI="postgresql://..." postgresql-mcp-http
# Install dependencies
npm install
# Build
npm run build
# Run tests
npm test
# Type check
npm run typecheck
# Lint
npm run lint
PostgreSQL MCP Server with built-in SSH tunneling for secure database access through bastion hosts
{ "mcpServers": { "iflow-mcp-zlash65-postgresql-ssh-mcp": { "command": "npx", "args": [ "-y", "@iflow-mcp/[email protected]" ] } }}工具
尚無工具清單。遠端伺服器會在首次健康檢查後取得工具清單。
常見問題
在本頁複製適用於 Cursor、Claude Desktop、Claude Code 或 VS Code 的 stdio 設定。它使用發布者的安裝方式,而不是 PlugMCP 代理伺服器。
這筆記錄未列出必要的環境變數。
@iflow MCP/zlash65 Postgresql Ssh 透過 stdio 在本機執行。
上次檢查時間:2026-11-16。 PostgreSQL MCP Server with built-in SSH tunneling for secure database access through bastion hosts