Agent skill

arango-ops

Manage ArangoDB operations including backups with automatic retention, health checks, embedding gap detection, duplicate detection, and integrity verification. Works with local or containerized ArangoDB.

View SKILL.md on GitHub Repository
Stars 163
Forks 31

Install this agent skill to your Project

npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/arango-ops

Metadata

Additional technical details for this skill

short description
ArangoDB operations, backups, and maintenance

SKILL.md

Arango Ops

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

Commands

bash
# 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:

bash
./run.sh check --json
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

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:

yaml
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

Recommended Agent Skills

Expand your agent's capabilities with these related and highly-rated skills.

majiayu000/claude-skill-registry

agent-ops-spec

Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.

163 31
Explore
majiayu000/claude-skill-registry

agent-ops-state

Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.

163 31
Explore
majiayu000/claude-skill-registry

agent-ops-spec

Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.

163 31
Explore
majiayu000/claude-skill-registry

agent-ops-testing

Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.

163 31
Explore
majiayu000/claude-skill-registry

agent-ops-testing

Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.

163 31
Explore
majiayu000/claude-skill-registry

agent-ops-state

Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.

163 31
Explore

Didn't find tool you were looking for?

Be as detailed as possible for better results