How do I install @zlash65/postgresql Ssh?

Copy the stdio config for Cursor, Claude Desktop, Claude Code, or VS Code on this page. It uses the publisher's install, not a PlugMCP proxy.

Does @zlash65/postgresql Ssh need an API key?

No required environment variable is listed on this record.

What transport does @zlash65/postgresql Ssh use?

@zlash65/postgresql Ssh runs locally over stdio.

When was @zlash65/postgresql Ssh last checked?

Last checked 2026-11-11. PostgreSQL MCP Server with built-in SSH tunneling for secure database access through bastion hosts

@zlash65/postgresql Ssh MCP 伺服器

接入你的智能体

新增此伺服器

The publisher's own command. Not a PlugMCP endpoint.

Add to Cursor Add to VS Code 在 PlugMCP 上執行

用我們的金鑰與日誌託管一份副本。

Local command

npx -y @zlash65/[email protected]

Claude Code has no install link for a local command. Copy the command below and run it in a terminal.

shClaude Code

1claude mcp add zlash65-postgresql-ssh-mcp -- npx -y @zlash65/postgresql-ssh-mcp@1.2.1

Run in a terminal.

jsonClaude Desktop

1{2  "mcpServers": {3    "zlash65-postgresql-ssh-mcp": {4      "command": "npx",5      "args": [6        "-y",7        "@zlash65/[email protected]"8      ]9    }10  }11}

claude_desktop_config.json

Local · npmPublisher installStep-by-step: add this in Claude

Remote URL or a command on your machine? How the two installs differ

在 PlugMCP 上執行

用我們的金鑰與日誌託管一份副本。

这是你新建的服务器，不是此条目的官方端点。若要用发布方的 URL 与凭证，请使用上方安装面板。

啟動

Server facts

Local

Transport: stdio
Version: 1.2.1
Last checked

Tools

No tool list yet. Remote servers get one after the first health check.

FAQ

Questions

PostgreSQL SSH MCP Server

A secure PostgreSQL MCP server with built-in SSH tunneling. Connect to databases through bastion hosts automatically — no manual ssh -L required.

Features

Dual Transport — STDIO for Claude Desktop, Streamable HTTP for ChatGPT
SSH Tunneling — Built-in tunnel with auto-reconnect and TOFU (trust on first use)
Read-Only by Default — Safe for production; enable writes explicitly
OAuth Support — Auth0 integration for secure ChatGPT connections
Connection Pooling — Efficient resource management with configurable limits

Architecture

Quick Start

Claude Desktop (STDIO)

Add to your Claude Desktop config:

Platform	Config Location
macOS	`~/Library/Application Support/Claude/claude_desktop_config.json`
Windows	`%APPDATA%/Claude/claude_desktop_config.json`

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["-y", "@zlash65/postgresql-ssh-mcp"],
      "env": {
        "DATABASE_URI": "postgresql://user:password@localhost:5432/mydb"
      }
    }
  }
}

ChatGPT (Streamable HTTP)

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.

Available Tools

Query Tools

Tool	Description
`execute_query`	Execute SQL with parameterized queries. Results capped by `MAX_ROWS`.
`explain_query`	Get EXPLAIN plans in text, JSON, YAML, or XML format. Supports ANALYZE.

Schema Tools

Tool	Description
`list_schemas`	List database schemas. Excludes system schemas by default.
`list_tables`	List tables with row counts and sizes. Optionally include views.
`describe_table`	Get columns, constraints, and indexes for a table.
`list_databases`	List all databases with owner, encoding, and size.

Admin Tools

Tool	Description
`get_connection_status`	Get pool stats, tunnel state, and connection info.
`list_active_connections`	Show active connections from `pg_stat_activity`.
`list_long_running_queries`	Find queries running longer than a threshold.
`get_database_version`	Get PostgreSQL server version.
`get_database_size`	Get database size and largest tables.
`get_table_stats`	Get vacuum/analyze stats and scan counts for a table.

Environment Variables

Database Connection

Variable	Required	Default	Description
`DATABASE_URI`	Yes*	—	Full connection string (e.g., `postgresql://user:pass@host:5432/db`)
`DATABASE_HOST`	Yes*	—	Database hostname
`DATABASE_PORT`	No	`5432`	Database port
`DATABASE_NAME`	Yes*	—	Database name
`DATABASE_USER`	Yes*	—	Database username
`DATABASE_PASSWORD`	Yes*	—	Database password

