OpenClaw log analysis with the Skill plugin

Step 1: Clone and prepare environment

git clone https://github.com/aliyun/alibabacloud-adb-mysql-mcp-server
cd alibabacloud-adb-mysql-mcp-server/skill/alibabacloud-adb-openclaw-insight

Step 2: Install project dependencies

• Option 1: Use uv (recommended)

  # Install the uv package manager
  curl -LsSf https://astral.sh/uv/install.sh | sh
  
  # Install project dependencies
  uv pip install -r requirements.txt

• Option 2: Use pip

  pip install -r requirements.txt
  # If "pip" is not found, try:
  pip3 install -r requirements.txt

Step 3: Configure connection information

This is the only step that requires manual intervention. Gather the following configuration details before proceeding.

• AnalyticDB for MySQL connection information

  Parameter	Description	Example
  adb.host	The endpoint for your AnalyticDB for MySQL cluster.	am-xxxxxxxx.ads.aliyuncs.com
  adb.port	The database port number.	3306
  adb.database	The name of the target database.	openclaw_adb
  adb.username	The database username.	your_user
  adb.password	The database password.	your_password

• LLM configuration

  Note

  If you only need L1 operational analysis, you can skip this section.

  Parameter	Description	Example
  llm.endpoint	The service endpoint for the LLM API.	https://dashscope.aliyuncs.com/compatible-mode/v1
  llm.apiKey	Your API key.	sk-xxxxxxxxxx
  llm.model	The model name.	qwen-plus
  llm.apiType	The API protocol type (openai or anthropic).	openai

• (Optional) Analysis module toggles

  Parameter	Description	Default
  analysis.enableL1	Enable L1 analysis.	true
  analysis.enableL2	Enable L2 analysis (requires LLM).	true
  analysis.enableL3	Enable L3 analysis (requires LLM).	true
  analysis.analysisWindowDays	The analysis time window in days.	7

Step 4: Write the configuration file

Generate the config.json file from the config.example.json template.

cp config.example.json config.json

Populate config.json with your configuration details. The final file structure should look like this:

{
  "adb": {
    "host": "<your-provided-host>",
    "port": 3306,
    "database": "<your-provided-database>",
    "username": "<your-provided-username>",
    "password": "<your-provided-password>",
    "sessionTable": "openclaw_sessions",
    "logsTable": "openclaw_logs",
    "connectionPoolSize": 5
  },
  "collection": {
    "intervalMinutes": 5,
    "batchSize": 100,
    "retentionDays": 7,
    "enableLogCollection": true,
    "enableTokenCollection": true
  },
  "filters": {
    "minLevel": "info",

    "includeSubsystems": [ ],

    "excludeSubsystems": ["verbose", "trace"]
  },
  "llm": {
    "endpoint": "<your-llm-endpoint-or-leave-empty>",
    "apiKey": "<your-llm-apikey-or-leave-empty>",
    "model": "<your-llm-model>",
    "apiType": "<your-llm-api-type>",
    "maxConcurrency": 5,
    "temperature": 0.1,
    "maxTokens": 128000
  },
  "analysis": {
    "enableL1": true,
    "enableL2": true,
    "enableL3": true,
    "analysisWindowDays": 7,
    "maxSessionsForLlm": 500
  }
}

Step 5: Initialize the database

This command creates or updates the required table schema in your AnalyticDB for MySQL cluster.

python -m scripts.init_db
# If "python" is not found, try:
python3 -m scripts.init_db