SERVER

pgops

Rank #4,900

io.github.arzharch/pgops-mcp

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

8 versions

by arzharch (1 servers)View repository ↗Claim this server

First listed

Aug 24, 2026

Last publish date

Sep 1, 2026

OVERVIEW

pgops is a Model Context Protocol (MCP) server published by arzharch. It ranks #4,900 of 132,046 servers tracked on MCP Toplist. pgops is listed across 2 registries — Official MCP and Glama, with 8 tracked versions. It was first listed on Aug 24, 2026 and most recently updated on Sep 1, 2026.

STANDING

#4,900of 132,046 tracked serversTop 5%

Ranks ahead of 127,146 of 132,046 servers on MCP Toplist.

CONNECT

Use pgops

API keyNeeds credentials

Requires user-supplied configuration before first use — typically an API key, token or connection string set via environment variables.

Python package (PyPI)

claude mcp add pgops-mcp -e "PGOPS_DSN=<your PGOPS_DSN>" -e "PGOPS_READONLY_DSN=<your PGOPS_READONLY_DSN>" -e "PGOPS_READ_ONLY=<your PGOPS_READ_ONLY>" -e "PGOPS_APPROVAL_MODE=<your PGOPS_APPROVAL_MODE>" -e "PGOPS_AUDIT_LOG=<your PGOPS_AUDIT_LOG>" -e "PGOPS_DEFAULT_TIMEOUT_MS=<your PGOPS_DEFAULT_TIMEOUT_MS>" -e "PGOPS_MAX_TIMEOUT_MS=<your PGOPS_MAX_TIMEOUT_MS>" -e "PGOPS_DEFAULT_ROW_LIMIT=<your PGOPS_DEFAULT_ROW_LIMIT>" -- uvx pgops-mcp

Replace each placeholder with your own value before saving.

Docker image

claude mcp add pgops-mcp -e "PGOPS_DSN=<your PGOPS_DSN>" -e "PGOPS_READ_ONLY=<your PGOPS_READ_ONLY>" -e "PGOPS_AUDIT_LOG=<your PGOPS_AUDIT_LOG>" -- docker run -i --rm ghcr.io/arzharch/pgops-mcp:0.1.9

Replace each placeholder with your own value before saving.

Python package (PyPI)

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

[mcp_servers.pgops-mcp.env]
PGOPS_DSN = "<your PGOPS_DSN>"
PGOPS_READONLY_DSN = "<your PGOPS_READONLY_DSN>"
PGOPS_READ_ONLY = "<your PGOPS_READ_ONLY>"
PGOPS_APPROVAL_MODE = "<your PGOPS_APPROVAL_MODE>"
PGOPS_AUDIT_LOG = "<your PGOPS_AUDIT_LOG>"
PGOPS_DEFAULT_TIMEOUT_MS = "<your PGOPS_DEFAULT_TIMEOUT_MS>"
PGOPS_MAX_TIMEOUT_MS = "<your PGOPS_MAX_TIMEOUT_MS>"
PGOPS_DEFAULT_ROW_LIMIT = "<your PGOPS_DEFAULT_ROW_LIMIT>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

Docker image

[mcp_servers.pgops-mcp]
command = "docker"
args = ["run", "-i", "--rm", "ghcr.io/arzharch/pgops-mcp:0.1.9"]

[mcp_servers.pgops-mcp.env]
PGOPS_DSN = "<your PGOPS_DSN>"
PGOPS_READ_ONLY = "<your PGOPS_READ_ONLY>"
PGOPS_AUDIT_LOG = "<your PGOPS_AUDIT_LOG>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<your PGOPS_DSN>",
        "PGOPS_READONLY_DSN": "<your PGOPS_READONLY_DSN>",
        "PGOPS_READ_ONLY": "<your PGOPS_READ_ONLY>",
        "PGOPS_APPROVAL_MODE": "<your PGOPS_APPROVAL_MODE>",
        "PGOPS_AUDIT_LOG": "<your PGOPS_AUDIT_LOG>",
        "PGOPS_DEFAULT_TIMEOUT_MS": "<your PGOPS_DEFAULT_TIMEOUT_MS>",
        "PGOPS_MAX_TIMEOUT_MS": "<your PGOPS_MAX_TIMEOUT_MS>",
        "PGOPS_DEFAULT_ROW_LIMIT": "<your PGOPS_DEFAULT_ROW_LIMIT>"
      }
    }
  }
}

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

