{"skill":{"slug":"hybrid-db-health","displayName":"Hybrid DB Health","summary":"Validate and troubleshoot the hybrid database system used by OpenClaw agents (Pulse task DB + RAG Pinecone stack). Use when asked to check setup, connection...","description":"---\nname: hybrid-db-health\ndescription: 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.\n---\n\n# Hybrid DB Health\n\nRun a quick, reliable health check for the two database surfaces in this workspace:\n\nWhen combined with `shared-pinecone-rag`, position the pair as a **Persistent Memory skill stack** (retrieval + health assurance).\n\n1. **Pulse operational DB/sync layer** in `agents/pulse`\n2. **RAG Pinecone layer** in `rag-pinecone-starter`\n\n## Runbook\n\n1. Run the bundled script:\n\n```bash\nbash scripts/check_hybrid_db.sh\n```\n\n2. Interpret status:\n- `PASS`: subsystem is configured and responding\n- `WARN`: subsystem exists but is not fully configured\n- `FAIL`: subsystem check execution failed\n\n3. Report to user in plain language:\n- Pulse DB status\n- RAG DB status\n- Exact next fix steps if WARN/FAIL\n\n## Manual checks (if script unavailable)\n\n### Pulse DB\n\n```bash\ncd /home/Mike/.openclaw/workspace/agents/pulse\npython3 openclaw_sync.py --check\n```\n\nExpected: `Database connection OK`\n\n### RAG Pinecone\n\n```bash\ncd /home/Mike/.openclaw/workspace/rag-pinecone-starter\n[ -f .env ] && grep -E '^(OPENAI_API_KEY|PINECONE_API_KEY)=' .env\n```\n\nIf either key is blank, report as **not connected yet**.\n\nOptional live connectivity test (requires keys + deps):\n\n```bash\nsource .venv/bin/activate\npython query.py \"connectivity test\"\n```\n\n## Output format\n\nReturn concise status like:\n\n- Pulse DB: PASS/FAIL\n- RAG Pinecone: PASS/WARN/FAIL\n- Next steps: bullets\n","tags":{"latest":"1.0.0"},"stats":{"comments":0,"downloads":793,"installsAllTime":30,"installsCurrent":0,"stars":0,"versions":1},"createdAt":1772329724740,"updatedAt":1779077454616},"latestVersion":{"version":"1.0.0","createdAt":1772329724740,"changelog":"Initial release: health checks for Pulse DB and Pinecone RAG connectivity.","license":null},"metadata":null,"owner":{"handle":"cryptobro-man","userId":"s170qt8mmncqdsx5q495pa1gkd884282","displayName":"cryptobro-man","image":"https://avatars.githubusercontent.com/u/78248519?v=4"},"moderation":{"isSuspicious":false,"isMalwareBlocked":false,"verdict":"clean","reasonCodes":["review.llm_review"],"summary":"Review: review.llm_review","engineVersion":"v2.4.24","updatedAt":1779968143862}}