PostgreSQL SSH

关于

postgresql-ssh-mcp is a robust Model Context Protocol (MCP) server designed to connect AI models like Claude Desktop and ChatGPT to PostgreSQL databases. It simplifies secure database access by integrating built-in SSH tunneling, automatically managing connections through bastion hosts without manual setup. The tool offers dual transport capabilities for different AI platforms, supports OAuth for secure ChatGPT integrations, and ensures production safety with a read-only by default mode and efficient connection pooling.

主要功能

• Dual Transport for Claude Desktop (STDIO) and ChatGPT (Streamable HTTP)
• Built-in SSH Tunneling with auto-reconnect and Trust on First Use (TOFU)
• Read-Only by Default for enhanced production safety
• Efficient Connection Pooling with configurable limits
• 0 GitHub stars
• OAuth Support via Auth0 for secure ChatGPT connections

使用案例

• Accessing remote PostgreSQL databases through bastion hosts without manual SSH port forwarding
• Integrating ChatGPT with PostgreSQL databases through a secure, streamable HTTP interface
• Connecting Claude Desktop securely to PostgreSQL databases via STDIO