Docker image

{
  "mcpServers": {
    "pgops-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/arzharch/pgops-mcp:0.1.9"
      ],
      "env": {
        "PGOPS_DSN": "<your PGOPS_DSN>",
        "PGOPS_READ_ONLY": "<your PGOPS_READ_ONLY>",
        "PGOPS_AUDIT_LOG": "<your PGOPS_AUDIT_LOG>"
      }
    }
  }
}

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<your PGOPS_DSN>",
        "PGOPS_READONLY_DSN": "<your PGOPS_READONLY_DSN>",
        "PGOPS_READ_ONLY": "<your PGOPS_READ_ONLY>",
        "PGOPS_APPROVAL_MODE": "<your PGOPS_APPROVAL_MODE>",
        "PGOPS_AUDIT_LOG": "<your PGOPS_AUDIT_LOG>",
        "PGOPS_DEFAULT_TIMEOUT_MS": "<your PGOPS_DEFAULT_TIMEOUT_MS>",
        "PGOPS_MAX_TIMEOUT_MS": "<your PGOPS_MAX_TIMEOUT_MS>",
        "PGOPS_DEFAULT_ROW_LIMIT": "<your PGOPS_DEFAULT_ROW_LIMIT>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

Docker image

{
  "mcpServers": {
    "pgops-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/arzharch/pgops-mcp:0.1.9"
      ],
      "env": {
        "PGOPS_DSN": "<your PGOPS_DSN>",
        "PGOPS_READ_ONLY": "<your PGOPS_READ_ONLY>",
        "PGOPS_AUDIT_LOG": "<your PGOPS_AUDIT_LOG>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "servers": {
    "pgops-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<your PGOPS_DSN>",
        "PGOPS_READONLY_DSN": "<your PGOPS_READONLY_DSN>",
        "PGOPS_READ_ONLY": "<your PGOPS_READ_ONLY>",
        "PGOPS_APPROVAL_MODE": "<your PGOPS_APPROVAL_MODE>",
        "PGOPS_AUDIT_LOG": "<your PGOPS_AUDIT_LOG>",
        "PGOPS_DEFAULT_TIMEOUT_MS": "<your PGOPS_DEFAULT_TIMEOUT_MS>",
        "PGOPS_MAX_TIMEOUT_MS": "<your PGOPS_MAX_TIMEOUT_MS>",
        "PGOPS_DEFAULT_ROW_LIMIT": "<your PGOPS_DEFAULT_ROW_LIMIT>"
      }
    }
  }
}

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

Docker image

{
  "servers": {
    "pgops-mcp": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/arzharch/pgops-mcp:0.1.9"
      ],
      "env": {
        "PGOPS_DSN": "<your PGOPS_DSN>",
        "PGOPS_READ_ONLY": "<your PGOPS_READ_ONLY>",
        "PGOPS_AUDIT_LOG": "<your PGOPS_AUDIT_LOG>"
      }
    }
  }
}

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<your PGOPS_DSN>",
        "PGOPS_READONLY_DSN": "<your PGOPS_READONLY_DSN>",
        "PGOPS_READ_ONLY": "<your PGOPS_READ_ONLY>",
        "PGOPS_APPROVAL_MODE": "<your PGOPS_APPROVAL_MODE>",
        "PGOPS_AUDIT_LOG": "<your PGOPS_AUDIT_LOG>",
        "PGOPS_DEFAULT_TIMEOUT_MS": "<your PGOPS_DEFAULT_TIMEOUT_MS>",
        "PGOPS_MAX_TIMEOUT_MS": "<your PGOPS_MAX_TIMEOUT_MS>",
        "PGOPS_DEFAULT_ROW_LIMIT": "<your PGOPS_DEFAULT_ROW_LIMIT>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

