LogoClawIndex
CasesSkillsAbout
LogoClawIndex

cc-skill-clickhouse-io - ClickHouse Analytics Patterns and Query Optimization

Provides ClickHouse-specific patterns for table design, query optimization, data insertion, materialized views, and analytics workflows for high-performance OLAP workloads.

Tags

Updated: 2026-06-30

Capabilities

Typical Inputs

Typical Outputs

What this skill does

  • Create ClickHouse tables with MergeTree engines
  • Execute optimized analytical SQL queries
  • Insert data in bulk batches
  • Create materialized views for aggregation
  • Monitor query and table performance
  • Build ETL data pipelines
  • Implement change data capture
  • Perform time series analysis
  • Perform funnel and cohort analysis

Inputs

  • ClickHouse database connection
  • ClickHouse credentials
  • Source data (e.g., PostgreSQL, event streams)

Outputs

  • SQL table schemas
  • Optimized SQL queries
  • Materialized view definitions
  • TypeScript data pipeline code
  • Performance monitoring query results

Requirements

  • ClickHouse database instance
  • ClickHouse connection URL and credentials
  • Node.js runtime for TypeScript examples

Source

  • Spec: SKILL.md

ClawIndex

OpenClaw Skills & Use Case Index

ClawIndex is an ecosystem-driven index of OpenClaw skills and real-world use cases.

Index

Skills·
Cases

Meta

About·
Disclaimer·
Email·
GitHub
© 2026 ClawIndex All Rights Reserved.
ClickHouse
OLAP
analytics
query optimization
data engineering
materialized views
ETL
columnar database
Create ClickHouse tables with MergeTree engines
Execute optimized analytical SQL queries
Insert data in bulk batches
Create materialized views for aggregation
ClickHouse database connection
ClickHouse credentials
Source data (e.g., PostgreSQL, event streams)
SQL table schemas
Optimized SQL queries
Materialized view definitions