skills.rest
ionfury
ionfuryCOMMUNITY
Explore all skills by this author →
GitHub

cnpg-database

Provision and manage PostgreSQL databases in Kubernetes with CNPG clusters.

24|3|Updated Mar 31, 2022
Search Tags:#database#postgresql#kubernetes#replication#pgbouncer#cnpg
One-click install
npx skills add https://github.com/ionfury/homelab --skill cnpg-database
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cnpg-database
Source: https://github.com/ionfury/homelab/tree/main/.claude/skills/cnpg-database
Command: npx skills add https://github.com/ionfury/homelab --skill cnpg-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

CNPG Database Management helps operators provision and manage PostgreSQL databases in a Kubernetes homelab, supporting both shared platform clusters and dedicated app clusters for isolation and scale.

Core Features & Use Cases

  • Shared platform cluster provisioning and governance for multi-tenant apps
  • Dedicated CNPG clusters for apps needing extensions, isolation, or custom configurations
  • Credential replication, monitoring, and network policy integration to secure access

Quick Start

Deploy CNPG on your Kubernetes cluster and begin provisioning databases for your apps using the shared platform cluster or dedicated clusters.

Frequently Asked Questions about cnpg-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I provision a PostgreSQL database in Kubernetes using CNPG?▼

Provisioning a PostgreSQL database in Kubernetes with CNPG involves setting up a shared platform cluster or dedicated app cluster, applying initdb configurations, and configuring extensions for workload isolation.

What is the difference between a shared platform cluster and a dedicated CNPG cluster?▼

A shared platform cluster provides multi-tenant database governance, while a dedicated CNPG cluster isolates workloads by offering custom configurations, bootstrap with initdb, and specific PostgreSQL extensions per app.

How do I set up PgBouncer connection pooling for PostgreSQL in Kubernetes?▼

PgBouncer connection pooling for PostgreSQL in Kubernetes is configured within a dedicated CNPG cluster to isolate workloads and manage pooled connections, ensuring efficient database access for applications.

Does CNPG support Prometheus monitoring and network policies for PostgreSQL clusters?▼

CNPG supports Prometheus monitoring and network policy integration for PostgreSQL clusters, ensuring secure access and observability for both shared platform and dedicated app database deployments in Kubernetes.

How do I configure credential replication for PostgreSQL in Kubernetes?▼

Configuring credential replication for PostgreSQL in Kubernetes requires setting up replication credentials within the CNPG cluster definition, ensuring database access is synchronized across instances for reliable operations.

When should I use a dedicated CNPG cluster instead of a shared PostgreSQL cluster?▼

Use a dedicated CNPG cluster when applications need specific PostgreSQL extensions, workload isolation, or custom configurations, whereas a shared cluster suits general multi-tenant database provisioning needs.

Related Skills

Explore More Software Engineering Skills→
salmanparachasalmanparacha

deploying-postgres-k8s

Deploy PostgreSQL clusters on Kubernetes with CloudNativePG and automated failover.

Community
Advanced
HeldinhowHeldinhow
4

prometheus-monitoring

Implement Prometheus metrics collection and scrape configuration for application monitoring.

Community
Intermediate
TwuanMinnTwuanMinn

neon-postgres

Configure Prisma and Drizzle with Neon serverless Postgres pooling and migrations.

Community
Advanced
dieu-donneedieu-donnee

kubernetes-specialist

Deploy Kubernetes workloads with declarative manifests, RBAC, and network policies.

Community
Advanced