pgtuner MCP

Name: pgtuner MCP
Author: isdaniel

isdaniel

Analyzes PostgreSQL queries, recommends indexes and runs health checks for performance tuning.

Setup

Choose your client, copy the config, then fill in any required environment variables.

claude mcp add pgtuner -- uvx pgtuner-mcp

~/.codex/config.toml

[mcp_servers.pgtuner]
command = "uvx"
args = ["pgtuner-mcp"]

# codex mcp add pgtuner -- uvx pgtuner-mcp

~/.cursor/mcp.json

{
  "mcpServers": {
    "pgtuner": {
      "command": "uvx",
      "args": [
        "pgtuner-mcp"
      ]
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "pgtuner": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "pgtuner-mcp"
      ]
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "pgtuner": {
      "command": "uvx",
      "args": [
        "pgtuner-mcp"
      ]
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "pgtuner": {
      "command": "uvx",
      "args": [
        "pgtuner-mcp"
      ]
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "pgtuner": {
      "command": "uvx",
      "args": [
        "pgtuner-mcp"
      ]
    }
  }
}