oceanbase-schema-design
Installation
SKILL.md
OceanBase Schema Design Skill
Expert in database schema design for OceanBase distributed database (MySQL & Oracle modes).
Provides best practices for designing efficient table structures, partitioning strategies, table groups, indexes, and schema optimization in OceanBase. This skill covers both MySQL mode and Oracle mode.
Mode-specific syntax guide
While OceanBase uses the same underlying storage and partitioning mechanisms for both MySQL and Oracle modes, there are important syntax differences:
| Aspect | MySQL Mode | Oracle Mode |
|---|---|---|
| Data Types | BIGINT, VARCHAR, DATETIME |
NUMBER, VARCHAR2, DATE, TIMESTAMP |
| Schema Access | database.table |
schema.table |
| Default Index | LOCAL (for partitioned tables) | GLOBAL (for partitioned tables) |
| Time Functions | NOW(), CURRENT_TIMESTAMP |
SYSDATE, SYSTIMESTAMP |
| String Functions | CONCAT() |
|| operator |