Migrate per-app CNPG clusters to a central Postgres cluster via Crossplane AppDBClaim.
npx skills add https://github.com/timosur/homelab --skill cnpg-migration
Please help me install this Agent Skill. Skill: cnpg-migration Source: https://github.com/timosur/homelab/tree/main/.github/skills/cnpg-migration Command: npx skills add https://github.com/timosur/homelab --skill cnpg-migration
This Skill enables consolidating per-app CNPG databases into a single central Postgres instance using Crossplane AppDBClaim, reducing operational overhead and keeping credentials centralized.
Create an AppDBClaim in the app's namespace and update deployments to reference the Crossplane-provisioned database secret.
High-intent search queries and answers about installing and using this skill.
To migrate a per-app CNPG cluster to central Postgres, create a Crossplane AppDBClaim to provision the database, update app deployments to consume the new Crossplane secrets, optionally migrate data, and then clean up the old CNPG resources.
A Crossplane AppDBClaim is used for self-service provisioning of app-specific databases and credentials on a central Postgres cluster, enabling the consolidation of per-app CNPG databases and reducing operational overhead.
Update app configurations to reference Crossplane secrets by adjusting deployment methods like envFrom, env variables, ExternalSecret, or Helm values to point to the newly provisioned database credentials instead of per-app CNPG resources.
Yes, data migration is an optional phase when moving to central shared Postgres, following AppDBClaim creation and app configuration updates, allowing you to transfer existing data before cleaning up the original CNPG cluster.
The Crossplane AppDBClaim migration process defines specific naming rules for appName, databaseName, and roleName to ensure consistent provisioning and binding of app-specific databases on the central Postgres cluster.
The central Postgres endpoint used for Crossplane AppDBClaim migration is central-postgres-rw.postgres.svc.cluster.local, which serves as the target shared cluster for consolidating per-app CNPG databases.
timosurGenerate Kubernetes manifests, ArgoCD Applications, HTTPRoutes, ExternalSecrets, and Crossplane AppDB provisions.
david-driscollProvision CNPG PostgreSQL clusters and replicate app credentials in Kubernetes.
MehakanisManage Kubernetes deployments with Helm charts for multi-component applications.
vanducngAutomate CNPG Postgres cluster provisioning on Kubernetes via GitOps.
