cosmic-mcp

All servers

pgops

io.github.arzharch/pgops-mcp ยท version 0.1.9

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

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

https://github.com/arzharch/pgops-mcp

Quick facts

  • Listing: Community
  • Published Sep 1, 16:36 UTC
  • Transport: stdio
  • Package: pypi pgops-mcp 0.1.9
  • Listed by cosmic-mcp: Nov 9, 04:25 UTC

Databases

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 (pypi)

uvx 'pgops-mcp==0.1.9'

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "pgops-mcp": {
      "args": [
        "pgops-mcp==0.1.9"
      ],
      "command": "uvx",
      "env": {
        "PGOPS_APPROVAL_MODE": "<your pgops approval mode>",
        "PGOPS_AUDIT_LOG": "<your pgops audit log>",
        "PGOPS_DEFAULT_ROW_LIMIT": "<your pgops default row limit>",
        "PGOPS_DEFAULT_TIMEOUT_MS": "<your pgops default timeout ms>",
        "PGOPS_DSN": "<your pgops dsn>",
        "PGOPS_MAX_TIMEOUT_MS": "<your pgops max timeout ms>",
        "PGOPS_READONLY_DSN": "<your pgops readonly dsn>",
        "PGOPS_READ_ONLY": "<your pgops read only>"
      }
    }
  }
}

Claude Code

claude mcp add 'pgops-mcp' -- uvx 'pgops-mcp==0.1.9'

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "pgops-mcp": {
      "args": [
        "pgops-mcp==0.1.9"
      ],
      "command": "uvx",
      "env": {
        "PGOPS_APPROVAL_MODE": "<your pgops approval mode>",
        "PGOPS_AUDIT_LOG": "<your pgops audit log>",
        "PGOPS_DEFAULT_ROW_LIMIT": "<your pgops default row limit>",
        "PGOPS_DEFAULT_TIMEOUT_MS": "<your pgops default timeout ms>",
        "PGOPS_DSN": "<your pgops dsn>",
        "PGOPS_MAX_TIMEOUT_MS": "<your pgops max timeout ms>",
        "PGOPS_READONLY_DSN": "<your pgops readonly dsn>",
        "PGOPS_READ_ONLY": "<your pgops read only>"
      }
    }
  }
}

VS Code (.vscode/mcp.json)

{
  "servers": {
    "pgops-mcp": {
      "args": [
        "pgops-mcp==0.1.9"
      ],
      "command": "uvx",
      "env": {
        "PGOPS_APPROVAL_MODE": "<your pgops approval mode>",
        "PGOPS_AUDIT_LOG": "<your pgops audit log>",
        "PGOPS_DEFAULT_ROW_LIMIT": "<your pgops default row limit>",
        "PGOPS_DEFAULT_TIMEOUT_MS": "<your pgops default timeout ms>",
        "PGOPS_DSN": "<your pgops dsn>",
        "PGOPS_MAX_TIMEOUT_MS": "<your pgops max timeout ms>",
        "PGOPS_READONLY_DSN": "<your pgops readonly dsn>",
        "PGOPS_READ_ONLY": "<your pgops read only>"
      },
      "type": "stdio"
    }
  }
}

Related servers

  • spotdb Verified domain
    Ephemeral data sandbox for AI workflows with guardrails and security
  • Reasonbook Verified domain
    Reasonbook: decisions that survive the session, in a local record AI agents keep.
  • AI for Database Verified domain
    Ask your databases questions in plain English, run read-only SQL and set up data alerts.
  • 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.
  • APC Security Reference Server
    Reference MCP server for synthetic APC action-security evaluation and local SQLite sandbox testin...