How do I install the Ops Arango skill?

Run npx skillmds add majiayu000/ops-arango in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Ops Arango safe to use?

This skill has not completed SkillMD's automated safety review yet. Capability flags: makes network calls, reads secrets. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Ops Arango?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Ops Arango free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Ops Arango?

majiayu000 (@majiayu000) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Ops Arango by majiayu000 — Agent Skill

Name: Ops Arango
Rating: 4.5 (4 reviews)
Author: majiayu000

Ops Arango

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

majiayu000 cd91113 2 files · 4.0 KB Updated Sep 9, 2026 567 repo stars

File contents

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

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

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

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

---name: ops-arangodescription: Manage ArangoDB operations including backups with automatic retention, health checks, embedding gap detection, duplicate detection, and integrity verification. Works with local or containerized ArangoDB.--- # 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/ops-arango/run.sh check --json" schedule: "0 1 * * *" # 1am daily enabled: true db-maintenance-weekly: description: "Weekly full maintenance with fixes" command: ".pi/skills/ops-arango/run.sh full --fix" schedule: "0 0 * * 0" # Midnight Sunday enabled: true db-backup-daily: description: "Daily ArangoDB backup" command: ".pi/skills/ops-arango/run.sh dump" schedule: "0 3 * * *" # 3am daily enabled: true ```

Frequently asked questions