pgops

Overview

pgops is a Model Context Protocol server that brings safe, audited PostgreSQL operations to AI agents. It handles queries, migrations, EXPLAIN analysis, and container operations through a set of callable tools that integrate directly with your AI assistant instead of requiring manual copy-paste workflows.

The server runs locally via the Python package pgops-mcp, installed through uvx. You'll need to provide a PostgreSQL connection string through the PGOPS_DSN environment variable, along with an API key for authentication. The latest release is v0.1.7, published under the MIT license with source code available at arzharch/pgops-mcp on GitHub.

pgops is listed in the Database category on mcp.site and works with MCP clients including Claude Desktop, Claude Code, Cursor, VS Code, Windsurf, and Zed. If you maintain pgops, claim this listing to verify ownership and keep the information current.

Installation

// claude_desktop_config.json
{
  "mcpServers": {
    "pgops": {
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<pgops-dsn>"
      }
    }
  }
}

Requires PGOPS_DSN