Can I use this for data ingestion design?

Yes, it provides patterns for both bulk insertions to maximize throughput and streaming ingestion for continuous data synchronization.

Does it include examples for business analytics?

Yes, the skill provides pre-built templates for complex analyses such as retention, conversion funnels, and monthly cohort tracking.

What ClickHouse table engines does this skill support?

It provides detailed patterns for the MergeTree family, including ReplacingMergeTree for deduplication and AggregatingMergeTree for pre-calculated metrics.

Is the documentation available in Japanese?

The core implementation patterns and documentation provided by this specific skill are localized for Japanese-speaking development teams.

How does this skill help with query performance?

It includes best practices for indexing, filtering, and using ClickHouse-specific functions like quantiles and state/merge functions for efficient aggregation.

ClickHouse Analytics & Optimization

Name: ClickHouse Analytics & Optimization
Author: oabdelmaksoud

byoabdelmaksoud

0•

Database Management

Provides high-performance patterns and best practices for ClickHouse database design, query optimization, and real-time analytical workloads.

This skill empowers developers to leverage the full power of ClickHouse for high-performance analytical processing (OLAP). It provides standardized implementation patterns for various MergeTree engines, efficient data ingestion strategies, and advanced SQL optimization techniques. By offering ready-to-use templates for complex analysis—including funnel, cohort, and time-series queries—this skill ensures that data engineers and developers can build scalable, sub-second latency analytical systems while following Japanese-localized documentation and industry best practices.

Key Features

010 GitHub stars

02Advanced analytics patterns for funnels, cohorts, and time-series

03Optimized MergeTree engine configuration patterns

04Real-time data aggregation via Materialized Views

05Efficient bulk and streaming data insertion techniques

06High-performance SQL query templates and filtering strategies

Use Cases

01Building real-time business intelligence dashboards on massive datasets

02Optimizing data pipelines for high-throughput OLAP environments

03Designing scalable database schemas for log analysis and event tracking

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add oabdelmaksoud/superclaw clickhouse-io

For use in Claude.ai and ChatGPT

Key Features

010 GitHub stars

02Advanced analytics patterns for funnels, cohorts, and time-series

03Optimized MergeTree engine configuration patterns

04Real-time data aggregation via Materialized Views

05Efficient bulk and streaming data insertion techniques

06High-performance SQL query templates and filtering strategies

Use Cases

01Building real-time business intelligence dashboards on massive datasets

02Optimizing data pipelines for high-throughput OLAP environments

03Designing scalable database schemas for log analysis and event tracking

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add oabdelmaksoud/superclaw clickhouse-io

For use in Claude.ai and ChatGPT