postgres-adminlisted

PostgreSQL server administration for kodemeio infrastructure via kctl-pg CLI. MUST use before ANY kctl-pg command or PostgreSQL admin task. Triggers on: "kctl-pg", "database backup", "create database", "postgres role", "db health", "pg stats", "database size", "restore database", "postgres user", "connection pool", or ANY PostgreSQL administration task. Even if the user just says "check db health" or "create a new database" — use this skill.
tgunawandev/kodemeio-platform · ★ 0 · API & Backend · score 65

Install: claude install-skill tgunawandev/kodemeio-platform

# PostgreSQL Administration for Kodemeio ## System Overview - **PostgreSQL 16.12** at `db.kodeme.io` (Hetzner private network `10.0.0.3`) - **PostGIS 3.5** (Alpine-based custom Docker image) - **PgBouncer** for transaction-level connection pooling (port 6432) - **postgres-exporter** for Prometheus metrics (port 9187) - **Deployed**: Dokploy on `dokploy.kodeme.io` with `dokploy-network` - **SSH access**: `root@db.kodeme.io` (public IP: 49.13.14.79) - **Connection**: SSH tunnel -> Docker port mapping -> PostgreSQL container ## Production Databases | Database | Owner | Size | Purpose | |---|---|---|---| | authentik | authentik | 87 MB | Identity provider (auth.kodeme.io) | | zulip | zulip | 58 MB | Team chat (zulip.kodeme.io) | | glitchtip | glitchtip | 53 MB | Error tracking (glitchtip.kodeme.io) | | hmdm | hmdm | 50 MB | Mobile device management | | outline | outline | 49 MB | Wiki/docs (outline.kodeme.io) | | gatus | gatus | 48 MB | Uptime monitoring (gatus.kodeme.io) | | plane | plane | 23 MB | Project management (plane.kodeme.io) | | postgres | postgres | 16 MB | Default/admin database | ## Production Roles | Role | Flags | Purpose | |---|---|---| | postgres | SLCRP | Superuser (admin) | | app | L | Generic application user | | authentik | L | Authentik service (conn limit: 50) | | zulip | L | Zulip service | | outline | L | Outline service | | gatus | L | Gatus service | | glitchtip | L | GlitchTip service | | hmdm | L | Headwind MDM service | | plane | L | Plane ser