Docker image

{
  "mcpServers": {
    "pgops-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/arzharch/pgops-mcp:0.1.9"
      ],
      "env": {
        "PGOPS_DSN": "<your PGOPS_DSN>",
        "PGOPS_READ_ONLY": "<your PGOPS_READ_ONLY>",
        "PGOPS_AUDIT_LOG": "<your PGOPS_AUDIT_LOG>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<your PGOPS_DSN>",
        "PGOPS_READONLY_DSN": "<your PGOPS_READONLY_DSN>",
        "PGOPS_READ_ONLY": "<your PGOPS_READ_ONLY>",
        "PGOPS_APPROVAL_MODE": "<your PGOPS_APPROVAL_MODE>",
        "PGOPS_AUDIT_LOG": "<your PGOPS_AUDIT_LOG>",
        "PGOPS_DEFAULT_TIMEOUT_MS": "<your PGOPS_DEFAULT_TIMEOUT_MS>",
        "PGOPS_MAX_TIMEOUT_MS": "<your PGOPS_MAX_TIMEOUT_MS>",
        "PGOPS_DEFAULT_ROW_LIMIT": "<your PGOPS_DEFAULT_ROW_LIMIT>"
      }
    }
  }
}

Replace each placeholder with your own value before saving.

Docker image

{
  "mcpServers": {
    "pgops-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/arzharch/pgops-mcp:0.1.9"
      ],
      "env": {
        "PGOPS_DSN": "<your PGOPS_DSN>",
        "PGOPS_READ_ONLY": "<your PGOPS_READ_ONLY>",
        "PGOPS_AUDIT_LOG": "<your PGOPS_AUDIT_LOG>"
      }
    }
  }
}

Replace each placeholder with your own value before saving.

BADGE

Show your rank

Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.

Markdown

[![MCP Toplist](https://mcptoplist.com/badge/io.github.arzharch%2Fpgops-mcp.svg)](https://mcptoplist.com/server/io.github.arzharch%2Fpgops-mcp)

HTML

<a href="https://mcptoplist.com/server/io.github.arzharch%2Fpgops-mcp"><img src="https://mcptoplist.com/badge/io.github.arzharch%2Fpgops-mcp.svg" alt="MCP Toplist: Top 5% of 132,046" /></a>

Variants: append ?metric=score or ?metric=stars to the image URL.

REGISTRIES

Listed on 2 registries

Glama

Official MCP

ORGANIZATION

arzharch

Organization

arzharch

Servers in org

Versions across org

VERSIONS

Available versions (8)

Version	Published
0.1.9	Sep 1, 2026
0.1.8	Sep 1, 2026
0.1.7	Aug 28, 2026
0.1.6	Aug 28, 2026
0.1.5	Aug 28, 2026
0.1.4	Aug 28, 2026
0.1.3	Aug 28, 2026
0.1.2	Aug 26, 2026

FAQ

Frequently asked questions

Who maintains pgops?: pgops is maintained by arzharch, which publishes 1 MCP server (8 total versions) tracked on MCP Toplist.
Is pgops listed on the Official MCP Registry?: Yes — pgops is listed on the Official MCP Registry, alongside Glama.
How many versions does pgops have?: MCP Toplist tracks 8 versions of pgops, most recently published on Sep 1, 2026.
Where can I find the source code for pgops?: The source code for pgops is hosted at github.com/arzharch/pgops-mcp.

Used in projects

Do you run this server?

Add to a project

Community projects list the MCP servers behind real agents and apps. Publish yours and this page will link to it.

EXPLORE

All MCP Servers Official MCP Servers GitHub MCP Servers Best MCP Servers Most Active MCP Servers New MCP Servers Best New MCP Servers