# pgops

> pgops is an open-source MCP server. Safe, audited PostgreSQL operations for AI agents: queries, migrations, EXPLAIN, containers. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Repository:** https://github.com/arzharch/pgops-mcp
- **MCP Registry name:** io.github.arzharch/pgops-mcp
- **Listing updated:** 2026-11-13

## About

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

## Install

### Claude Code (Terminal)

```sh
claude mcp add pgops-mcp --env PGOPS_DSN='<PGOPS_DSN>' --env PGOPS_READONLY_DSN='<PGOPS_READONLY_DSN>' -- uvx pgops-mcp
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<PGOPS_DSN>",
        "PGOPS_READONLY_DSN": "<PGOPS_READONLY_DSN>"
      }
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<PGOPS_DSN>",
        "PGOPS_READONLY_DSN": "<PGOPS_READONLY_DSN>"
      }
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "pgops-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<PGOPS_DSN>",
        "PGOPS_READONLY_DSN": "<PGOPS_READONLY_DSN>"
      }
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<PGOPS_DSN>",
        "PGOPS_READONLY_DSN": "<PGOPS_READONLY_DSN>"
      }
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "pgops-mcp": {
      "command": "uvx",
      "args": [
        "pgops-mcp"
      ],
      "env": {
        "PGOPS_DSN": "<PGOPS_DSN>",
        "PGOPS_READONLY_DSN": "<PGOPS_READONLY_DSN>"
      }
    }
  }
}
```

## FAQ

### Is pgops free?

Yes. pgops is open source, so you can use and self-host it for free.

### How do I add pgops to Claude Code?

Run this command in your terminal: claude mcp add pgops-mcp --env PGOPS_DSN='<PGOPS_DSN>' --env PGOPS_READONLY_DSN='<PGOPS_READONLY_DSN>' -- uvx pgops-mcp

---
Source: https://ai-powered.com/mcp/pgops
