fairdb-operations-kit
Complete operations kit for FairDB PostgreSQL as a Service - VPS setup, PostgreSQL management, customer provisioning, monitoring, and backup automation
Installation
Open Claude Code and run this command:
/plugin install fairdb-operations-kit@claude-code-plugins-plus
Use --global to install for all projects, or --project for current project only.
What It Does
FairDB is a managed PostgreSQL-as-a-Service platform built on Contabo VPS infrastructure with pgBackRest backups to Wasabi S3 storage. This plugin kit provides Claude with the ability to execute complex operational tasks through natural language commands.
Features
- VPS Provisioning: Automated Contabo VPS setup with security hardening
- PostgreSQL Management: Install, configure, and optimize PostgreSQL 16
- Backup System: pgBackRest configuration with Wasabi S3 integration
- Customer Provisioning: Automated database and user creation workflows
- Monitoring: Health checks, performance monitoring, and alerting
- Incident Response: Guided troubleshooting and recovery procedures
- Intelligent Automation: AI-powered agent for proactive management
Skills (1) plugin-local skills
fairdb-backup-manager
View full skill →
Manage use when you need to work with backup and recovery.
ReadWriteEditGrepGlobBash(tar:*)Bash(rsync:*)Bash(aws:s3:*)
FAQ
PostgreSQL Won't Start
sudo journalctl -u postgresql -n 50
sudo -u postgres pg_ctl -D /var/lib/postgresql/16/main status
sudo netstat -tulpn | grep 5432
Backup Failures
sudo -u postgres pgbackrest --stanza=fairdb check
aws s3 ls s3://bucket --endpoint-url=https://s3.wasabisys.com
tail -f /var/log/pgbackrest/fairdb-backup.log
High Connection Usage
sudo -u postgres psql -c "SELECT * FROM pg_stat_activity;"
sudo -u postgres psql -c "SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE state = 'idle' AND state_change < NOW() - INTERVAL '10 minutes';"