postgresql-ssh-mcp

概述

这是一个功能齐全的 PostgreSQL MCP 服务器，具有内置的 SSH 隧道功能。它提供双传输模式 - Claude Desktop 的 STDIO 和 ChatGPT 的 HTTP - 使其能够在不同的 AI 环境中灵活使用。服务器实现了强大的安全功能，包括只读默认设置、OAuth 支持以及具有 TOFU（首次使用信任）身份验证的自动 SSH 隧道管理。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• execute_query

  Execute SQL with parameterized queries. Results capped by MAX_ROWS.

  试试:Find all users registered in the last month试试:Show me the top 10 customers by revenue试试:Count the number of orders per product category
• explain_query

  Get EXPLAIN plans in text, JSON, YAML, or XML format. Supports ANALYZE.

  试试:Explain how this query will be executed试试:Show the query plan with ANALYZE for the sales report试试:Get the execution plan in JSON format
• list_schemas

  List database schemas. Excludes system schemas by default.

  试试:Show me all available schemas in the database试试:List all user-defined schemas试试:What schemas exist in this database?
• list_tables

  List tables with row counts and sizes. Optionally include views.

  试试:Show all tables in the public schema试试:List tables and their sizes试试:What tables exist in the database including views?
• describe_table

  Get columns, constraints, and indexes for a table.

  试试:Describe the users table structure试试:Show me the schema of the orders table试试:What columns and indexes does the products table have?
• list_databases

  List all databases with owner, encoding, and size.

  试试:Show all databases on this server试试:List databases with their sizes试试:What databases are available?
• get_connection_status

  Get pool stats, tunnel state, and connection info.

  试试:Show connection pool status试试:What's the current state of the SSH tunnel?试试:Display database connection statistics
• list_active_connections

  Show active connections from pg_stat_activity.

  试试:Show all active database connections试试:List current sessions and their queries试试:Who is connected to the database right now?
• list_long_running_queries

  Find queries running longer than a threshold.

  试试:Show queries running longer than 5 minutes试试:List all long-running transactions试试:Find slow queries that need attention
• get_database_version

  Get PostgreSQL server version.

  试试:What PostgreSQL version is running?试试:Show the database version number试试:Check the server version
• get_database_size

  Get database size and largest tables.

  试试:Show the total size of the database试试:List the largest tables in the database试试:What's the disk usage breakdown by table?
• get_table_stats

  Get vacuum/analyze stats and scan counts for a table.

  试试:Show statistics for the orders table试试:Get vacuum and analyze stats for products试试:Display table-level statistics

可对比工具

安装

{
  "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

FAQ

SSH 隧道功能如何工作？

服务器会自动创建到您堡垒主机的 SSH 隧道，并通过它安全地转发数据库连接。无需手动执行 `ssh -L` 命令。

我可以使用此服务器修改数据库表吗？

默认情况下，服务器设置为只读模式以确保生产环境的安全使用。您可以通过将 READ_ONLY 环境变量设置为 'false' 来启用写入功能。

postgresql-ssh-mcp 对比