Provision per-service Postgres databases on a Hetzbot host.
npx skills add https://github.com/tomspiegl/hetzbot --skill hetzbot-postgres
Please help me install this Agent Skill. Skill: hetzbot-postgres Source: https://github.com/tomspiegl/hetzbot/tree/main/skills/infra/postgres Command: npx skills add https://github.com/tomspiegl/hetzbot --skill hetzbot-postgres
This skill enables teams to run a shared Postgres instance on a Hetzbot host, provisioning per-service databases and credentials automatically, while providing rotation, backups, and operational hooks.
Provision a new per-service database by running install.sh <service> on the host where Postgres is deployed.
High-intent search queries and answers about installing and using this skill.
To provision a per-service Postgres database, run the install.sh script with the target service name on the host. This automatically creates the database, sets up roles, and generates a .env file containing the connection string.
Automating password rotation for multiple Postgres databases is handled through built-in scripts that update credentials across per-service roles. This ensures secure, non-root credential management without manual intervention.
Yes, this Postgres provisioning approach supports Docker Compose by deploying a Postgres 16 stack. The setup binds to localhost, executes as a non-root user, and includes secure health checks.
Database backups for shared Postgres instances are executed through provided automation scripts integrated into the fleet deploy workflow. This allows you to back up multiple per-service databases running on the same host.
Yes, you can run multiple services with separate databases on a single Postgres instance. The system provisions per-service databases and roles on demand, generating individual .env files with unique connection strings for each service.
You need a shared Postgres instance when managing multiple services on the same host that require automated credential rotation and centralized backups. This approach reduces overhead while maintaining per-service database isolation.
madsnorgaardAutomate local Drupal Docker Compose environments with standardized service patterns.
tomspieglVerify fleet health across hosts via SSH, containers, restic backups, and Postgres.
open-haxOrchestrate up, down, restart, ps, and logs workflows for Docker Compose stacks.
MapleTechLabsAutomate ClickHouse deployment to managed ClickHouse Cloud services.
