LogoClawIndex
CasesSkillsAbout
LogoClawIndex

clickhouse-io - ClickHouse analytics and data engineering patterns

ClickHouse database patterns, query optimization techniques, analytics, and data engineering best practices for high-performance analytical workloads.

Tags

Updated: 2026-09-24
clickhouseolapanalyticssql-optimizationdata-engineeringtime-series

Capabilities

Design ClickHouse table schemasWrite analytical queriesOptimize query performanceExecute batch data insertions

Typical Inputs

ClickHouse table schema specificationsAnalytical query parametersEvent and trade datasets

Typical Outputs

Optimized SQL schema definitionsAnalytical query result setsMaterialized view aggregations

What this skill does

  • Design ClickHouse table schemas
  • Write analytical queries
  • Optimize query performance
  • Execute batch data insertions
  • Create materialized views
  • Implement ETL and CDC pipelines
  • Monitor query and table performance

Inputs

  • ClickHouse table schema specifications
  • Analytical query parameters
  • Event and trade datasets
  • ClickHouse database credentials
  • Source database connection settings

Outputs

  • Optimized SQL schema definitions
  • Analytical query result sets
  • Materialized view aggregations
  • Inserted batch data records
  • Database performance metrics

Requirements

  • ClickHouse database server
  • Node.js runtime environment
  • @clickhouse/client npm package
  • PostgreSQL database instance for CDC

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.