Postgres MCP for VS Code

io.github.edelciomolina/postgres-mcp

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

client:VS Code transport:stdio runtime:npm

Install Postgres MCP in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "mcp-key-host",
      "description": "MCP_KEY_HOST",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcp-key-port",
      "description": "MCP_KEY_PORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcp-key-name",
      "description": "MCP_KEY_NAME",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcp-key-user",
      "description": "MCP_KEY_USER",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcp-key-pass",
      "description": "MCP_KEY_PASS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcp-key-sslmode",
      "description": "MCP_KEY_SSLMODE",
      "password": true
    }
  ],
  "servers": {
    "postgres-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ],
      "env": {
        "MCP_KEY_HOST": "${input:mcp-key-host}",
        "MCP_KEY_PORT": "${input:mcp-key-port}",
        "MCP_KEY_NAME": "${input:mcp-key-name}",
        "MCP_KEY_USER": "${input:mcp-key-user}",
        "MCP_KEY_PASS": "${input:mcp-key-pass}",
        "MCP_KEY_SSLMODE": "${input:mcp-key-sslmode}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

Postgres MCP in other clients

Postgres MCP MCP server