# system-infrastructure-management

> Auto-invoke when: - System management operations needed - Infrastructure health monitoring - Plugin-based system configuration - Database management (SQLite) - Network monitoring or hardening - Service orchestration

- Author: eboncorp
- Repository: eboncorp/claude-code-config
- Version: 20260130180656
- Stars: 0
- Forks: 0
- Last Updated: 2026-02-08
- Source: https://github.com/eboncorp/claude-code-config
- Web: https://mule.run/skillshub/@@eboncorp/claude-code-config~system-infrastructure-management:20260130180656

---

---
name: system-infrastructure-management
description: **Priority:** HIGH - Core system orchestration and monitoring Auto-invoke when: System management operations needed
---

# System Infrastructure Management Skill

**Version:** 1.0.0
**Last Updated:** 2025-11-17
**Auto-Invoke:** Yes - when system management, infrastructure, plugins, databases, or maintenance systems mentioned
**Priority:** HIGH - Core system orchestration and monitoring

## When to Use This Skill

Auto-invoke when:
- System management operations needed
- Infrastructure health monitoring
- Plugin-based system configuration
- Database management (SQLite)
- Network monitoring or hardening
- Service orchestration

## Infrastructure Components

### 1. Advanced System Manager

```bash
/home/dave/skippy/.advanced-system-manager/
├── system.db           # SQLite database
├── plugins/            # Plugin modules
│   ├── network_monitor/
│   └── system_hardening/
├── config/             # Configuration files
└── logs/               # Operation logs
```

**Features:**
- Plugin-based architecture
- Network monitoring
- System hardening automation
- SQLite-backed state management

### 2. Unified System Manager

```bash
/home/dave/skippy/.unified-system-manager/
├── web-system.db       # Web infrastructure DB
├── ai-maintenance-v2.db  # AI/maintenance DB
├── components/         # System components
└── configs/            # Multi-system configs
```

**Features:**
- Multi-database architecture
- Web system tracking
- AI maintenance integration
- Cross-system coordination

### 3. EbonHawk Maintenance System

```bash
/home/dave/skippy/.ebonhawk-maintenance/
├── status.json         # Current status
├── logs/               # Maintenance logs
├── updater/            # Update management
└── schedules/          # Task schedules
```

**Features:**
- JSON-based status tracking
- Automated updates
- Maintenance scheduling
- Health monitoring

### 4. Home Server Infrastructure

```bash
/home/dave/skippy/.home-server/
├── plugins/            # Server plugins
├── components/         # Infrastructure components
├── configs/            # Server configurations
├── backups/            # Config backups
└── venv/               # Python virtual environment
```

**Features:**
- Plugin architecture
- Component management
- Configuration versioning
- Isolated Python environment

## Database Operations

### SQLite Database Management

```bash
# Advanced System Manager DB
sqlite3 /home/dave/skippy/.advanced-system-manager/system.db

# Common queries
.tables                                    # List all tables
.schema table_name                         # Show table structure
SELECT * FROM plugins WHERE active=1;     # Active plugins
SELECT * FROM network_events LIMIT 10;    # Recent network events

# Backup database
sqlite3 system.db ".backup 'system_backup.db'"
```

### Unified System Manager DBs

```bash
# Web system database
sqlite3 /home/dave/skippy/.unified-system-manager/web-system.db
.tables
SELECT * FROM services WHERE status='running';

# AI maintenance database
sqlite3 /home/dave/skippy/.unified-system-manager/ai-maintenance-v2.db
.tables
SELECT * FROM maintenance_tasks WHERE completed=0;
```

## Plugin Management

### Advanced System Manager Plugins

```bash
# List installed plugins
ls -la /home/dave/skippy/.advanced-system-manager/plugins/

# Network monitor plugin
cat /home/dave/skippy/.advanced-system-manager/plugins/network_monitor/config.yaml

# System hardening plugin
cat /home/dave/skippy/.advanced-system-manager/plugins/system_hardening/rules.yaml

# Enable/disable plugin
sqlite3 /home/dave/skippy/.advanced-system-manager/system.db \
  "UPDATE plugins SET active=1 WHERE name='network_monitor';"
```

### Home Server Plugins

```bash
# List server plugins
ls -la /home/dave/skippy/.home-server/plugins/

# Check plugin status
python3 /home/dave/skippy/.home-server/plugin_manager.py --list

# Install new plugin
python3 /home/dave/skippy/.home-server/plugin_manager.py \
  --install /path/to/plugin/
```

## System Monitoring

### Network Monitoring

```bash
# Check network monitor status
cat /home/dave/skippy/.advanced-system-manager/plugins/network_monitor/status.json

# View recent network events
sqlite3 /home/dave/skippy/.advanced-system-manager/system.db \
  "SELECT timestamp, event_type, details FROM network_events ORDER BY timestamp DESC LIMIT 20;"

# Network health report
/home/dave/skippy/scripts/network/health_report.sh
```

### Service Health

```bash
# EbonHawk status check
cat /home/dave/skippy/.ebonhawk-maintenance/status.json | python3 -m json.tool

# Service monitoring (runs every 5 minutes via cron)
/home/dave/skippy/scripts/monitoring/service_check.sh

# Check all system services
systemctl list-units --type=service --state=running | grep -E "nginx|mysql|php"
```

### System Hardening Status

```bash
# View hardening rules
cat /home/dave/skippy/.advanced-system-manager/plugins/system_hardening/rules.yaml

# Check compliance
/home/dave/skippy/scripts/security/hardening_check.sh

# Security audit
/home/dave/skippy/scripts/security/system_audit.sh
```

## Configuration Management

### View Configurations

