CloudNativePG

An MCP Server for the Cloud Native PG Controller

python

1

GitHub Stars

python

Language

6 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "wateim-cnpg-mcp": {
      "command": "cnpg-mcp-server",
      "args": [],
      "env": {
        "KUBECONFIG": "/path/to/.kube/config"
      }
    }
  }
}

Available tools

list_postgres_clusters

List all PostgreSQL clusters across namespaces with optional detail levels and output format (text or json) for programmatic consumption.

get_cluster_status

Get detailed status for a specific cluster, including health and readiness information, with support for concise or detailed output and json formatting.

create_postgres_cluster

Create a new highly available PostgreSQL cluster with configurable instances, storage, and version, with options to wait for readiness and perform a dry run.

scale_postgres_cluster

Scale the number of PostgreSQL instances in a cluster within defined bounds to match workload changes.

delete_postgres_cluster

Delete a PostgreSQL cluster and automatically clean up associated secrets, with a safety confirmation step.

list_postgres_roles

List all PostgreSQL roles/users managed within a cluster, with optional json output for structured data.

create_postgres_role

Create a new PostgreSQL role with login and privilege options, automatically generating and storing a password in a Kubernetes secret.

update_postgres_role

Update attributes of an existing role, including login, privileges, and password management.

delete_postgres_role

Delete a role from a cluster and remove the associated Kubernetes secret.

list_postgres_databases

List all databases managed by the Database CRD for a cluster with optional json output.

create_postgres_database

Create a new database owned by a specified role using the Database CRD, with selectable reclaim policy.

delete_postgres_database

Delete a database by removing its Database CRD, with behavior dependent on the reclaim policy.