cosmic-mcp

All servers

pgmcp

io.github.pascalallen/pgmcp ยท version 1.1.0

Community listing. Not installed or verified by cosmic-mcp. Read the source and its permissions before you run it.

Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.

https://github.com/pascalallen/pgmcp

Quick facts

  • Listing: Community
  • Published Aug 20, 19:02 UTC
  • Transport: stdio
  • Package: oci ghcr.io/pascalallen/pgmcp:1.1.0
  • Listed by cosmic-mcp: Nov 8, 19:00 UTC

Databases Health and medicine

Setup snippets

Generated from the registry entry. cosmic-mcp has not run or reviewed this server; values in angle brackets are yours to fill in.

Run it locally (oci)

docker run -i --rm -e 'PGMCP_DATABASE_URL' 'ghcr.io/pascalallen/pgmcp:1.1.0'

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "pgmcp": {
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "PGMCP_DATABASE_URL",
        "ghcr.io/pascalallen/pgmcp:1.1.0"
      ],
      "command": "docker",
      "env": {
        "PGMCP_DATABASE_URL": "<your pgmcp database url>"
      }
    }
  }
}

Claude Code

claude mcp add 'pgmcp' -- docker run -i --rm -e 'PGMCP_DATABASE_URL' 'ghcr.io/pascalallen/pgmcp:1.1.0'

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "pgmcp": {
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "PGMCP_DATABASE_URL",
        "ghcr.io/pascalallen/pgmcp:1.1.0"
      ],
      "command": "docker",
      "env": {
        "PGMCP_DATABASE_URL": "<your pgmcp database url>"
      }
    }
  }
}

VS Code (.vscode/mcp.json)

{
  "servers": {
    "pgmcp": {
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "PGMCP_DATABASE_URL",
        "ghcr.io/pascalallen/pgmcp:1.1.0"
      ],
      "command": "docker",
      "env": {
        "PGMCP_DATABASE_URL": "<your pgmcp database url>"
      },
      "type": "stdio"
    }
  }
}

Related servers

  • 1k-patient-mcp
    1k patient MCP server
  • 3CX MCP
    3CX for MSPs: trunk, licence, version and backup health across every client phone system.
  • AI for Database Verified domain
    Ask your databases questions in plain English, run read-only SQL and set up data alerts.
  • AI plant health diagnosis
    Fast, private multi-species diagnosis. Custom-trained models. No third-party AI or image retention.
  • AI2SQL Verified domain
    Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
  • AICasePredict Verified domain
    Search a large legal database of 325M+ US court records: cases, attorneys, judges and courts.