Technical Capabilities

-- Vaultwarden password manager health check
-- Verify database accessibility and basic integrity

SELECT COUNT(*) as total_users FROM users;

SELECT
    COUNT(*) as total_ciphers,
    COUNT(DISTINCT user_uuid) as users_with_items
FROM ciphers;

SELECT
    datetime(updated_at, 'unixepoch') as last_activity
FROM users
ORDER BY updated_at DESC
LIMIT 1;

# Container CPU usage alert
# Trigger when any container exceeds 80% CPU for 5 minutes
rate(container_cpu_usage_seconds_total{name!=""}[5m]) > 0.8

# Memory pressure warning
# Alert when container memory exceeds 90% of limit
container_memory_usage_bytes / container_spec_memory_limit_bytes > 0.9

# Backup job failure detection
# Alert if backup hasn't succeeded in 25 hours
time() - backup_last_success_timestamp > 90000

# Find errors in Prometheus logs
{container_name="prometheus"} |= "error"

# Count error rate over time
sum(rate({container_name=~".+"} |= "error" [5m])) by (container_name)

# Filter for specific error patterns
{job="containers"}
    |= "error"
    != "context canceled"
    != "connection reset"
    | line_format "{{.container_name}}: {{.message}}"