Postgres MCP Server

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

claude mcp add postgres-mcp -- npx -y @edelciomolina/postgres-mcp

{
  "mcpServers": {
    "postgres-mcp": {
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ],
      "command": "npx"
    }
  }
}

[mcp_servers.postgres-mcp]
command = "npx"
args = ["-y", "@edelciomolina/postgres-mcp"]

{
  "mcpServers": {
    "postgres-mcp": {
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ],
      "command": "npx"
    }
  }
}

{
  "mcpServers": {
    "postgres-mcp": {
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ],
      "command": "npx"
    }
  }
}

This one needs environment variables set before it will start: MCP_KEY_HOST (Name of the .env variable that holds the database host), MCP_KEY_PORT (Name of the .env variable that holds the database port), MCP_KEY_NAME (Name of the .env variable that holds the database name), MCP_KEY_USER (Name of the .env variable that holds the database user), MCP_KEY_PASS (Name of the .env variable that holds the database password), MCP_KEY_SSLMODE (Name of the .env variable that holds the SSL mode (e.g. require)). The author declared them in the registry entry; get the values from the project itself.