PostgreSQL SSH FAQs

Question 1

What is PostgreSQL SSH MCP Server?

Accepted Answer

It's a secure server designed for AI models (like ChatGPT and Claude) to access PostgreSQL databases. It features built-in SSH tunneling, flexible transport methods, and various database interaction tools.

Question 2

Which AI models and platforms does it support?

Accepted Answer

It offers dual transport methods, supporting Claude Desktop via STDIO and ChatGPT via Streamable HTTP, ensuring seamless and secure integration with both AI platforms.

Question 3

Is PostgreSQL SSH suitable for production environments?

Accepted Answer

Absolutely. It's designed for production with features like Read-Only by Default, efficient connection pooling, and robust SSH tunneling for secure access to databases behind bastion hosts.

Question 4

How does PostgreSQL SSH enhance security for AI model connections?

Accepted Answer

It provides built-in SSH tunneling with auto-reconnect and Trust on First Use (TOFU), OAuth support via Auth0 for ChatGPT, and operates in read-only mode by default for enhanced production safety.

Question 5

Does it support advanced database operations beyond simple queries?

Accepted Answer

Yes, it includes query tools for executing parameterized SQL and getting EXPLAIN plans, schema tools for listing/describing tables, and admin tools for monitoring connections, long-running queries, and database stats.

PostgreSQL SSH

PostgreSQL SSH

主要功能

使用案例

主要功能

使用案例