protogrid
Sign inAdd to your agent

Search / io.github.arzharch/pgops-mcp

pgops

L0· runs locally

Safe, audited PostgreSQL operations for AI agents: queries, migrations, EXPLAIN, containers

v0.1.9 · active · repository · descriptor JSON · versions

Runs on your machine: something must execute the package.Only local packages are published (npm, PyPI, OCI, …). The registry never executes them, so tools are unknown until you run it.
Quality–not scored
Trust86of 100
Packages2
Tools seen0

Connect

8 clients · secrets stay placeholders
{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp==0.1.9"
      ],
      "env": {
        "PGOPS_DSN": "${PGOPS_DSN}",
        "PGOPS_READONLY_DSN": "${PGOPS_READONLY_DSN}",
        "PGOPS_READ_ONLY": "0",
        "PGOPS_APPROVAL_MODE": "0",
        "PGOPS_AUDIT_LOG": "~/.pgops/audit.jsonl",
        "PGOPS_DEFAULT_TIMEOUT_MS": "5000",
        "PGOPS_MAX_TIMEOUT_MS": "30000",
        "PGOPS_DEFAULT_ROW_LIMIT": "100"
      }
    }
  }
}
claude mcp add pgops-mcp -e "PGOPS_DSN=${PGOPS_DSN}" -e "PGOPS_READONLY_DSN=${PGOPS_READONLY_DSN}" -e "PGOPS_READ_ONLY=0" -e "PGOPS_APPROVAL_MODE=0" -e "PGOPS_AUDIT_LOG=~/.pgops/audit.jsonl" -e "PGOPS_DEFAULT_TIMEOUT_MS=5000" -e "PGOPS_MAX_TIMEOUT_MS=30000" -e "PGOPS_DEFAULT_ROW_LIMIT=100" -- uvx pgops-mcp==0.1.9
[mcp_servers.pgops-mcp]
command = "uvx"
args = ["pgops-mcp==0.1.9"]
env = { "PGOPS_DSN" = "${PGOPS_DSN}", "PGOPS_READONLY_DSN" = "${PGOPS_READONLY_DSN}", "PGOPS_READ_ONLY" = "0", "PGOPS_APPROVAL_MODE" = "0", "PGOPS_AUDIT_LOG" = "~/.pgops/audit.jsonl", "PGOPS_DEFAULT_TIMEOUT_MS" = "5000", "PGOPS_MAX_TIMEOUT_MS" = "30000", "PGOPS_DEFAULT_ROW_LIMIT" = "100" }

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "pgops-mcp": {
      "type": "local",
      "command": [
        "uvx",
        "pgops-mcp==0.1.9"
      ],
      "enabled": true,
      "environment": {
        "PGOPS_DSN": "{env:PGOPS_DSN}",
        "PGOPS_READONLY_DSN": "{env:PGOPS_READONLY_DSN}",
        "PGOPS_READ_ONLY": "0",
        "PGOPS_APPROVAL_MODE": "0",
        "PGOPS_AUDIT_LOG": "~/.pgops/audit.jsonl",
        "PGOPS_DEFAULT_TIMEOUT_MS": "5000",
        "PGOPS_MAX_TIMEOUT_MS": "30000",
        "PGOPS_DEFAULT_ROW_LIMIT": "100"
      }
    }
  }
}
{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp==0.1.9"
      ],
      "env": {
        "PGOPS_DSN": "${PGOPS_DSN}",
        "PGOPS_READONLY_DSN": "${PGOPS_READONLY_DSN}",
        "PGOPS_READ_ONLY": "0",
        "PGOPS_APPROVAL_MODE": "0",
        "PGOPS_AUDIT_LOG": "~/.pgops/audit.jsonl",
        "PGOPS_DEFAULT_TIMEOUT_MS": "5000",
        "PGOPS_MAX_TIMEOUT_MS": "30000",
        "PGOPS_DEFAULT_ROW_LIMIT": "100"
      }
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=pgops-mcp&config=eyJjb21tYW5kIjoidXZ4IiwiYXJncyI6WyJwZ29wcy1tY3A9PTAuMS45Il0sImVudiI6eyJQR09QU19EU04iOiIke1BHT1BTX0RTTn0iLCJQR09QU19SRUFET05MWV9EU04iOiIke1BHT1BTX1JFQURPTkxZX0RTTn0iLCJQR09QU19SRUFEX09OTFkiOiIwIiwiUEdPUFNfQVBQUk9WQUxfTU9ERSI6IjAiLCJQR09QU19BVURJVF9MT0ciOiJ%2BLy5wZ29wcy9hdWRpdC5qc29ubCIsIlBHT1BTX0RFRkFVTFRfVElNRU9VVF9NUyI6IjUwMDAiLCJQR09QU19NQVhfVElNRU9VVF9NUyI6IjMwMDAwIiwiUEdPUFNfREVGQVVMVF9ST1dfTElNSVQiOiIxMDAifX0%3D"
}
{
  "servers": {
    "pgops-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "pgops-mcp==0.1.9"
      ],
      "env": {
        "PGOPS_DSN": "${PGOPS_DSN}",
        "PGOPS_READONLY_DSN": "${PGOPS_READONLY_DSN}",
        "PGOPS_READ_ONLY": "0",
        "PGOPS_APPROVAL_MODE": "0",
        "PGOPS_AUDIT_LOG": "~/.pgops/audit.jsonl",
        "PGOPS_DEFAULT_TIMEOUT_MS": "5000",
        "PGOPS_MAX_TIMEOUT_MS": "30000",
        "PGOPS_DEFAULT_ROW_LIMIT": "100"
      }
    }
  }
}
{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp==0.1.9"
      ],
      "env": {
        "PGOPS_DSN": "${PGOPS_DSN}",
        "PGOPS_READONLY_DSN": "${PGOPS_READONLY_DSN}",
        "PGOPS_READ_ONLY": "0",
        "PGOPS_APPROVAL_MODE": "0",
        "PGOPS_AUDIT_LOG": "~/.pgops/audit.jsonl",
        "PGOPS_DEFAULT_TIMEOUT_MS": "5000",
        "PGOPS_MAX_TIMEOUT_MS": "30000",
        "PGOPS_DEFAULT_ROW_LIMIT": "100"
      }
    }
  }
}
extensions:
  "pgops-mcp":
    enabled: true
    name: "pgops-mcp"
    type: stdio
    cmd: "uvx"
    args:
      - "pgops-mcp==0.1.9"
    envs:
      "PGOPS_DSN": "${PGOPS_DSN}"
      "PGOPS_READONLY_DSN": "${PGOPS_READONLY_DSN}"
      "PGOPS_READ_ONLY": "0"
      "PGOPS_APPROVAL_MODE": "0"
      "PGOPS_AUDIT_LOG": "~/.pgops/audit.jsonl"
      "PGOPS_DEFAULT_TIMEOUT_MS": "5000"
      "PGOPS_MAX_TIMEOUT_MS": "30000"
      "PGOPS_DEFAULT_ROW_LIMIT": "100"
    timeout: 300

