SkillHub

hybrid-db-health

v1.0.0

Validate and troubleshoot the hybrid database system used by OpenClaw agents (Pulse task DB + RAG Pinecone stack). Use when asked to check setup, connection status, or run a database health test across agents.

Sourced from ClawHub, Authored by cryptobro-man

Installation

Please help me install the skill `hybrid-db-health` from SkillHub official store. npx skills add cryptobro-man/hybrid-db-health

Hybrid DB Health

Run a quick, reliable health check for the two database surfaces in this workspace:

When combined with shared-pinecone-rag, position the pair as a Persistent Memory skill stack (retrieval + health assurance).

  1. Pulse operational DB/sync layer in agents/pulse
  2. RAG Pinecone layer in rag-pinecone-starter

Runbook

  1. Run the bundled script:
bash scripts/check_hybrid_db.sh
  1. Interpret status:
  2. PASS: subsystem is configured and responding
  3. WARN: subsystem exists but is not fully configured

  4. FAIL: subsystem check execution failed

  5. Report to user in plain language:

  6. Pulse DB status
  7. RAG DB status
  8. Exact next fix steps if WARN/FAIL

Manual checks (if script unavailable)

Pulse DB

cd /home/Mike/.openclaw/workspace/agents/pulse
python3 openclaw_sync.py --check

Expected: Database connection OK

RAG Pinecone

cd /home/Mike/.openclaw/workspace/rag-pinecone-starter
[ -f .env ] && grep -E '^(OPENAI_API_KEY|PINECONE_API_KEY)=' .env

If either key is blank, report as not connected yet.

Optional live connectivity test (requires keys + deps):

source .venv/bin/activate
python query.py "connectivity test"

Output format

Return concise status like:

  • Pulse DB: PASS/FAIL
  • RAG Pinecone: PASS/WARN/FAIL
  • Next steps: bullets