Summary
This one covers ClickHouse table design and query optimization for OLAP workloads. You get patterns for choosing the right MergeTree engine variant (standard, ReplacingMergeTree for deduplication, AggregatingMergeTree for pre-aggregations), along with query examples that show the difference between fast and slow approaches. The materialized views section is solid for real-time dashboards, and there are practical templates for time series analysis, retention cohorts, and funnel queries. The bulk insert patterns matter because ClickHouse really punishes row-by-row inserts. Use this when you're moving analytics off Postgres or building something that needs to crunch millions of rows without melting your infrastructure.
Install to Claude Code
npx -y skills add affaan-m/everything-claude-code --skill clickhouse-io --agent claude-codeInstalls into .claude/skills of the current project.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Files
SKILL.md
Select a file.
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →Categories
