Postgres SSH FAQs

Question 1

Which AI tools can integrate with Postgres SSH?

Accepted Answer

Postgres SSH is compatible with any MCP-compatible AI tool, including popular options like Claude Desktop, Cursor, and Windsurf. It also provides specific instructions for integration with Claude Code.

Question 2

Is Postgres SSH read-only by default, and can it be configured for writes?

Accepted Answer

Yes, Postgres SSH operates in a read-only mode by default (DB_READ_ONLY=true) for query execution via `run_query`. You can explicitly set the `DB_READ_ONLY` environment variable to `false` to enable write operations when needed.

Question 3

What is Postgres SSH (postgres-ssh-mcp)?

Accepted Answer

Postgres SSH (postgres-ssh-mcp) is a cross-platform server that allows AI tools to securely query and introspect PostgreSQL databases. It supports macOS, Linux, and Windows, and features robust SSH tunnel connectivity options.

Question 4

What database operations can AI perform using Postgres SSH?

Accepted Answer

AI tools can execute SQL queries with `run_query` (read-only by default), list all database schemas with `list_schemas`, list tables within a schema using `list_tables`, and get detailed table descriptions (columns, types) with `describe_table`.

Question 5

How does Postgres SSH provide secure connections for AI tools?

Accepted Answer

It offers three flexible connection modes: Direct, SSH config (reading your ~/.ssh/config), and Explicit SSH tunnels. These modes support identity files and passphrases, ensuring secure and private access to your PostgreSQL instances.

Postgres SSH

Postgres SSH

Key Features

Use Cases

Key Features

Use Cases