skills.rest
pingcap-inc
pingcap-incOFFICIAL
Explore all skills by this author →
GitHub

oceanbase-to-tidb-migration

Automate OceanBase to TiDB migration with schema scanning, conversion, data loading, and validation.

2|1|Updated Mar 21, 2026
Search Tags:#automation#validation#migration#data-loading#oceanbase#tidb#schema-conversion
One-click install
npx skills add https://github.com/pingcap-inc/TiShift --skill oceanbase-to-tidb-migration
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: oceanbase-to-tidb-migration
Source: https://github.com/pingcap-inc/TiShift/tree/main/oceanbase-to-tidb
Command: npx skills add https://github.com/pingcap-inc/TiShift --skill oceanbase-to-tidb-migration

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

OceanBase to TiDB migrations are complex due to OB-specific features like TABLEGROUP, LOCALITY, PRIMARY_ZONE, and Oracle-mode PL/SQL, which introduce compatibility, conversion, and validation challenges.

Core Features & Use Cases

  • End-to-end migration workflow: scan source schemas, assess readiness, convert schemas, load data, and validate results.
  • Dual-mode support: MySQL-mode (near-1:1 type mapping) and Oracle-mode (full dialect conversion), enabling broad coverage.
  • Automated scoring and guidance: calculates readiness scores, flags blockers, and provides actionable remediation steps.
  • Use Case: migrate OceanBase OLTP databases to TiDB Cloud with minimal downtime and reliable validation.

Quick Start

Execute the OceanBase-to-TiDB skill with your source/target configuration to start the migration workflow.

Frequently Asked Questions about oceanbase-to-tidb-migration

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate OceanBase to TiDB migration end-to-end?▼

OceanBase to TiDB migration is automated by scanning source schemas, scoring readiness, converting schemas, loading data, and validating results using the TiShift CLI or Python package.

Does OceanBase to TiDB migration support Oracle-mode PL/SQL dialect conversion?▼

Yes, OceanBase to TiDB migration supports Oracle-mode by applying full dialect conversion and PL/SQL handling, alongside near-1:1 type mapping for MySQL-compatible mode.

How are OceanBase specific features like TABLEGROUP and LOCALITY handled during schema conversion?▼

Schema conversion handles OceanBase specific features by applying DDL adjustments and type mappings to adapt TABLEGROUP, LOCALITY, and PRIMARY_ZONE for TiDB Cloud targets.

What access is required to run an OceanBase to TiDB migration?▼

Running an OceanBase to TiDB migration requires access to the OceanBase source via port 2881 OBProxy, a configured TiDB Cloud cluster, and the TiShift CLI or Python package.

How does the migration process assess readiness before converting schemas and loading data?▼

The migration process assesses readiness by calculating automated readiness scores, flagging potential blockers, and providing actionable remediation steps before proceeding with data loading.

Is OceanBase to TiDB migration suitable for minimizing downtime during OLTP database transfers?▼

Yes, this migration approach is designed to transfer OceanBase OLTP databases to TiDB Cloud with minimal downtime and reliable validation of the loaded results.

Related Skills

Explore More Software Engineering Skills→
pingcap-incpingcap-inc
2

oracle-to-tidb-migration

Assess Oracle compatibility and migrate schemas, PL/SQL, and data to TiDB Cloud.

Official
Advanced
pingcap-incpingcap-inc
2

sqlserver-to-tidb-migration

Migrate SQL Server databases to TiDB with schema conversion, data loading, and validation.

Official
Advanced
yunqiqiliangyunqiqiliang
8

clickzetta-sql-syntax-guide

Document ClickZetta Lakehouse SQL syntax for DDL, DML, and DQL migrations.

Community
Advanced
pingcap-incpingcap-inc
2

neon-to-tidb-migration

Migrate Neon or PostgreSQL databases to TiDB with schema conversion and validation.

Official
Advanced