Description

Advanced PostgreSQL MCP server with performance analysis, index tuning, query optimization, database health monitoring, and safe SQL execution modes.

Installation 

npx -y postgres-mcp
npm install postgres-mcp
git clone https://github.com/crystaldba/postgres-mcp

Claude Desktop Configuration

Add this configuration to your Claude Desktop config file to enable this MCP server:

Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json

Config file location: %APPDATA%\Claude\claude_desktop_config.json

Config file location: ~/.config/Claude/claude_desktop_config.json

claude_desktop_config.json 
{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "postgres-mcp"
      ]
    }
  }
}