PostgreSQL Kubernetes Standard Skill

This skill generates a complete set of Kubernetes manifests for a PostgreSQL deployment, following strict naming and network requirements.

Specifications

• Name Requirement: StatefulSet MUST be named postgre.
• Network Requirement: hostNetwork: true MUST be set in the Pod spec.
• Service Requirement: A headless service named postgre-headless MUST be created.
• Secret Requirement: A secret named postgre-secret MUST be created with a random POSTGRES_PASSWORD.
• Storage Requirement: PV/PVC MUST be managed via volumeClaimTemplates in the StatefulSet.

Implementation Guide

When triggered:

1. Determine if the user has custom storage size or image preferences.
2. Execute the generator: python ~/.agents/skills/postgre-skill/scripts/generate.py [storage] [image].
3. Provide the output YAML to the user.

Example Request

User: "幫我產生一個標準的 postgre 部署設定" Result: Displays the YAML with postgre Secret, Service, and StatefulSet with hostNetwork.