hologres-schema-generator
OfficialDesign optimal Hologres DDLs and partitions.
Authoraliyun
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Designers and DB engineers need to craft efficient Hologres DDLs that balance storage format, distribution, partitioning, and indexing for performance and maintainability.
Core Features & Use Cases
- Generate CREATE TABLE statements with storage orientation (column, row, or row,column) and proper PK/partition design.
- Recommend and configure distribution_key, clustering_key, event_time_column, bitmap_columns, and dictionary_encoding_columns for analytics, KV workloads, and time-series data.
- Provide partition strategies (LIST partitioning) and guidance for partition lifecycle, including dynamic partitioning best practices.
- Support complex schema optimization scenarios such as join-optimized schemas, mixed workloads, and time-series partitioning with eventTime guidance.
Quick Start
Provide a table schema and workload pattern to generate an optimized Hologres DDL with appropriate orientation, distribution_key, clustering_key, and partition strategy.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 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: hologres-schema-generator Download link: https://github.com/aliyun/hologres-ai-plugins/archive/main.zip#hologres-schema-generator 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 510,000+ vetted skills library on demand.