*Either DATABASE_URI or all individual connection variables are required.

SSL Configuration

Variable	Default	Description
`DATABASE_SSL`	Auto	`true` or `false`. Auto-enabled for non-localhost.
`DATABASE_SSL_CA`	—	Path to CA certificate bundle
`DATABASE_SSL_REJECT_UNAUTHORIZED`	`true`	Set `false` to allow self-signed certificates

SSH Tunnel

Variable	Required	Default	Description
`SSH_ENABLED`	No	`false`	Set `true` to enable SSH tunneling
`SSH_HOST`	Yes*	—	SSH server hostname
`SSH_PORT`	No	`22`	SSH server port
`SSH_USER`	Yes*	—	SSH username
`SSH_PRIVATE_KEY_PATH`	Yes**	—	Path to private key file
`SSH_PRIVATE_KEY_PASSPHRASE`	No	—	Passphrase for encrypted keys
`SSH_PASSWORD`	Yes**	—	SSH password (alternative to key)
`SSH_STRICT_HOST_KEY`	No	`true`	Verify host key against known_hosts
`SSH_TRUST_ON_FIRST_USE`	No	`true`	Auto-add unknown hosts (when strict is enabled)
`SSH_KNOWN_HOSTS_PATH`	No	`~/.ssh/known_hosts`	Custom known_hosts file
`SSH_KEEPALIVE_INTERVAL`	No	`10000`	Keepalive interval in milliseconds
`SSH_MAX_RECONNECT_ATTEMPTS`	No	`5`	Max reconnect attempts (`-1` for unlimited)

*Required when SSH_ENABLED=true **Either SSH_PRIVATE_KEY_PATH or SSH_PASSWORD is required

Query Behavior

Variable	Default	Description
`READ_ONLY`	`true`	Block data modifications. Set `false` to allow writes.
`MAX_ROWS`	`1000`	Maximum rows returned per query
`QUERY_TIMEOUT`	`30000`	Query timeout in milliseconds
`MAX_CONCURRENT_QUERIES`	`10`	Maximum concurrent queries
`POOL_DRAIN_TIMEOUT_MS`	`5000`	Timeout for draining pool during reconnect

HTTP Server (Streamable HTTP only)

Variable	Default	Description
`PORT`	`3000`	HTTP server port
`MCP_HOST`	`0.0.0.0`	HTTP server bind address
`MCP_AUTH_MODE`	`none`	Authentication mode: `none` or `oauth`
`MCP_STATELESS`	`true`	Stateless mode (each request re-initializes)
`MCP_SERVER_POOL_SIZE`	`4`	Server instances for stateless mode
`MCP_SESSION_TTL_MINUTES`	`30`	Session TTL for stateful mode
`MCP_SESSION_CLEANUP_INTERVAL_MS`	`300000`	Session cleanup interval
`MCP_ALLOWED_ORIGINS`	—	Comma-separated allowed CORS origins (`*` for any)
`MCP_ALLOWED_HOSTS`	—	Comma-separated allowed Host headers

OAuth (Auth0)

Variable	Required	Description
`AUTH0_DOMAIN`	Yes*	Auth0 tenant domain (e.g., `tenant.us.auth0.com`)
`AUTH0_AUDIENCE`	Yes*	Auth0 API identifier / audience
`MCP_RESOURCE_DOCUMENTATION`	No	URL to API documentation (RFC 9728)

*Required when MCP_AUTH_MODE=oauth

Documentation

Guide	Description
STDIO Setup	Claude Desktop and local development
Streamable HTTP	HTTP server setup and configuration
Server Setup	Deploy to production with nginx and SSL
ChatGPT Setup	Complete Auth0 OAuth setup for ChatGPT

Docker

STDIO Server

docker build --target runtime -t postgresql-mcp .
docker run -e DATABASE_URI="postgresql://..." postgresql-mcp

HTTP Server

docker build --target runtime-http -t postgresql-mcp-http .
docker run -p 3000:3000 -e DATABASE_URI="postgresql://..." postgresql-mcp-http

Development

# Install dependencies
npm install

# Build
npm run build

# Run tests
npm test

# Type check
npm run typecheck

# Lint
npm run lint