oceanbase-schema-design
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 |
More from amber-moe/oceanbase-doc-skills
oceanbase-sql-optimization
SQL optimization best practices for OceanBase database (MySQL & Oracle modes). Covers query optimization, index usage, execution plan analysis, slow query tuning, and performance optimization techniques. Activates for SQL optimization, query performance, index design, execution plan, slow query, database performance.
24oceanbase-sql-doc
Write and format OceanBase database SQL statement documentation following official style guidelines. Use when creating or editing SQL reference documentation for OceanBase database.
17oceanbase-examples
Create SQL examples for OceanBase documentation with proper formatting, meaningful names, and separated results. Use when writing or reviewing example sections in OceanBase documentation.
16oceanbase-formatting
Apply OceanBase documentation formatting standards including meta tables, notice boxes, spacing, and markdown lint compliance. Use when formatting or reviewing OceanBase documentation.
16oceanbase-syntax
Write SQL syntax definitions for OceanBase documentation. Syntax sections define structure without semicolons, while examples show executable statements. Use when writing syntax sections or reviewing SQL statement documentation.
15