Skip to content
Agentmart
Submit a tool

MCP Percona Pg

Manage Percona PostgreSQL + PgBouncer on Kubernetes — safe-by-default access modes and guards.

Connector by dockndevai · GitHub account verified by the MCP Registry

IndexedMITLocal (stdio)★ 1
Write a review

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/dockndevai-mcp-percona-pg

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

We use your email only for this newsletter. Privacy

About

Manage Percona PostgreSQL + PgBouncer on Kubernetes — safe-by-default access modes and guards.

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list, install config and code. Checked Oct 26, 2026.

Tools
9 read · 8 write · 2 delete · 1 not yet classified
Secrets
None asked for
Install scripts
None found
Runs as
Node.js package

Tools by what they do 20

Read from the source code; the running server may list different tools.

Read 9 · Look things up without changing anything.

  • get_cluster
  • get_cluster_status
  • get_connection_info
  • get_pg_parameters
  • get_pgbouncer_config
  • list_backups
  • list_clusters
  • list_contexts
  • list_restores

Write 8 · Create, change, send or run things.

  • create_backup
  • pause_cluster
  • restore_cluster
  • scale_cluster
  • set_pg_parameters
  • set_pgbouncer_config
  • toggle_builtin_extension
  • upgrade_cluster

Delete 2 · Delete, drop, revoke or wipe things.

  • delete_backup
  • delete_cluster

Not yet classified 1 · We could not tell from the name and description.

  • promote_standby

Secrets and settings it asks for

Other settings (environment variables or headers).

  • KUBECONFIG_PATH
  • PERCONA_MODE
  • PERCONA_NAMESPACE

Network hosts it talks to 2

  • github.com · found in code
  • glama.ai · found in code

Tools (20)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

  • create_backupCreate an on-demand backup

    Create a PerconaPGBackup for a cluster (pgBackRest). repoName selects the configured repo (e.g. repo1 = PVC, repo2 = S3). type maps to a pgBackRest --type option.

  • delete_backupDelete a backup

    Delete a PerconaPGBackup resource. Requires admin mode AND PERCONA_ALLOW_DELETE=true. Irreversible.

  • delete_clusterDelete a cluster

    Delete a PerconaPGCluster. Requires admin mode AND PERCONA_ALLOW_DELETE=true, and confirmation. Protected clusters are refused. Irreversible — deletes PostgreSQL, PgBouncer, and (per finalizers) data.

  • get_clusterGet cluster (summary)

    Summary of a PerconaPGCluster: state, PostgreSQL size, PgBouncer, version, standby, host.

  • get_cluster_statusGet cluster status (raw)

    The full `.status` of a PerconaPGCluster — Patroni members, PostgreSQL/PgBouncer readiness, host, and conditions.

  • get_connection_infoGet connection info

    Connection endpoints for a cluster: the primary/replica Service hosts, port, and the declared users (names only — passwords live in Secrets and are never returned).

  • get_pg_parametersGet PostgreSQL parameters

    The tuned PostgreSQL parameters from `spec.patroni.dynamicConfiguration.postgresql.parameters` (the only correct place to set them — direct postgresql.conf edits are reverted by Patroni).

  • get_pgbouncer_configGet PgBouncer config

    The PgBouncer settings for a cluster: replicas, pool_mode, and the global pool tunables.

  • list_backupsList backups

    List PerconaPGBackup resources in a namespace, with their state, repo, and completion time.

  • list_clustersList PostgreSQL clusters

    List PerconaPGCluster resources (PostgreSQL + PgBouncer). Omit `namespace` to list across all namespaces. Results are filtered by the namespace/cluster allowlists; protected clusters are flagged.

  • list_contextsList kube-config contexts

    List the contexts (clusters) available in the loaded kube-config.

  • list_restoresList restores

    List PerconaPGRestore resources in a namespace, with their target cluster and state.

  • pause_clusterPause / resume a cluster

    Set spec.pause. Pausing stops the PostgreSQL and PgBouncer pods (spec is retained) to free resources; resuming brings them back. Useful for parking a dev cluster.

  • promote_standbyPromote a standby cluster

    Promote a DR standby cluster to primary by setting spec.standby.enabled=false. The cluster stops replaying from the source repo and begins accepting writes. High-impact — requires admin mode and confirmation.

  • restore_clusterRestore / PITR a cluster

    Create a PerconaPGRestore to restore a cluster from a pgBackRest repo — optionally point-in-time. OVERWRITES the cluster's data. Requires admin mode AND PERCONA_ALLOW_RESTORE=true, and (by default) confirmation. For PITR pass type='time' and a target timestamp.

Show 5 more tools
  • scale_clusterScale a cluster

    Set the PostgreSQL instance replica count and/or the PgBouncer replica count for a cluster. PostgreSQL scaling is read-modify-write so other instance settings (resources, volumes) are preserved.

  • set_pg_parametersSet PostgreSQL parameters

    Merge PostgreSQL parameters into spec.patroni.dynamicConfiguration.postgresql.parameters (the correct, Patroni-managed path). Keys are added/overridden; set a value to null to remove it. Some parameters need a rolling restart (the operator sequences replicas before the primary).

  • set_pgbouncer_configSet PgBouncer config

    Update PgBouncer global pool settings (merged into spec.proxy.pgBouncer.config.global). Common keys: pool_mode (session|transaction|statement), default_pool_size, max_client_conn, min_pool_size, reserve_pool_size, server_idle_timeout, query_wait_timeout, max_db_connections.

  • toggle_builtin_extensionToggle a built-in extension

    Enable or disable a built-in extension via spec.extensions.builtin (pg_stat_monitor, pg_stat_statements, pg_audit, pgvector, pg_repack). Note: preload-requiring extensions also need shared_preload_libraries set (via set_pg_parameters) and a restart before CREATE EXTENSION succeeds.

  • upgrade_clusterMajor-version upgrade

    Create a PerconaPGUpgrade to perform a major PostgreSQL version upgrade (e.g. 17 → 18). Requires admin mode AND PERCONA_ALLOW_UPGRADE=true, and confirmation. You must supply the target images for the operator to use.

Signals

Stars
1
Forks
1
Open issues
3
Weekly downloads
47
Last commit
Oct 19, 2026 (9 days ago)
Last release
Oct 26, 2026 (2 days ago)
Last package publish
Sep 29, 2026 (29 days ago)

From GitHub (fetched Oct 24, 2026) and the package registry.

Details

Registry name
io.github.dockndevai/mcp-percona-pg
Version
0.3.3
Auth
No auth
Packages
npm @dockndevai/mcp-percona-pg
License
MIT
Repository
github.com/dockndevai/mcp-percona-pg
First seen
Oct 24, 2026
Last checked
Oct 26, 2026
Source
Official MCP Registrygithub-graphql

More from dockndevai

Cite this page

MCP Percona Pg. Agent Mart. https://agentmart.dev/connectors/dockndevai-mcp-percona-pg (last updated 2026-10-26)