Placeholders to fill from your own secret store: ${PGOPS_DSN}, ${PGOPS_READONLY_DSN}. The registry never accepts secret values.

This is a local package: the command runs on your machine.

Quality – / 100not scored

Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.

protocoln/a · weight 25
  • n/a
    protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)
authorizationn/a · weight 15
  • n/a
    auth.prm, auth.as_metadata, auth.cimdno remote uses OAuth
  • n/a
    auth.secret_in_urlno templated URL
tool hygienen/a · weight 30
  • n/a
    tools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)
stabilityn/a · weight 15
  • n/a
    stability.changes, stability.rug_pulltool list unknown
dependencies100 · weight 15
  • pass
    deps.known_vulnsno known advisory in 75 resolved packages
  • pass
    deps.mcp_sdk_versionmcp 1.30.0, no known advisory
  • pass
    deps.resolvable[email protected] resolved: 75 packages

Tool list unknown · checked 2026-10-20 15:57 UTC

Tool changes

No tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.

Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.

Trust 86 / 100

provenance80
livenessn/a
freshness85
hygiene95

+repository +namespace-matches-repo ~liveness-unmeasured ~updated-49d-ago -unpinned-packages(1)

Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.

Dependencies

[email protected] PyPI74 dependencies, resolved · MCP SDK mcp 1.30.0 · advisories checked 2026-10-19

No known advisory affects this dependency graph.

Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.

Endpoints

packageregistryversionruntimesecrets
pgops-mcppypi0.1.9uvxPGOPS_DSN, PGOPS_READONLY_DSN
ghcr.io/arzharch/pgops-mcp:0.1.9ociunpinned–PGOPS_DSN

