majiayu000 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
| Check | Description |
|---|---|
embeddings |
Find lessons/episodes without embedding vectors |
duplicates |
Detect lessons with similar titles/content |
orphans |
Find edges pointing to deleted documents |
integrity |
Verify all foreign keys resolve |
stats |
Collection sizes and document counts |
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
CONTAINERenv var to use Docker. Default is local binary. - Integrity Check: Verifies
manifest.jsonexistence 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
| Variable | Default | Description |
|---|---|---|
ARANGO_URL |
http://127.0.0.1:8529 |
ArangoDB endpoint |
ARANGO_DB |
memory |
Database name |
ARANGO_USER |
root |
Username |
ARANGO_PASS |
- | Password |
CONTAINER |
- | Required for Docker dump. Container name. |
RETENTION_N |
7 |
Number of backups to keep |
EMBEDDING_SERVICE_URL |
- | Required for embeddings --fix |
DRY_RUN |
0 |
Set to 1 for preview mode |
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