Postgres MCP MCP Server

Name: Postgres MCP MCP Server
Author: io.github.edelciomolina

io.github.edelciomolina/postgres-mcp

Repository Registry

What is the Postgres MCP MCP server?

PostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only defaults.

How to install Postgres MCP

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

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)

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ],
      "env": {
        "MCP_KEY_HOST": "<YOUR_MCP_KEY_HOST>",
        "MCP_KEY_PORT": "<YOUR_MCP_KEY_PORT>",
        "MCP_KEY_NAME": "<YOUR_MCP_KEY_NAME>",
        "MCP_KEY_USER": "<YOUR_MCP_KEY_USER>",
        "MCP_KEY_PASS": "<YOUR_MCP_KEY_PASS>",
        "MCP_KEY_SSLMODE": "<YOUR_MCP_KEY_SSLMODE>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ],
      "env": {
        "MCP_KEY_HOST": "<YOUR_MCP_KEY_HOST>",
        "MCP_KEY_PORT": "<YOUR_MCP_KEY_PORT>",
        "MCP_KEY_NAME": "<YOUR_MCP_KEY_NAME>",
        "MCP_KEY_USER": "<YOUR_MCP_KEY_USER>",
        "MCP_KEY_PASS": "<YOUR_MCP_KEY_PASS>",
        "MCP_KEY_SSLMODE": "<YOUR_MCP_KEY_SSLMODE>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ],
      "env": {
        "MCP_KEY_HOST": "<YOUR_MCP_KEY_HOST>",
        "MCP_KEY_PORT": "<YOUR_MCP_KEY_PORT>",
        "MCP_KEY_NAME": "<YOUR_MCP_KEY_NAME>",
        "MCP_KEY_USER": "<YOUR_MCP_KEY_USER>",
        "MCP_KEY_PASS": "<YOUR_MCP_KEY_PASS>",
        "MCP_KEY_SSLMODE": "<YOUR_MCP_KEY_SSLMODE>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "postgres-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ],
      "env": {
        "MCP_KEY_HOST": "<YOUR_MCP_KEY_HOST>",
        "MCP_KEY_PORT": "<YOUR_MCP_KEY_PORT>",
        "MCP_KEY_NAME": "<YOUR_MCP_KEY_NAME>",
        "MCP_KEY_USER": "<YOUR_MCP_KEY_USER>",
        "MCP_KEY_PASS": "<YOUR_MCP_KEY_PASS>",
        "MCP_KEY_SSLMODE": "<YOUR_MCP_KEY_SSLMODE>"
      }
    }
  }
}

Claude Code

claude mcp add postgres-mcp --env MCP_KEY_HOST=<YOUR_MCP_KEY_HOST> --env MCP_KEY_PORT=<YOUR_MCP_KEY_PORT> --env MCP_KEY_NAME=<YOUR_MCP_KEY_NAME> --env MCP_KEY_USER=<YOUR_MCP_KEY_USER> --env MCP_KEY_PASS=<YOUR_MCP_KEY_PASS> --env MCP_KEY_SSLMODE=<YOUR_MCP_KEY_SSLMODE> -- npx -y @edelciomolina/postgres-mcp