PostgreSQL MCP Server

A Model Context Protocol (MCP) server that provides read-only SQL query access to a PostgreSQL database (local or AWS RDS).

This server is published on npm and protected Anyone can install it,

🚀 Installation

No local build or cloning required.

npm install -g postgress-mcp-server-nachiket12

📍 Where to add the MCP JSON file

You must add the MCP configuration to your MCP client's settings file.

🪟 Windows (Claude / Cline / Windsurf)

C:\Users\<YOUR_USER>\AppData\Roaming\Windsurf\User\globalStorage\
saoudrizwan.claude-dev\settings\cline_mcp_settings.json

⚙️ Configuration

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": ["postgress-mcp-server-nachiket12"],
      "env": {
        "DATABASE_URL": "postgresql://postgres:1234@localhost:5433/code_executer_db",
        "DB_SSL_MODE": "disable"
      },
      "transportType": "stdio",
      "disabled": false,
      "autoApprove": ["query"]
    }
  }
}

🔒 SSL Behavior (Important)

Control PostgreSQL SSL behavior using DB_SSL_MODE:

• disable → Local PostgreSQL (no SSL)
• require → AWS RDS / production (SSL enforced)
• auto → Auto-detect (default)