Fairdb Ops Manager

Comprehensive operations toolkit for managing FairDB managed PostgreSQL infrastructure

A Claude Code plugin that provides guided SOPs, incident response procedures, monitoring tools, and automation scripts for running a production-grade managed PostgreSQL service.

What is This?

FairDB Operations Manager is your complete operational toolkit for managing a fleet of PostgreSQL database servers. Whether you're setting up your first VPS or responding to a production incident, this plugin provides:

• Step-by-step SOP guides for setup and configuration
• Autonomous agents for incident response and auditing
• Shell scripts for health monitoring and backup management
• Best practices from production database operations

Perfect for solo operators, small teams, or anyone running managed PostgreSQL services.

Features

📚 Standard Operating Procedures (SOPs)

Detailed, beginner-friendly guides for:

• SOP-001: VPS Initial Setup & Hardening (60 min)
• System updates and user configuration
• SSH hardening with key authentication
• Firewall (UFW) and Fail2ban setup
• Automatic security updates
• Complete security verification

• SOP-002: PostgreSQL 16 Installation & Configuration (90 min)
• PostgreSQL 16 installation
• SSL/TLS encryption
• Performance tuning for available RAM
• pg_stat_statements monitoring
• Health check automation

• SOP-003: Backup System Setup & Verification (120 min)
• pgBackRest configuration with Wasabi S3
• AES-256 encryption
• Automated daily/weekly backups
• Backup restoration testing (critical!)
• Weekly verification automation

🤖 Autonomous Agents

Intelligent assistants that handle complex multi-step operations:

• fairdb-setup-wizard: Complete guided setup from bare VPS to production-ready
• fairdb-incident-responder: Autonomous incident response with diagnosis and recovery
• fairdb-ops-auditor: Compliance auditing with detailed remediation plans

🛠️ Operational Commands

Quick-access commands for daily operations:

• /sop-001-vps-setup - VPS hardening guide
• /sop-002-postgres-install - PostgreSQL setup guide
• /sop-003-backup-setup - Backup configuration guide
• /daily-health-check - Morning health check routine
• /incident-p0-database-down - Database down emergency response
• /incident-p0-disk-full - Disk space emergency procedures

📊 Shell Scripts (Deploy to VPS)

Production-ready scripts for server deployment:

• pg-health-check.sh - Automated PostgreSQL health monitoring
• backup-status.sh - Visual backup status dashboard
• sop-checklist.sh - Interactive SOP completion verification

Installation

From Your Private Repository

Since this is your personal plugin:

# Clone the repository locally if not already
git clone https://github.com/jeremylongshore/claude-code-plugins.git
cd claude-code-plugins

# Install the plugin directly from the local path
/plugin install ./plugins/community/fairdb-ops-manager

Or add as local marketplace:

# Create symbolic link to your plugin
/plugin marketplace add /path/to/claude-code-plugins

# Install the plugin
/plugin install fairdb-ops-manager@claude-code-plugins

Quick Start

1. First Time Setup (New VPS)

Use the complete setup wizard for automated guidance:

# Launch the setup wizard agent
/agent fairdb-setup-wizard

The wizard will guide you through:

1. VPS hardening (SOP-001)
2. PostgreSQL installation (SOP-002)
3. Backup configuration (SOP-003)

Total time: 3-4 hours

2. Manual Step-by-Step Setup

If you prefer manual control:

# Step 1: Harden your VPS
/sop-001-vps-setup

# Step 2: Install PostgreSQL
/sop-002-postgres-install

# Step 3: Configure backups
/sop-003-backup-setup

3. Deploy Helper Scripts to VPS

Once your VPS is set up, deploy the monitoring scripts:

# SSH to your VPS
ssh admin@your-vps-ip -p 2222

# Create scripts directory (if not exists)
sudo mkdir -p /opt/fairdb/scripts

# Copy scripts from plugin directory
# (Transfer via scp, rsync, or copy-paste)

# Make scripts executable
sudo chmod +x /opt/fairdb/scripts/*.sh

# Schedule health checks
crontab -e
# Add: */5 * * * * /opt/fairdb/scripts/pg-health-check.sh

Daily Operations

Morning Health Check

# Run guided health check
/daily-health-check

# Or on VPS directly:
ssh your-vps
/opt/fairdb/scripts/pg-health-check.sh