io.github.edelciomolina/postgres-mcp

Official

by edelciomolina · JavaScript

Postgres MCP

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

PostgreSQL wrapper with environment variable credentials and safe read-only query defaults.

Topics

ai-toolsmcpmcp-serverpostgressecuritysql

Install

Configuration

Environment variables

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_config.json

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp@1.7.0"
      ],
      "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>"
      }
    }
  }
}