skills.rest
aliyun
aliyunOFFICIAL
Explore all skills by this author →
WebsiteGitHub

hologres-schema-generator

Generate optimized Hologres DDL statements with orientation, distribution, and partitioning.

17|Updated Apr 22, 2026
Search Tags:#schema#partitioning#ddl#hologres#distribution_key#clustering_key#bitmap_columns
One-click install
npx skills add https://github.com/aliyun/hologres-ai-plugins --skill hologres-schema-generator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: hologres-schema-generator
Source: https://github.com/aliyun/hologres-ai-plugins/tree/main/agent-skills/skills/hologres-schema-generator
Command: npx skills add https://github.com/aliyun/hologres-ai-plugins --skill hologres-schema-generator

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

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.

Frequently Asked Questions about hologres-schema-generator

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

FAQPage Schema
How do I generate an optimized Hologres DDL with distribution_key and clustering_key for analytics?▼

Generate optimized Hologres DDL statements by providing a table schema and workload pattern to automatically configure distribution_key, clustering_key, and storage orientation for analytics.

What is the best way to design Hologres partitioning and event_time_column for time-series data?▼

Design Hologres partitioning for time-series data by applying LIST partitioning strategies and configuring the event_time_column to optimize partition lifecycle and query performance.

When do I need to use row, column, or mixed row,column storage orientation in Hologres?▼

Use row,column storage orientation in Hologres when balancing mixed workloads, defaulting to row for KV workloads and column for OLAP analytics to optimize query efficiency.

Can I configure Hologres bitmap_columns and dictionary_encoding_columns using V2.1+ WITH syntax?▼

Configure Hologres bitmap_columns and dictionary_encoding_columns using V2.1+ WITH syntax to set table properties and optimize storage for analytical queries.

How to create join-optimized Hologres schemas with proper primary key and distribution rules?▼

Create join-optimized Hologres schemas by enforcing primary key rules and configuring distribution_key to align join-heavy analytics workloads and reduce data shuffling.

Related Skills

Explore More Data & Analytics Skills→
RambleRainbowRambleRainbow

clickhouse-io

Optimize ClickHouse MergeTree schemas and OLAP queries for large datasets.

Community
Intermediate
archibatearchibate
6

sql-optimization-patterns

Analyze EXPLAIN plans and recommend indexes for PostgreSQL and MySQL queries.

Community
Advanced
aleonsaaleonsa

clickhouse-io

Design ClickHouse schemas, optimize queries, and implement data ingestion pipelines.

Community
Advanced
FunnelEnvyFunnelEnvy
1

gcp-bq-table-management

Automate BigQuery table creation, partitioning, clustering, and schema management.

Official
Advanced