skills.rest
DevOtts
DevOttsCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

vps-maintenance

Install recurring VPS housekeeping scripts for Postgres backups, Docker cleanup, and memory alerts.

4|Updated Jun 27, 2025
Search Tags:#docker#vps#cron automation#postgres backups#db retention#memory alerting#slack telegram
One-click install
npx skills add https://github.com/DevOtts/all-skills-you-will-ever-need --skill vps-maintenance
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: vps-maintenance
Source: https://github.com/DevOtts/all-skills-you-will-ever-need/tree/main/.claude/vps-maintenance
Command: npx skills add https://github.com/DevOtts/all-skills-you-will-ever-need --skill vps-maintenance

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about vps-maintenance

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Postgres backups on a Docker VPS?▼

Automating Postgres backups on a Docker VPS involves scheduling daily logical dumps using pg_dumpall and retaining them in a directory like /var/backups/postgres/. This housekeeping pack installs that exact recurring backup process while preserving existing crontab entries.

What is the best way to clean up Docker disk bloat on a single-node VPS?▼

Cleaning up Docker disk bloat on a single-node VPS requires pruning stopped containers and removing dangling images and unused networks. This automated housekeeping pack runs weekly Docker cleanup without touching volumes or running containers.

Can I send low-memory alerts from my Linux VPS to Slack or Telegram?▼

You can send low-memory alerts from your Linux VPS to Slack or Telegram by checking MemAvailable and triggering a webhook or message. This housekeeping pack installs a 5-minute memory pressure monitor with built-in debouncing to reduce alert noise.

How do I delete old database rows and run VACUUM ANALYZE on a Postgres container?▼

Deleting old database rows and running VACUUM ANALYZE on a Postgres container reduces bloat after removing outdated application data. This pack automates weekly database retention cleanup for detected schemas and executes the bloat reduction process.

Does this VPS maintenance automation work with my existing cron jobs?▼

Yes, VPS maintenance automation works with existing cron jobs by using idempotent installation that deduplicates new cron scheduling entries. The installation process carefully preserves your other user crontab lines when deploying the housekeeping scripts.

Related Skills

Explore More Software Engineering Skills→
VMRam95VMRam95

moltbot-vps

Manage Docker-based OpenClaw gateway services on remote Linux VPS infrastructure.

Community
Advanced
FlexasaurusrexFlexasaurusrex
16

syswhisper

Monitor server CPU, memory, and disk usage with Telegram alerts.

Community
Intermediate
edulazaroedulazaro
12

lc:orphaned-records

Detect and remediate orphaned database records in Laravel environments.

Community
Advanced
NightreaverNightreaver
6

ssh-docker-system-df

Summarize Docker disk usage across images, containers, volumes, and build cache.

Community
Intermediate