OpenClaw Logger Insight ADB Skill

Collect OpenClaw session logs in real time and push them to AnalyticDB MySQL. Analyze usage patterns with a three-layer insight architecture powered by SQL + Python + LLM.

Prerequisites

• Python >= 3.10 (use python or python3 depending on your system)
• An accessible Alibaba Cloud AnalyticDB MySQL instance
• OpenClaw deployed and generating session files (~/.openclaw/agents/*/sessions/*.jsonl) and logs (/tmp/openclaw/openclaw-YYYY-MM-DD.log)
• (Optional) An OpenAI-compatible or Anthropic LLM API endpoint for L2/L3 analysis

Quick Start

# 1. Install uv package manager
curl -LsSf https://astral.sh/uv/install.sh | sh

# 2. Install dependencies
uv pip install -r requirements.txt