Postgres MCP

Official

by edelciomolina · JavaScript

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

io.github.edelciomolina/postgres-mcp — Model Context Protocol (MCP) PostgreSQL Wrapper

This MCP server acts as a PostgreSQL MCP wrapper that provides .env credential mapping, supports tool selection, and applies safe read-only defaults. The server description emphasizes secure handling and controlled access when interacting with PostgreSQL through MCP.

🛠️ Key Features

PostgreSQL MCP wrapper
.env credential mapping
Tool selection
Safe read-only defaults

🚀 Use Cases

Connect MCP clients to PostgreSQL using mapped .env credentials
Use selected tools rather than unrestricted database capabilities

⚡ Developer Benefits

Predictable tool availability via tool selection
Reduced risk through safe read-only defaults

⚠️ Limitations

Read-only defaults indicate restricted write access (as described)

Tags / Topics

ai-tools, mcp, mcp-server, postgres, security, sql

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)

Add to VS Code Add to Cursor

claude_desktop_config.json

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