·clickhouse-materialized-views
{}

clickhouse-materialized-views

10+ patterns for ClickHouse Materialized Views. Load when creating MVs for real-time aggregation, data transformation, or query optimization. Covers SummingMergeTree, AggregatingMergeTree, and common pitfalls.

4Installs·0Trend·@obsessiondb

Installation

$npx skills add https://github.com/obsessiondb/clickhouse-plugin --skill clickhouse-materialized-views

How to Install clickhouse-materialized-views

Quickly install clickhouse-materialized-views AI skill to your development environment via command line

  1. Open Terminal: Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.)
  2. Run Installation Command: Copy and run this command: npx skills add https://github.com/obsessiondb/clickhouse-plugin --skill clickhouse-materialized-views
  3. Verify Installation: Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw

Source: obsessiondb/clickhouse-plugin.

SKILL.md

View raw

Load when creating Materialized Views for real-time aggregation, ETL pipelines, or query optimization.

Prerequisite: Understand MergeTree engine variants in clickhouse-schema-design skill.

Search terms: materialized view, MV, real-time aggregation, AggregateFunction, -State, -Merge, SummingMergeTree, pre-aggregation, incremental

10+ patterns for ClickHouse Materialized Views. Load when creating MVs for real-time aggregation, data transformation, or query optimization. Covers SummingMergeTree, AggregatingMergeTree, and common pitfalls. Source: obsessiondb/clickhouse-plugin.

Facts (cite-ready)

Stable fields and commands for AI/search citations.

Install command
npx skills add https://github.com/obsessiondb/clickhouse-plugin --skill clickhouse-materialized-views
Category
{}Data Analysis
Verified
First Seen
2026-02-26
Updated
2026-03-10

Browse more skills from obsessiondb/clickhouse-plugin

Quick answers

What is clickhouse-materialized-views?

10+ patterns for ClickHouse Materialized Views. Load when creating MVs for real-time aggregation, data transformation, or query optimization. Covers SummingMergeTree, AggregatingMergeTree, and common pitfalls. Source: obsessiondb/clickhouse-plugin.

How do I install clickhouse-materialized-views?

Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/obsessiondb/clickhouse-plugin --skill clickhouse-materialized-views Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw

Where is the source repository?

https://github.com/obsessiondb/clickhouse-plugin

Details

Category
{}Data Analysis
Source
skills.sh
First Seen
2026-02-26