vps-maintenance

What problem does it solve?

This Skill prevents long-lived single-node Docker VPSs from failing due to low-memory incidents, silent disk bloat, and unbounded Postgres growth that eventually breaks backups and performance.

Core Features & Use Cases

• Daily Postgres logical backups: runs pg_dumpall and retains backups for a configurable number of days in /var/backups/postgres/.
• Weekly Docker cleanup: prunes stopped containers and removes unused/dangling images and unused networks without touching volumes or running containers.
• Weekly DB retention cleanup: deletes old application rows (based on detected n8n or Evolution schemas) and runs VACUUM ANALYZE to reduce bloat after deletions.
• 5-minute memory pressure alert: checks MemAvailable and sends a Slack webhook or Telegram message, with built-in debouncing to reduce noise.
• Idempotent installation: re-runs overwrite scripts and deduplicate cron entries while preserving other user crontab lines.

Quick Start

Ask your AI to set up vps-maintenance on your Docker VPS by installing the housekeeping scripts and configuring your Slack or Telegram memory alert with the desired thresholds and retention windows.