Percona Pg MCP server

mcp-percona-pg

A Model Context Protocol server for the Percona Operator for PostgreSQL. It lets an MCP-capable client (Claude Desktop, Claude Code, Cursor, …) operate PostgreSQL + PgBouncer clusters on Kubernetes — topology, connection pooling, tuning, backups/PITR, DR, extensions, and lifecycle — with behaviour controlled entirely by flags.

It drives the operator's custom resources (PerconaPGCluster, PerconaPGBackup, PerconaPGRestore, PerconaPGUpgrade) through your kube-config, so the model works the way you already do: "scale dev-pg to 3 replicas", "switch pooling to transaction mode", "restore prod-pg to 12:00 UTC".

Safe by default: it starts read-only, can be scoped to an allowlist of namespaces and clusters, protects critical clusters from mutation, gates restore / upgrade / delete behind separate opt-ins, and requires typed confirmation for high-impact actions. It never reads or returns database credentials.

Features

• Discovery & status — list clusters, per-cluster summary and raw .status (Patroni members, PostgreSQL/PgBouncer readiness), connection endpoints, backups and restores.
• Connection pooling — read and update PgBouncer poolmode and the global pool tunables (defaultpoolsize, maxclient_conn, …).
• PostgreSQL tuning — read/merge parameters via spec.patroni.dynamicConfiguration (the only Patroni-safe path).
• Lifecycle — scale PostgreSQL/PgBouncer, pause/resume, toggle built-in extensions, on-demand backups.
• DR & recovery — restore / point-in-time recovery, promote a standby, major-version upgrades — each individually gated.

Security model

Tools

Read (read-only+): listcontexts, listclusters, getcluster, getclusterstatus, getconnectioninfo, getpgbouncerconfig, getpgparameters, listbackups, list_restores

Write (read-write+): scalecluster, setpgbouncerconfig, setpgparameters, pausecluster, togglebuiltinextension, create_backup

Admin (admin): restorecluster (needs PERCONAALLOWRESTORE), upgradecluster (needs PERCONAALLOWUPGRADE), promotestandby, deletebackup / deletecluster (need PERCONAALLOW_DELETE)

Quickstart — add to your agent

Shortened. The full README is on GitHub.