hybrid-db-health_skill

Overview

This skill validates and troubleshoots the hybrid database system used by OpenClaw agents, covering the Pulse operational DB/sync layer and the RAG Pinecone vector layer. It runs a quick health check, reports clear PASS/WARN/FAIL statuses, and provides exact next-step remediation instructions when issues are found.

How this skill works

The skill runs an automated shell-based health check that exercises the Pulse sync layer and the Pinecone RAG integration. If the automated script is unavailable, it provides targeted manual checks: a connectivity test for the Pulse DB and environment/key checks plus an optional live query for Pinecone. Results are summarized in plain language with concrete next steps for WARN or FAIL outcomes.

When to use it

• Validate the current hybrid DB setup before deploying agents that rely on persistent memory.
• Troubleshoot intermittent failures or sync issues reported by OpenClaw agents.
• Confirm Pinecone API and OpenAI key presence and basic connectivity.
• Run routine health audits as part of backup or archival workflows.
• Triage setup issues after moving or restoring workspace files.

Best practices

• Run the bundled script first for a consistent, repeatable check and to capture standardized statuses.
• If the script fails, perform the manual Pulse and Pinecone checks to isolate the failing surface.
• Keep environment files and virtual environments up to date to ensure optional live connectivity tests work.
• Report results as three-line summaries: Pulse status, RAG status, and bulleted next steps for fixes.
• Document any recurring WARN/FAIL patterns and automate resolution steps where possible.

Example use cases

• Pre-deployment validation to ensure agents will have persistent retrieval and storage.
• Post-upgrade verification after updating Python deps or environment variables.
• Onboarding checklist for new workspaces to confirm keys and DB sync are functioning.
• Incident triage when agents report missing memory or failed retrievals.
• Audit before archiving or backing up workspace data to ensure integrity.