command-center

Command Center Skill

When This Skill Activates

This skill loads automatically when you mention:

• system status, process status, PM2 status
• restart service, debug job, stuck job
• BullMQ, job queue, queue inspection, orchestrator logs
• deployment status, health check, system health
• service down, service restart
• Redis queue, PostgreSQL check, Nginx reload, cache clear
• pipeline status, approval queue
• what's running, is everything healthy, why is X down
• check logs, Redis memory, database connections, queue backlog
• job retry, clear queue, stalled workers
• Any operational status or troubleshooting of services, databases, caching, or job queues

VPS Services Managed

Location: 100.87.191.9 (Tailscale)

5 Production Services:

1. seo-intelligence (:3001) — Rank tracking, alerts, competitor data
2. geolab-links (:3002) — Link profile analysis (requires PostgreSQL + Redis)
3. geolab-backlinks (:4000) — Backlink discovery and competitor gap
4. geolab-keywords (:4001) — Keyword clustering, SERP features
5. geolab-writer (:4002) — Content generation, publishing pipeline

Supporting Infrastructure:

• PostgreSQL (5432) — geolab-links database
• Redis (6379) — BullMQ job queue, caching
• Nginx (80/443) — Load balancing, SSL termination
• PM2 — Process management, auto-restart

Health Check Command

#!/bin/bash
# Full system health check

echo "=== PM2 Process Status ==="
pm2 status

echo "\n=== Redis Connectivity ==="
redis-cli -h 100.87.191.9 -p 6379 PING

echo "\n=== PostgreSQL Connections ==="
psql -h 100.87.191.9 -U postgres -d openseo -c \
  "SELECT datname, count(*) as connections FROM pg_stat_activity GROUP BY datname;"

echo "\n=== Nginx Status ==="
sudo systemctl status nginx

echo "\n=== Disk Usage ==="
df -h / | awk 'NR==2 {print "Used: " $3 " / Total: " $2 " (" $5 ")"}'

echo "\n=== Memory Usage ==="
free -h | awk 'NR==2 {print "Used: " $3 " / Total: " $2 " (" int($3/$2*100) "%)"}'

echo "\n=== Queue Status ==="
redis-cli -h 100.87.191.9 -p 6379 INFO stats

echo "\n=== Active Jobs ==="
redis-cli -h 100.87.191.9 -p 6379 KEYS 'bull:*' | wc -l