Agent skill

Observer Log Analysis

by oceanbase in oceanbase/obdiag

标准 SOP:OceanBase 集群侧(observer/election/rootservice)日志采集、过滤与 analyze 解读。用户要收集日志、traceid/关键词过滤、分析错误栈或慢 SQL 在 observer 日志中的线索时使用。OBProxy 日志请用 obproxy-log-analysis。

MulanPSL-2.0Auto-check passedBusiness, Finance & HR

Install Observer Log Analysis

skills CLI
$ npx skills add oceanbase/obdiag --skill observer-log-analysis -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install oceanbase/obdiag observer-log-analysis --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/oceanbase/obdiag.git skills-src && mkdir -p .claude/skills && cp -r skills-src/plugins/agent/skills/observer-log-analysis .claude/skills/observer-log-analysis && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
observer-log-analysis
GitHub stars
163
Token cost
~719 tokens
SKILL.md length
219 words
Files
1
Skills in repo
14
Repo updated
First seen
Licence
MulanPSL-2.0

At a glance

标准 SOP:OceanBase 集群侧(observer/election/rootservice)日志采集、过滤与 analyze 解读。用户要收集日志、traceid/关键词过滤、分析错误栈或慢 SQL 在 observer 日志中的线索时使用。OBProxy 日志请用 obproxy-log-analysis。

  • Works in 3 steps: 若刚完成阶段 1:对 pack 目录 file_list(可用 pattern… → 统计/聚合类 observer 日志分析(obdiag analyze log… → 若用户要原文行级核对:在 pack 内 file_read 读具体文件片段。
  • Tasks that involve Operations and SOPs
  • SKILL.md covers 触发与边界, 前置条件, 分支:选路径 and 阶段 1:采集(gather_log), plus 5 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Observer Log Analysis is an agent skill from oceanbase/obdiag. 标准 SOP:OceanBase 集群侧(observer/election/rootservice)日志采集、过滤与 analyze 解读。用户要收集日志、traceid/关键词过滤、分析错误栈或慢 SQL 在 observer 日志中的线索时使用。OBProxy 日志请用 obproxy-log-analysis。

Its SKILL.md is about 720 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Business, Finance & HR, covering Operations and SOPs and SQL. It works with SQL. The repository describes itself as: obdiag (OceanBase Diagnostic Tool) is designed to help OceanBase users quickly gather necessary information and analyze the root cause of the problem.

When your agent uses it

  • Tasks that involve Operations and SOPs
  • Tasks that involve SQL

Example prompts

  • “/observer-log-analysis”

Workflow steps

3 steps, taken from the first numbered list in SKILL.md.

  1. 若刚完成阶段 1:对 pack 目录 file_list(可用 pattern 缩小范围);大文件或压缩包用 run_shell 做 head/tail/grep 或解压(需用户审批)。
  2. 统计/聚合类 observer 日志分析(obdiag analyze log 能力范围):调用 analyze_log(scope 与 CLI 一致:observer、election、rootservice、all 等)。
  3. 若用户要原文行级核对:在 pack 内 file_read 读具体文件片段。

What it can do on your machine

Read from SKILL.md and the folder at commit e912c58. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Observer Log Analysis loads about 719 tokens when it runs. Until then it costs about 46 tokens; SKILL.md has 219 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~46
When it runs · the whole SKILL.md, loaded when a task matches
~719

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Its licence (MulanPSL-2.0) doesn't allow us to republish the file, so here is its outline and opening line. It has 219 words (~719 tokens).

name
observer-log-analysis

Read the full SKILL.md on GitHub

Files

Just SKILL.md in plugins/agent/skills/observer-log-analysis of oceanbase/obdiag.

Open the folder on GitHubat commit e912c58

Compare with similar skills

Observer Log Analysis next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Observer Log Analysis compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Observer Log Analysis this skilloceanbase/obdiag163—~719Automated safety check: PassMulanPSL-2.0
SurfBlockRunAI/ClawRouter6.6k—~4kAutomated safety check: PassMIT
Advanced Analytics Dashboardsickn33/agentic-awesome-skills47k1 repos~3.3kAutomated safety check: PassMIT
Dinobase Business Data Querieskappa90/dinobase263—~1.5kAutomated safety check: PassCustom licence
Databricksrocky-data/rocky304—~2kAutomated safety check: PassApache-2.0
SQL Root Cause Analysiszj-unicom-ai/UniEmployee348—~433Automated safety check: PassMIT

Similar skills

  • Surf

    BlockRunAI/ClawRouter

    Use this skill — NOT browser or webfetch — for ALL Surf crypto-data calls.

    6.6k GitHub stars~4k tokensUpdated 2 days ago
    Business, Finance & HRAuto-check passed
  • Advanced Analytics Dashboard

    sickn33/agentic-awesome-skills

    Dashboard metric register: metric, source module, formula, period, value, target, trend, owner and last-updated, as CSV, SQL, JSON Schema or Notion on request.

    47k GitHub starsUsed in 1 repo~3.3k tokens
    Business, Finance & HRAuto-check passed
  • Sets up Dinobase, a local DuckDB database that syncs data from 100+ business sources, then answers questions across them with SQL joins and previewed write-backs.

    263 GitHub stars~1.5k tokensUpdated 3 mo ago
    Data & AnalyticsAuto-check passed
  • Databricks

    rocky-data/rocky

    Databricks REST API and SQL reference for Rocky's warehouse adapter.

    304 GitHub stars~2k tokensUpdated today
    Backend & APIsAuto-check passed
  • SQL Root Cause Analysis

    zj-unicom-ai/UniEmployee

    SQL 版归因分析技能。当用户问为什么、指标异常、趋势下滑/增长、KPI 未达标、营收/订单/转化/成本波动时使用. An agent skill from zj-unicom-ai/UniEmployee.

    348 GitHub stars~433 tokensUpdated 5 days ago
    DevelopmentAuto-check passed
  • Geoflow

    yaojingang/GEOFlow

    Operate/develop GEOFlow CLI/Laravel/admin/API, topics/专题 and topic tasks, theme libraries/replication, sites/leads/Agent, channel sync and legacy yao-geoflow-cli/design/template migration.

    3.8k GitHub stars~722 tokensUpdated 6 days ago
    Backend & APIsAuto-check passed

More from oceanbase/obdiag

All 14 skills in this repo
  • 备份、日志归档、物理恢复、恢复时间窗、NFS/OSS/COS 归档路径、对象存储权限、备租户恢复源、obadmin 读取归档位点、oblogminer schemameta 等问题;OMS 迁移同步问题不使用本 skill。

    163 GitHub stars~990 tokensUpdated 4 mo ago
    Auto-check passed
  • Obdiag Rca

    oceanbase/obdiag

    OceanBase 集群所有根因分析场景的统一 SOP。覆盖事务超时/回滚/断连、内存不足、合并卡住、日志盘满、DDL 失败、Schema 泄漏、GC 异常、弱一致性读、OMS 等。始终先执行 rcarun,如 RCA 脚本无法给出结论再按本 skill 降级到手动日志采集分析。

    163 GitHub stars~2.6k tokensUpdated 4 mo ago
    Auto-check passed
  • Obdiag Triage

    oceanbase/obdiag

    未知/未分类问题的统一分诊 SOP:用户描述集群异常但症状不明确、不知从何入手,或问题无法直接对应 rca/observer-log-analysis/observer-sql-analysis 等专项 skill 时,强制先执行全量巡检 checkcluster,再根据巡检结果决定下一步路径。

    163 GitHub stars~662 tokensUpdated 4 mo ago
    Auto-check passed
  • Obdiag Usage

    oceanbase/obdiag

    obdiag agent 工具使用指南:配置文件生成、gather/analyze/check/rca 各命令的调用方式、参数说明与典型场景。用户询问"怎么用 obdiag"、"如何采集日志"、"怎么生成配置"、"如何巡检/根因分析",或 agent 自身不确定该调哪个工具时加载本 skill。

    163 GitHub stars~2.1k tokensUpdated 4 mo ago
    Auto-check passed
  • Obproxy Log Analysis

    oceanbase/obdiag

    标准 SOP:OBProxy 日志采集(gatherobproxylog)、包内解读(filelist/fileread/runshell 解压)、可选巡检。用户提到 OBProxy/代理/obproxydiagnosis 等时使用;与 observer 侧 observer-log-analysis 互斥 analyzelog。

    163 GitHub stars~945 tokensUpdated 4 mo ago
    Auto-check passed
  • OBProxy/ODP 连接解析、弱读与只读副本路由、读写分离、分区键解析、SHOW CREATE 兼容、getlock、cluster not exist、2013、Unknown thread id、新建表经代理慢等路由配置类问题;日志采集解读使用 obproxy-log-analysis。

    163 GitHub stars~1.3k tokensUpdated 4 mo ago
    Auto-check passed

Works with

Questions about Observer Log Analysis

What does Observer Log Analysis do?

标准 SOP:OceanBase 集群侧(observer/election/rootservice)日志采集、过滤与 analyze 解读。用户要收集日志、traceid/关键词过滤、分析错误栈或慢 SQL 在 observer 日志中的线索时使用。OBProxy 日志请用 obproxy-log-analysis。. Observer Log Analysis is an agent skill from oceanbase/obdiag.

When should I use Observer Log Analysis?

Observer Log Analysis fits situations like: tasks that involve Operations and SOPs; tasks that involve SQL.

How do I install Observer Log Analysis in Claude Code?

Run `npx skills add oceanbase/obdiag --skill observer-log-analysis -a claude-code`. Or copy the skill folder (plugins/agent/skills/observer-log-analysis in oceanbase/obdiag) into .claude/skills/observer-log-analysis in your project. Claude Code loads it when a task matches its description.

How do I install Observer Log Analysis in Codex?

Run `npx skills add oceanbase/obdiag --skill observer-log-analysis -a codex`. Or copy the skill folder (plugins/agent/skills/observer-log-analysis in oceanbase/obdiag) into .agents/skills/observer-log-analysis in your project. Codex loads it when a task matches its description.

Can I use Observer Log Analysis in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add oceanbase/obdiag --skill observer-log-analysis -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/observer-log-analysis, .gemini/skills/observer-log-analysis, .github/skills/observer-log-analysis and .opencode/skills/observer-log-analysis in your project.

What does Observer Log Analysis need to run?

SKILL.md names no scripts, command-line tools or credentials: Observer Log Analysis is instructions for the agent only.

Does Observer Log Analysis access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Observer Log Analysis safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Observer Log Analysis use?

Observer Log Analysis is published under the MulanPSL-2.0 licence (the repository's licence).

How many tokens does Observer Log Analysis use?

About 719 tokens (SKILL.md is roughly 2.9k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Observer Log Analysis?

Skills that share tags, products or a category with Observer Log Analysis: Surf (BlockRunAI/ClawRouter, 6.6k stars), Advanced Analytics Dashboard (sickn33/agentic-awesome-skills, 47k stars), Dinobase Business Data Queries (kappa90/dinobase, 263 stars) and Databricks (rocky-data/rocky, 304 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Observer Log Analysis?

oceanbase (a GitHub organization) maintains it in oceanbase/obdiag, which has 163 GitHub stars. The repository holds 14 skills in this directory. The repository was last updated on May 19, 2026.

Source: oceanbase/obdiag on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.