```bash
# Advanced system manager configs
ls -la /home/dave/skippy/.advanced-system-manager/config/

# Unified system manager configs
ls -la /home/dave/skippy/.unified-system-manager/configs/

# Home server configs
ls -la /home/dave/skippy/.home-server/configs/

# EbonHawk schedules
cat /home/dave/skippy/.ebonhawk-maintenance/schedules/maintenance.json
```

### Update Configurations

```bash
# Always backup before modifying
cp /path/to/config.yaml /path/to/config.yaml.bak

# Edit configuration
nano /home/dave/skippy/.advanced-system-manager/config/main.yaml

# Reload after changes
/home/dave/skippy/.advanced-system-manager/reload.sh

# Verify changes applied
/home/dave/skippy/.advanced-system-manager/status.sh
```

## Maintenance Operations

### EbonHawk Maintenance

```bash
# Check pending maintenance tasks
cat /home/dave/skippy/.ebonhawk-maintenance/status.json | \
  python3 -c "import json,sys; d=json.load(sys.stdin); print(d.get('pending_tasks', []))"

# Run maintenance update
/home/dave/skippy/.ebonhawk-maintenance/updater/run_update.sh

# View maintenance log
tail -100 /home/dave/skippy/.ebonhawk-maintenance/logs/maintenance.log

# Schedule new task
echo '{"task": "system_check", "schedule": "daily", "enabled": true}' >> \
  /home/dave/skippy/.ebonhawk-maintenance/schedules/tasks.json
```

### System Updates

```bash
# Check for updates
/home/dave/skippy/scripts/system/check_updates.sh

# Apply system updates (with backup)
/home/dave/skippy/scripts/system/apply_updates.sh --backup-first

# Verify post-update health
/home/dave/skippy/scripts/monitoring/full_health_check.sh
```

## Infrastructure Scripts

### System Management (24 categories, 186+ scripts)

```bash
/home/dave/skippy/scripts/
├── system/             # System management
├── monitoring/         # Health monitoring
├── maintenance/        # Routine maintenance
├── security/           # Security hardening
├── network/            # Network operations
├── backup/             # Backup operations
├── deployment/         # Deployment tools
├── disaster_recovery/  # Recovery procedures
└── lib/                # Shared libraries
```

### Common Operations

```bash
# System health check
/home/dave/skippy/scripts/monitoring/system_health.sh

# Disk usage report
/home/dave/skippy/scripts/system/disk_usage.sh

# Memory analysis
/home/dave/skippy/scripts/system/memory_analysis.sh

# Process monitoring
/home/dave/skippy/scripts/monitoring/process_monitor.sh
```

## Development Environment

### NexusController

```bash
/home/dave/skippy/app-to-deploy/NexusController/
# Multi-function deployment system
# Service orchestration
# Specialized controller
```

### Development Scripts

```bash
/home/dave/skippy/development/
├── app-to-deploy/
└── UnifiedSystemManager/
```

## Troubleshooting

### Database Issues

```bash
# Check database integrity
sqlite3 /home/dave/skippy/.advanced-system-manager/system.db "PRAGMA integrity_check;"

# Vacuum database (reclaim space)
sqlite3 /home/dave/skippy/.advanced-system-manager/system.db "VACUUM;"

# Repair corrupted database
sqlite3 corrupt.db ".recover" | sqlite3 repaired.db
```

### Plugin Failures

```bash
# Check plugin logs
tail -50 /home/dave/skippy/.advanced-system-manager/plugins/network_monitor/error.log

# Disable problematic plugin
sqlite3 /home/dave/skippy/.advanced-system-manager/system.db \
  "UPDATE plugins SET active=0 WHERE name='failing_plugin';"

# Reinstall plugin
rm -rf /home/dave/skippy/.advanced-system-manager/plugins/failing_plugin/
/home/dave/skippy/.advanced-system-manager/install_plugin.sh failing_plugin
```

### Service Failures

```bash
# Check service status
systemctl status service_name

# View service logs
journalctl -u service_name --since "1 hour ago"

# Restart service
sudo systemctl restart service_name

# Check EbonHawk for related tasks
grep "service_name" /home/dave/skippy/.ebonhawk-maintenance/logs/*.log
```

## Security Considerations

### System Hardening

```bash
# Apply hardening rules
/home/dave/skippy/.advanced-system-manager/plugins/system_hardening/apply.sh

# Check firewall status
sudo ufw status verbose

# Review open ports
netstat -tulpn | grep LISTEN

# Check failed login attempts
grep "Failed password" /var/log/auth.log | tail -20
```

### Access Control

```bash
# Database file permissions
chmod 600 /home/dave/skippy/.advanced-system-manager/system.db
chmod 600 /home/dave/skippy/.unified-system-manager/*.db

# Config file permissions
chmod 600 /home/dave/skippy/.home-server/configs/*.yaml

# Verify no world-readable sensitive files
find /home/dave/skippy/. -name "*.db" -o -name "*.yaml" | xargs ls -la
```

## Integration with Other Skills

- **backup-infrastructure** - Database and config backups
- **security-operations** - System hardening coordination
- **mcp-monitoring** - Service health checks
- **diagnostic-debugging** - System troubleshooting
- **script-development** - Automation scripting

## Quick Reference

```bash
# System status overview
system-status() {
  echo "=== Advanced System Manager ==="
  sqlite3 /home/dave/skippy/.advanced-system-manager/system.db \
    "SELECT name, active FROM plugins;"

  echo "=== EbonHawk Maintenance ==="
  cat /home/dave/skippy/.ebonhawk-maintenance/status.json | python3 -m json.tool | head -20

  echo "=== Home Server ==="
  ls /home/dave/skippy/.home-server/plugins/
}

# Add to ~/.bashrc
```