clickhouse

Q: How to install clickhouse?

Create the skills directory: mkdir -p .claude/skills. Then run: mkdir -p .claude/skills && curl -o .claude/skills/clickhouse.md https://raw.githubusercontent.com/obsessiondb/clickhouse-skills/main/SKILL.md. Finally, /clickhouse in Claude Code.

Q: What is clickhouse best for?

clickhouse is categorized under General. It covers: design.

New

13Community RegistryGeneralby ObsessionDB

ClickHouse database skills for schema design, query optimization, and more

First seen 6/8/2026

View Source

Overview

Build ClickHouse tables with sub-second queries, 10x compression, and zero full table scans.

Installation

bash

npx skills add obsessiondb/clickhouse-skills

Available Skills

Skill	Rules	Trigger
clickhouse-schema-design	15+	Creating/modifying tables, ORDER BY, PARTITION BY, TTL
clickhouse-query-optimization	20+	Writing/debugging queries, slow queries, JOINs, memory errors
clickhouse-materialized-views	10+	Creating MVs, real-time aggregation, pre-aggregation

How Skills Work

Skills load automatically when relevant tasks are detected:

•Mention "CREATE TABLE" or "schema" → loads schema-design
•Mention "slow query", "JOIN", or "optimize" → loads query-optimization
•Mention "materialized view" or "MV" → loads materialized-views

Skill Structure

Each skill contains a SKILL.md file with:

•Goals - Measurable outcomes (e.g., "10x compression")
•Critical Rules - Prioritized as CRITICAL, HIGH, MEDIUM
•Patterns - Good vs Bad code examples
•Troubleshooting - Common problems and solutions

Contributing

Contributions welcome! See AGENTS.md for skill authoring guidelines.

License

MIT + Commons Clause (free to use, not for resale)

Sponsor

Sponsored by ObsessionDB — ClickHouse® infrastructure as a service that decouples processing from storage for high-volume event data.

Install & Usage

Create the skills directory

mkdir -p .claude/skills

Download the skill file

mkdir -p .claude/skills && curl -o .claude/skills/clickhouse.md https://raw.githubusercontent.com/obsessiondb/clickhouse-skills/main/SKILL.md

Invoke in Claude Code

/clickhouse

View source on GitHub

design

Security Audits

LicenseUnknownSourceWarnRepositoryPass

Frequently Asked Questions

What is clickhouse?

ClickHouse database skills for schema design, query optimization, and more

How to install clickhouse?

To install clickhouse: create the skills directory (mkdir -p .claude/skills), then run: mkdir -p .claude/skills && curl -o .claude/skills/clickhouse.md https://raw.githubusercontent.com/obsessiondb/clickhouse-skills/main/SKILL.md. Finally, /clickhouse in Claude Code.

What is clickhouse best for?

clickhouse is a skill categorized under General. It is designed for: design. Created by ObsessionDB.