OceanBase avatar

OceanBase

Official

@oceanbase · Singapore

0Followers
|
123Public Repos
|
16Published Skills

The Fastest Distributed Database for Transactional, Analytical, and AI Workloads

Skills Distribution
DomainData Systems...Database Diagnostics (40%)Performance Tuning (30%)Cluster Management (30%)

Agent Skills by OceanBase

Showing 16 vetted skills indexed across 2 GitHub repositories.

oceanbaseoceanbase
161

backup-archive-restore-troubleshooting

Diagnose OceanBase backup, archive, and restore failures with structured phases.

Official
Advanced
oceanbaseoceanbase
161

obdiag-usage

Guide users through obdiag agent tools for configuration, data collection, analysis, and RCA.

Official
Intermediate
oceanbaseoceanbase
161

oceanbase-source-analysis

Extract evidence from OceanBase community source code to validate error codes and runtime behavior.

Official
Advanced
oceanbaseoceanbase
161

obdiag-performance

Aggregates ASH, sysstat, disk IO and flame graphs to identify OceanDB bottlenecks.

Official
Intermediate
oceanbaseoceanbase
161

obdiag-triage

Coordinate full-cluster triage workflows for unknown OceanBase issues.

Official
Advanced
oceanbaseoceanbase
161

observer-storage-space-troubleshooting

Diagnose storage-space issues in Observer log disks, data disks, and archive processes.

Official
Advanced
oceanbaseoceanbase
161

observer-sql-analysis

Analyze a single SQL's performance, plan, trace, and locks in OceanBase.

Official
Advanced
oceanbaseoceanbase
161

obdiag-check-rca

Map user-described symptoms to RCA scenes and orchestrate cluster health check workflows.

Official
Advanced
oceanbaseoceanbase
161

obdiag-rca

Automate OceanBase cluster root-cause analysis with a standard SOP.

Official
Advanced
oceanbaseoceanbase
161

oceanbase-knowledge

Retrieve OceanBase documentation, parameter meanings, and architecture concepts.

Official
Intermediate
oceanbaseoceanbase
161

oms-kafka-performance

Diagnose and tune OceanBase OMS-to-Kafka replication latency and throughput bottlenecks.

Official
Advanced
oceanbaseoceanbase
161

obproxy-log-analysis

Gather, unpack, and analyze OBProxy diagnosis, error, and slow logs.

Official
Intermediate
oceanbaseoceanbase
161

obdiag-multi-cluster

Discover obdiag cluster profiles and switch the active session via cluster_config_path.

Official
Intermediate
oceanbaseoceanbase
161

obproxy-routing-troubleshooting

Diagnose OBProxy routing and connection configuration issues across deployments.

Official
Advanced
oceanbaseoceanbase
161

observer-log-analysis

Analyze OceanBase observer, election, and rootservice logs to determine root causes.

Official
Intermediate
oceanbaseoceanbase
51

oceanbase-design-usage

Standardize OceanBase Design adoption with ConfigProvider, design tokens, and codemod migrations.

Official
Intermediate

Frequently Asked Questions About OceanBase

FAQPage Schema
What specific database tasks can be performed using these diagnostic capabilities?

These capabilities enable deep-dive analysis of SQL execution plans, distributed transaction tracing, and storage-space health monitoring. Users can perform root-cause analysis on cluster-wide failures, tune replication latency between OMS and Kafka, and validate runtime behavior by correlating error codes directly against source code evidence.

Which technical personas are the primary users of these diagnostic skills?

Database administrators, site reliability engineers, and backend infrastructure engineers are the primary users. These professionals utilize the diagnostic suite to manage high-concurrency distributed environments, resolve complex routing issues within OBProxy, and maintain cluster stability through systematic log analysis and performance metric aggregation.

What are the prerequisites for executing cluster-wide diagnostic procedures?

Successful execution requires a configured cluster environment with active obdiag connectivity. Users must have access to the cluster configuration path, appropriate log directory permissions for observer and proxy nodes, and the ability to map reported symptoms to specific root-cause analysis scenes defined within the diagnostic framework.