Cc Skill Clickhouse Io

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

5 starsDatabases

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add lucaspmarie-a11y/claude-skills-vault --skill cc-skill-clickhouse-io
Manual install
git clone --depth 1 https://github.com/lucaspmarie-a11y/claude-skills-vault.git /tmp/claude-skills-vault
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills-vault/plugins/antigravity-awesome-skills-claude/skills/cc-skill-clickhouse-io ~/.claude/skills/cc-skill-clickhouse-io

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# ClickHouse Analytics Patterns

ClickHouse-specific patterns for high-performance analytics and data engineering.

## Overview

ClickHouse is a column-oriented database management system (DBMS) for online analytical processing (OLAP). It's optimized for fast analytical queries on large datasets.

**Key Features:**
- Column-oriented storage
- Data compression
- Parallel query execution
- Distributed queries
- Real-time analytics

## Table Design Patterns

### MergeTree Engine (Most Common)

```sql
CREATE TABLE markets_analytics (
    date Date,
    market_id String,
    market_name String,
    volume UInt64,
    trades UInt32,
    unique_traders UInt32,
    avg_trade_size Float64,
    created_at DateTime
) ENGINE = MergeTree()
PARTITION BY toYYYYMM(date)
ORDER BY (date, market_id)
SETTINGS index_granularity = 8192;
```

### ReplacingMergeTree (Deduplication)

```sql
-- For data that may have duplicates (e.g., from multiple sources)
CREATE TABLE user_events (
    event_id String,
    user_id String,
    event_type String,
    timestamp DateTime,
    properties String
) ENGINE = ReplacingMergeTree()
PARTITION BY toYYYYMM(timestamp)
ORDER BY (user_id, event_id, timestamp)
PRIMARY KEY (user_id, event_id);
```

### AggregatingMergeTree (Pre-aggregation)
Read the full skill on GitHub

Details

Skill name
cc-skill-clickhouse-io
Path
plugins/antigravity-awesome-skills-claude/skills/cc-skill-clickhouse-io/SKILL.md
License
MIT
Repo updated
6 June 2026

FAQ

What does the Cc Skill Clickhouse Io skill do?

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

How do I install the Cc Skill Clickhouse Io skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add lucaspmarie-a11y/claude-skills-vault --skill cc-skill-clickhouse-io. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Cc Skill Clickhouse Io popular?

It lives in lucaspmarie-a11y/claude-skills-vault, which has 5 GitHub stars and 0 forks.

Related skills

Apify Influencer Discovery

5

lucaspmarie-a11y/claude-skills-vault

Find and evaluate influencers for brand partnerships, verify authenticity, and track collaboration performance across Instagram, Facebook, YouTube, and TikTok.

Frontend & Design

00 Andruia Consultant

5

lucaspmarie-a11y/claude-skills-vault

Arquitecto de Soluciones Principal y Consultor Tecnológico de Andru.ia. Diagnostica y traza la hoja de ruta óptima para proyectos de IA en español.

Other

10 Andruia Skill Smith

5

lucaspmarie-a11y/claude-skills-vault

Ingeniero de Sistemas de Andru.ia. Diseña, redacta y despliega nuevas habilidades (skills) dentro del repositorio siguiendo el Estándar de Diamante.

Other

Claimable Postgres

5

lucaspmarie-a11y/claude-skills-vault

Provision instant temporary Postgres databases via Claimable Postgres by Neon (pg.new). No login or credit card required. Use for quick Postgres environments and throwaway DATABASE_URL for prototyping.

Databases

Azure Resource Manager Mysql Dotnet

5

lucaspmarie-a11y/claude-skills-vault

Azure MySQL Flexible Server SDK for .NET. Database management for MySQL Flexible Server deployments.

Databases

Analyzing Database Indexes

jeremylongshore/claude-code-plugins-plus-skills

This skill uses the database-index-advisor plugin to analyze query patterns and recommend optimal database indexes. It identifies missing indexes to improve query performance and unused indexes that can be removed to save storage and improve write performance. Use this skill when the user asks to "analyze database indexes", "optimize slow queries", "find missing indexes", "remove unused indexes", or requests help with "database index optimization". The plugin analyzes database workloads, detects potential indexing issues, and provides actionable recommendations for indexing strategies.

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.