fairdb-operations-kit
Complete operations kit for FairDB PostgreSQL as a Service - VPS setup, PostgreSQL management, customer provisioning, monitoring, and backup automation
View on GitHubTable of content
Complete operations kit for FairDB PostgreSQL as a Service - VPS setup, PostgreSQL management, customer provisioning, monitoring, and backup automation
Installation
npx claude-plugins install @jeremylongshore/claude-code-plugins-plus/fairdb-operations-kit
Contents
Folders: agents, commands, skills
Files: LICENSE, README.md
Documentation
A comprehensive Claude Code plugin suite for managing FairDB PostgreSQL as a Service operations. This plugin automates VPS provisioning, PostgreSQL management, backup configuration, customer onboarding, and monitoring workflows.
Overview
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
Installation
/plugin install fairdb-operations-kit@claude-code-plugins-plus
Commands
Infrastructure Setup
/fairdb-provision-vps- Complete VPS setup with security hardening (implements SOP-001)/fairdb-install-postgres- Install and configure PostgreSQL 16 for production (implements SOP-002)/fairdb-setup-backup- Configure pgBackRest with Wasabi S3 storage (implements SOP-003)
Customer Management
/fairdb-onboard-customer- Complete customer provisioning workflow- Creates database and users
- Configures network access
- Sets up backups
- Generates SSL certificates
- Provides connection documentation
Operations & Monitoring
/fairdb-health-check- Comprehensive system health verification- Server resources check
- Database performance metrics
- Backup status verification
- Security audit
/fairdb-emergency-response- Critical incident response procedures- Service recovery
- Data integrity checks
- Performance triage
- Root cause analysis
Agent Capabilities
The fairdb-automation-agent provides intelligent automation for:
- Proactive Monitoring: Continuous analysis and prediction of issues
- Automated Problem Resolution: Pattern-based diagnosis and fixes
- Resource Optimization: Dynamic parameter tuning and workload balancing
- Automated Operations: Routine maintenance and backup management
Skills
FairDB Backup Manager
An Agent Skill that automatically activates when working with backups:
- Manages pgBackRest configurations
- Executes scheduled backups
- Performs test restores
- Monitors backup health
- Optimizes storage costs
Architecture
FairDB Infrastructure Stack
├── Contabo VPS
│ ├── Ubuntu 24.04 LTS
│ ├── PostgreSQL 16
│ ├── pgBackRest
│ └── Monitoring (Prometheus/Grafana)
├── Wasabi S3 Storage
│ ├── Full backups (weekly)
│ ├── Differential backups (daily)
│ └── WAL archives (continuous)
└── Security Layer
├── UFW Firewall
├── Fail2ban IPS
├── SSL/TLS encryption
└── Key-based SSH
Standard Operating Procedures
This plugin implements three core SOPs:
SOP-001: VPS Hardening
- OS security updates
- Firewall configuration (UFW)
- Intrusion prevention (Fail2ban)
- SSH hardening
- Monitoring setup
SOP-002: PostgreSQL Installation
- PostgreSQL 16 from official repos
- Production configuration tuning
- SSL certificate generation
- User and permission management
- Performance optimization
SOP-003: Backup Configuration
- pgBackRest installation
- Wasabi S3 integration
- Retention policy setup
- Automated scheduling
- Recovery testing
Configuration
Required environment variables:
# Contabo API
CONTABO_API_KEY=<your-api-key>
# Wasabi S3
WASABI_ACCESS_KEY=<access-key>
WASABI_SECRET_KEY=<secret-key>
WASABI_BUCKET=<bucket-name>
WASABI_ENDPOINT=<region-endpoint>
# PostgreSQL
FAIRDB_ADMIN_USER=<admin-username>
FAIRDB_ADMIN_PASS=<admin-password>
# Monitoring
FAIRDB_MONITORING_WEBHOOK=<webhook-url>
Usage Examples
Complete New Customer Setup
User: "I need to onboard Acme Corp as a new FairDB customer"
Claude: I'll help you onboard Acme Corp. Let me use the fairdb-onboard-customer command...
[Executes complete workflow]:
✅ Database created: acme_corp_db
✅ Users created with secure passwords
✅ Network access configured for customer IPs
✅ Backups scheduled (daily at 3 AM)
✅ SSL certificates generated
✅ Monitoring enabled
✅ Connection documentation generated
Customer can now connect using:
postgresql://acme_corp_user:<password>@fairdb.example.com:5432/acme_corp_db?sslmode=require
Emergency Response
User: "Critical: customers reporting connection failures!"
Claude: Initiating emergency response with fairdb-emergency-response...
[STEP 1] SERVICE STATUS CHECK
❌ CRITICAL: PostgreSQL is DOWN
Attempting emergency restart...
✅ PostgreSQL restarted successfully
[STEP 2] CONNECTION DIAGNOSTI
...(truncated)
## Included Skills
This plugin includes 1 skill definition:
### fairdb-backup-manager
> |
<details>
<summary>View skill definition</summary>
# Fairdb Backup Manager
This skill provides automated assistance for fairdb backup manager tasks.
## Prerequisites
Before using this skill, ensure:
- Required credentials and permissions for the operations
- Understanding of the system architecture and dependencies
- Backup of critical data before making structural changes
- Access to relevant documentation and configuration files
- Monitoring tools configured for observability
- Development or staging environment available for testing
## Instructions
### Step 1: Assess Current State
1. Review current configuration, setup, and baseline metrics
2. Identify specific requirements, goals, and constraints
3. Document existing patterns, issues, and pain points
4. Analyze dependencies and integration points
5. Validate all prerequisites are met before proceeding
### Step 2: Design Solution
1. Define optimal approach based on best practices
2. Create detailed implementation plan with clear steps
3. Identify potential risks and mitigation strategies
4. Document expected outcomes and success criteria
5. Review plan with team or stakeholders if needed
### Step 3: Implement Changes
1. Execute implementation in non-production environment first
2. Verify changes work as expected with thorough testing
3. Monitor for any issues, errors, or performance impacts
4. Document all changes, decisions, and configurations
5. Prepare rollback plan and recovery procedures
### Step 4: Validate Implementation
1. Run comprehensive tests to verify
...(truncated)
</details>
## Source
[View on GitHub](https://github.com/jeremylongshore/claude-code-plugins-plus-skills)