Tools (0)

No tools observed. Local packages are never executed by the registry.

Schemas: list_tools.

Similar MCP servers

  • AgentSQLunknown
    io.github.cuipengdba/agentsql

    Guard AI agents' PostgreSQL/MySQL access via MCP: SQL audit, auth, masking, write approval

  • PostgreSQL MCP ServerL0
    io.github.YawLabs/postgres-mcp

    PostgreSQL MCP server - query, schema introspection, explain, and health checks for AI assistants

  • PostgreSQL CVE & Release IntelligenceL0
    io.github.meob/pg-cve-mcp

    PostgreSQL security for AI agents: CVEs, yanked releases, exploits, and upgrade paths

  • Infino-aiL0
    io.github.infino-ai/mcp-server

    Keyword, semantic, hybrid, and SQL retrieval for AI agents, local or on Infino Cloud.

  • Postgres AIopsL0
    io.github.AIops-tools/postgres-aiops

    Governed PostgreSQL DBA ops: slow-query RCA, bloat/vacuum & blocking-lock analysis; 35 MCP tools.

  • FairsealL0
    io.fairseal/mcp-server

    Verifiable entropy, provably-fair games, and receipt verification for AI agents (FairSeal API).

Official server.json
{
  "name": "io.github.arzharch/pgops-mcp",
  "title": "pgops",
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "version": "0.1.9",
  "packages": [
    {
      "version": "0.1.9",
      "transport": {
        "type": "stdio"
      },
      "identifier": "pgops-mcp",
      "runtimeHint": "uvx",
      "registryType": "pypi",
      "registryBaseUrl": "https://pypi.org",
      "environmentVariables": [
        {
          "name": "PGOPS_DSN",
          "isSecret": true,
          "isRequired": true,
          "description": "PostgreSQL connection string for the database to operate on."
        },
        {
          "name": "PGOPS_READONLY_DSN",
          "isSecret": true,
          "description": "Optional separate DSN for the read-only pool. Use a role with no write grants to enforce read-only at the database rather than only in the server."
        },
        {
          "name": "PGOPS_READ_ONLY",
          "default": "0",
          "description": "Set to 1 to withhold every mutating tool. Write tools are not registered at all, so an agent cannot call them."
        },
        {
          "name": "PGOPS_APPROVAL_MODE",
          "default": "0",
          "description": "Set to 1 to register container.restart and container.exec. Off by default: Docker socket access is root-equivalent on the host."
        },
        {
          "name": "PGOPS_AUDIT_LOG",
          "default": "~/.pgops/audit.jsonl",
          "description": "Path to the append-only JSONL audit log."
        },
        {
          "name": "PGOPS_DEFAULT_TIMEOUT_MS",
          "default": "5000",
          "description": "Statement timeout applied to every query unless a tool call overrides it."
        },
        {
          "name": "PGOPS_MAX_TIMEOUT_MS",
          "default": "30000",
          "description": "Ceiling a caller-supplied timeout is clamped to."
        },
        {
          "name": "PGOPS_DEFAULT_ROW_LIMIT",
          "default": "100",
          "description": "Rows returned by query.read when the caller does not specify a limit."
        }
      ]
    },
    {
      "transport": {
        "type": "stdio"
      },
      "identifier": "ghcr.io/arzharch/pgops-mcp:0.1.9",
      "registryType": "oci",
      "environmentVariables": [
        {
          "name": "PGOPS_DSN",
          "isSecret": true,
          "isRequired": true,
          "description": "PostgreSQL connection string. From inside a container, localhost is the container itself — use host.docker.internal or the compose service name."
        },
        {
          "name": "PGOPS_READ_ONLY",
          "default": "0",
          "description": "Set to 1 to withhold every mutating tool."
        },
        {
          "name": "PGOPS_AUDIT_LOG",
          "default": "/var/lib/pgops/audit.jsonl",
          "description": "Path to the audit log inside the container. Mount a volume at this path or the log dies with the container."
        }
      ]
    }
  ],
  "repository": {
    "url": "https://github.com/arzharch/pgops-mcp",
    "source": "github"
  },
  "description": "Safe, audited PostgreSQL operations for AI agents: queries, migrations, EXPLAIN, containers"
}