name: arango-ops
description: >
Manage ArangoDB operations including backups with automatic retention,
health checks, embedding gap detection, duplicate detection, and integrity verification.
Works with local or containerized ArangoDB.
triggers:
- backup arangodb
- dump arango
- create database backup
- arango dump
- backup memory database
- arango ops
- check database health
- find missing embeddings
- detect duplicates
- database maintenance
- cleanup orphans
- verify integrity
allowed-tools: Bash
metadata:
short-description: ArangoDB operations, backups, and maintenance

Arango Ops

Reliable ArangoDB operations: backups, health checks, and maintenance.

Commands

# Create dump (Local 'arangodump' binary must be in PATH)
./run.sh dump

# Create dump from Docker Container
CONTAINER=arangodb ./run.sh dump

# Run all health checks
./run.sh check

# Find documents missing embeddings
./run.sh embeddings --fix

# Detect duplicate lessons
./run.sh duplicates --report

# Find orphaned edges
./run.sh orphans --fix

# Verify referential integrity
./run.sh integrity

# Collection statistics
./run.sh stats

# Full maintenance cycle
./run.sh full --fix

Health Checks

Output Format

All commands support --json for machine-readable output:

./run.sh check --json

{
  "status": "healthy|warning|critical",
  "checks": {
    "embeddings": {"missing": 0, "total": 1234},
    "duplicates": {"found": 5, "clusters": 2},
    "orphans": {"edges": 0},
    "integrity": {"errors": 0}
  },
  "recommendations": []
}

Backup Output Location

Backups saved to: ~/.local/state/devops-agent/arangodumps/<timestamp>/

Features

• Explicit Mode: Set CONTAINER env var to use Docker. Default is local binary.
• Integrity Check: Verifies manifest.json existence after dump.
• Safe Retention: Keeps last N backups automatically (default 7).
• Embedding Gaps: Detects and optionally fixes missing embeddings.
• Orphan Cleanup: Removes edges pointing to deleted documents.
• Duplicate Detection: Finds lessons with identical titles.

Environment Variables

Scheduling

Add to your project's services.yaml for automated maintenance:

scheduled:
  db-maintenance-daily:
    description: "Daily database health check"
    command: ".pi/skills/arango-ops/run.sh check --json"
    schedule: "0 1 * * *"  # 1am daily
    enabled: true

  db-maintenance-weekly:
    description: "Weekly full maintenance with fixes"
    command: ".pi/skills/arango-ops/run.sh full --fix"
    schedule: "0 0 * * 0"  # Midnight Sunday
    enabled: true

  db-backup-daily:
    description: "Daily ArangoDB backup"
    command: ".pi/skills/arango-ops/run.sh dump"
    schedule: "0 3 * * *"  # 3am daily
    enabled: true