oceanbase-schema-design
CommunityShape efficient OceanBase schemas.
Software Engineering#design#partitioning#best-practices#database-schema#OceanBase#index-design#table-groups
Authoramber-moe
Version1.0.0
Installs0
System Documentation
What problem does it solve?
OceanBase schema design is essential to ensure scalable performance and maintainability. This skill provides a structured set of best practices for designing efficient tables, partitions, table groups, and indexes across OceanBase's MySQL and Oracle modes.
Core Features & Use Cases
- Table design fundamentals: primary keys, data types, not nulls, and meaningful column comments for maintainability.
- Partitioning & table groups: guidance on when to partition, how to choose hash/range/list keys, and how to organize tables into groups for performance.
- Index design & optimization: leftmost prefix rules, covering indexes, and partition-aware indexing strategies.
- Real-world scenarios: design a customer orders schema with PKs, partitioning, and indexing that supports high-throughput queries.
Quick Start
Apply the guidelines to a sample OceanBase schema by defining PKs, partitioning, and indexes consistent with the best-practice rules.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: oceanbase-schema-design Download link: https://github.com/amber-moe/oceanbase-doc-skills/archive/main.zip#oceanbase-schema-design Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.