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

oracle-to-tidb-migration

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

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Oracle-to-TiDB migration planning and execution assistant helps teams assess compatibility, translate Oracle schemas and PL/SQL to TiDB-compatible equivalents, and orchestrate data migration to TiDB Cloud.

Core Features & Use Cases

  • Assess Oracle compatibility with TiDB, map DDL and PL/SQL to TiDB-compatible syntax, and generate code stubs.
  • Convert Oracle schemas and data definitions to TiDB-ready DDL and provide guidance for object types, sequences, and views.
  • Load and validate data from Oracle into TiDB, including data profiling, checks, and reconciliation across environments.

Quick Start

Run the guided wizard to scan the Oracle source, assess readiness, convert schemas and PL/SQL, load data into TiDB, and validate results.

Frequently Asked Questions about oracle-to-tidb-migration

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

FAQPage Schema
How do I migrate an Oracle database to TiDB and convert PL/SQL schemas?▼

To migrate Oracle to TiDB, you must assess database compatibility, convert Oracle schemas and PL/SQL to TiDB-compatible syntax, and orchestrate data loading to TiDB Cloud using a CLI toolkit.

What is the process for Oracle to TiDB type mapping and DDL conversion?▼

Oracle to TiDB DDL conversion involves translating Oracle schemas and data definitions into TiDB-ready DDL by applying specific type mappings and conversion rules for object types, sequences, and views.

Do I need a CLI toolkit and source access for Oracle to TiDB migration?▼

Yes, Oracle to TiDB migration requires access to the Oracle source, a TiDB target, and a CLI toolkit to scan the source, assess readiness, convert schemas, and load data.

Can I validate data reconciliation when migrating Oracle schemas to TiDB Cloud?▼

Yes, you can validate data reconciliation when migrating Oracle to TiDB by performing data profiling, executing validation checks, and comparing results across Oracle and TiDB environments.

What are the limitations when converting Oracle PL/SQL to TiDB compatible syntax?▼

Converting Oracle PL/SQL to TiDB syntax requires addressing compatibility gaps by generating code stubs and applying conversion rules, as unsupported Oracle object types may need manual translation.

Related Skills

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

oceanbase-to-tidb-migration

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

Official
Advanced
pingcap-incpingcap-inc
2

spanner-to-tidb-migration

Migrate Cloud Spanner schemas and data to TiDB Cloud.

Official
Advanced
wfukatsuwfukatsu
12

migrate-oracle-sp-trigger-to-scalardb

Convert Oracle PL/SQL stored procedures and triggers to ScalarDB Java code.

Community
Advanced
pingcap-incpingcap-inc
2

aurora-to-tidb-migration

Migrate Aurora MySQL schemas and data to TiDB with validation.

Official
Advanced