LogoClawIndex
CasesSkillsAbout
LogoClawIndex

clickhouse-io - ClickHouse database patterns and query optimization

Provides ClickHouse database patterns, query optimization, analytics queries, and data engineering best practices for analytical workloads.

Tags

Updated: 2026-09-23
clickhouseolapdatabaseanalyticssqldata-engineering

Capabilities

Design ClickHouse database tablesOptimize ClickHouse analytical queriesPerform bulk and streaming data insertsCreate real-time aggregated materialized views

Typical Inputs

ClickHouse connection configurationClickHouse SQL query statementsAnalytical trade and event data

Typical Outputs

ClickHouse tables and materialized viewsExecuted database insertion operationsAnalytics query result sets

What this skill does

  • Design ClickHouse database tables
  • Optimize ClickHouse analytical queries
  • Perform bulk and streaming data inserts
  • Create real-time aggregated materialized views
  • Monitor database queries and performance
  • Execute time-series and cohort analytics
  • Build ETL and CDC pipelines

Inputs

  • ClickHouse connection configuration
  • ClickHouse SQL query statements
  • Analytical trade and event data
  • PostgreSQL connection string

Outputs

  • ClickHouse tables and materialized views
  • Executed database insertion operations
  • Analytics query result sets
  • Query performance log metrics

Requirements

  • ClickHouse DBMS
  • Node.js runtime environment
  • PostgreSQL database

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.