OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase OAgent

V2.2.0
  • Product overview
    • What is OAgent?
    • Key features
    • System architecture
    • Use cases
  • Quick start
  • Deployment
  • Overview
  • Sessions and diagnosis
    • Manage sessions
    • Switch dialogue models
    • Use @ to mention the analysis target
    • View the tool invocation process
    • Upload an attachment
    • Data visualization
    • FAQ
    • Export a report
  • Tools
  • Skill Management
  • Channel management
  • Knowledge base
    • Built-in knowledge base
    • Custom knowledge base
  • Scheduled tasks
    • Overview of scheduled tasks
    • Create a scheduled task
  • View usage
  • Model configuration
    • Manage model services
    • Model scoring
  • Settings and security
    • Product management
    • Experimental features
  • Best practices
    • Perform a cluster health inspection
    • Query cluster and topology information
    • Query resource metrics and task status
    • Read-only queries
    • Alert query and troubleshooting guide
    • Root cause analysis of exceptions
    • ASH diagnostic report
    • Analyze slow SQL, TopSQL, and abnormal SQL
    • SQL pre-analysis and tuning recommendations
    • Interpret execution plans
    • Diagnostic information statistics
    • Parameter check and change governance
    • Database change ticket
  • Appendix
    • Feature list
    • Built-in Skills
  • Release notes
    • OAgent V2.2.0 Release note
    • OAgent V2.1.0 Release note
    • OAgent V2.0.0 Release note
    • OAgent V1.8.0 Release note

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase OAgent
  3. V2.2.0

Built-in Skills

Last Updated:2026-11-20 07:25:11

Inspection and cluster management
SQL diagnostics and tuning
Performance and session analytics
Alert and anomaly analysis
Statistical information and knowledge
Tasks and reports
Related operations

OAgent comes with a preconfigured set of skills for OceanBase maintenance and diagnostic scenarios. You can view all skills and control their enable/disable status on the Skills page. For more information, see Overview of skill management.

Note

The skill list is updated with product version releases. For the actual available skills, refer to the content displayed on the Skills page.

Inspection and cluster management

Skill ID
Feature Description
cluster_inspection Perform multi-dimensional health inspections on a specified cluster and output risk items
cluster_list Query the list of clusters and basic information under a product
cluster_resource_stats Query resource usage statistics of clusters and tenants

SQL diagnostics and tuning

Skill ID
Feature Description
slow_sql_analysis Analyze Slow Queries within a Specified Time Range
sql_diagnose Comprehensively Diagnose the Execution Status of Specified SQL
sql_pre_analysis Perform EXPLAIN pre-analysis on SQL statements to identify plan risks
sql_tuning_advisor Output optimization suggestions such as index and rewrite
sql_deep_tuning In-depth Tuning Analysis for Complex SQL Execution
execution_plan_interpreter Interpret the execution plan by operator

Performance and session analytics

Skill ID
Feature Description
ash_analysis Analyze active session history to identify wait events and bottleneck time points
ash_report Trigger and obtain an ASH diagnostic report
session_analysis Analyze Current or Historical Session Snapshots

Alert and anomaly analysis

Skill ID
Feature Description
alarm_report Query active and historical alerts and summarize them by severity
alarm_handbook Provide troubleshooting and remediation steps for specific alert types
anomaly_analysis Analyze the manifestations and impact scope of the exception
root_cause_analysis Output the possible root cause ranking and verification suggestions for the exception

Statistical information and knowledge

Skill ID
Feature Description
statistics_diagnostics Diagnostic Tenant Statistics Collection Coverage and Time Limit
ob_knowledge_qa Answer Based on the Built-in OceanBase Knowledge Base
user_upload_md_qa Answer based on user-uploaded documents
error_code_reference Query OceanBase error codes for definitions and troubleshooting suggestions

Tasks and reports

Skill ID
Feature Description
create_scheduled_task Create a scheduled task via dialog
report-export Export Analysis Results to a Report

Related operations

  • View the capability overview by category. For more information, see Feature list.

  • Enable, disable, or create a new skill. For more information, see Overview of skill management.

Previous topic

Feature list
Last

Next topic

OAgent V2.2.0 Release note
Next
on this page
Inspection and cluster management
SQL diagnostics and tuning
Performance and session analytics
Alert and anomaly analysis
Statistical information and knowledge
Tasks and reports
Related operations