ClickHouse · For devops and sre engineers

Analyze ClickHouse Keeper stress-test results from play.clickhouse.com / keeperstresstests data warehouse.

ClickHouse/ClickHouse

Evaluate ClickHouse performance test results from existing CI/dashboard data or local perf.py runs.

ClickHouse/ClickHouse

Check whether ClickHouse's supported versions (last 3 majors + latest LTS) have recent stable patch releases, diagnose why the scheduled AutoReleases pipeline failed, and identify which releases…

ClickHouse/ClickHouse

MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs.

vemetric/vemetric

Cut a stable hypequery release via Changesets, or explain/check the canary flow.

hypequery/hypequery

Extract the inner ELF from a ClickHouse self-extracting clickhouse binary, including when its architecture differs from the host (e.g.

ClickHouse/ClickHouse

Show a report of open ClickHouse PRs whose only non-green CI check is "CH Inc sync" (or that are fully green) — i.e.

ClickHouse/ClickHouse

Locally reproduce ClickHouse CI performance comparison results for a given commit.

ClickHouse/ClickHouse

Analyze Langfuse Cloud infrastructure cost structure using Metabase cost marts.

langfuse/langfuse

Unattended variant of continue-pr for automation (driven by utils/continue-all-prs.sh).

ClickHouse/ClickHouse

ClickHouse数据库模式、查询优化、分析以及高性能分析工作负载的数据工程最佳实践. An agent skill from affaan-m/ECC.

affaan-m/ECC

고성능 분석 워크로드를 위한 ClickHouse 데이터베이스 패턴, 쿼리 최적화, 분석 및 데이터 엔지니어링 모범 사례.

affaan-m/ECC

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

affaan-m/ECC

How to add a new attribute value (dimension) that the generic org-scoped telemetry.query analytics endpoint can group by and filter on.

speakeasy-api/gram

ClickHouse 数据库模式、查询优化、分析以及高性能分析工作负载的数据工程最佳实践. An agent skill from xu-xiang/everything-claude-code-zh.

xu-xiang/everything-claude-code-zh

Produce and structure slow-query performance reports for PostHog's production ClickHouse (US and EU).

PostHog/posthog

ClickHouse 数据库模式、查询优化、分析以及高性能分析负载的数据工程最佳实践. An agent skill from xu-xiang/everything-claude-code-zh.

xu-xiang/everything-claude-code-zh

Analyze the experiment precompute result-consistency canary across prod-US and prod-EU, deep-dive any issues, and produce an actionable report.

PostHog/posthog

ClickHouse migration patterns and rules. An agent skill from PostHog/posthog.

PostHog/posthog

Fix ClickHouse query errors when querying AggregatingMergeTree tables that use state functions.

divinevideo/divine-mobile

Authenticate a new or changed service to ClickHouse with the rotating ch-podauth ServiceAccount token instead of a static password.

PostHog/posthog

Guide for using the Grafana MCP to monitor and diagnose the Node.js ingestion pipeline workers in production.

PostHog/posthog

Prove the deployed chmonitor product actually works, not just that the Worker answers.

chmonitor/chmonitor

Generate a copy-paste Grafana data source provisioning file (YAML or Terraform) for any plugin from its standardized settings schema on the plugins CDN.

grafana/skills

Fix HTTP 500 / ClickHouse "column not found" errors when filtering by a MATERIALIZED column through a VIEW that doesn't expose it.

divinevideo/divine-mobile

Work on chmonitor's Cloud (SaaS) vs self-hosted (OSS) behaviour from ONE codebase.

chmonitor/chmonitor

Explains core ClickHouse concepts with accurate mental models — MergeTree, indexes, replication, sharding, and special engines.

chmonitor/chmonitor

Detect server cores/RAM/disk from system tables, then recommend ClickHouse settings sized to that hardware.

chmonitor/chmonitor

Structured triage recipes for common ClickHouse incidents: disk, errors, replication, mutations, cluster health, and slow queries.

chmonitor/chmonitor

Recommend table ORDER BY keys, partition strategies, column data-type right-sizing, codecs, skip indexes, and projections for ClickHouse tables.

chmonitor/chmonitor

Diagnose and resolve ClickHouse issues: OOM, slow merges, stuck mutations, query failures with error codes, and systematic error clustering.

chmonitor/chmonitor

Run ClickHouse integration tests in CI with GitHub Actions and Docker containers.

jeremylongshore/tons-of-skills-marketplace

Diagnose and fix the top 15 ClickHouse errors — query failures, insert problems, memory limits, and merge issues.

jeremylongshore/tons-of-skills-marketplace

Design ClickHouse schemas with MergeTree engines, ORDER BY keys, and partitioning.

jeremylongshore/tons-of-skills-marketplace

Optimize ClickHouse Cloud costs — compute scaling, storage tiering, compression, and query efficiency for lower bills.

jeremylongshore/tons-of-skills-marketplace

Collect ClickHouse diagnostic data — system tables, query logs, merge status, and server metrics for support tickets and troubleshooting.

jeremylongshore/tons-of-skills-marketplace

Create your first ClickHouse table, insert data, and run analytical queries.

jeremylongshore/tons-of-skills-marketplace

ClickHouse incident response — triage, diagnose, and remediate server issues using system tables, kill stuck queries, and execute recovery procedures.

jeremylongshore/tons-of-skills-marketplace

Configure ClickHouse across dev, staging, and production with environment-specific settings, secrets management, and infrastructure-as-code patterns.

jeremylongshore/tons-of-skills-marketplace

Monitor ClickHouse with Prometheus metrics, Grafana dashboards, system table queries, and alerting for query performance, merge health, and resource usage.

jeremylongshore/tons-of-skills-marketplace

Optimize ClickHouse query performance with indexing, projections, settings tuning, and query analysis using system tables.

jeremylongshore/tons-of-skills-marketplace

Production readiness checklist for ClickHouse — server tuning, backup, monitoring, and deployment verification.

jeremylongshore/tons-of-skills-marketplace

Configure ClickHouse query concurrency, memory quotas, and connection limits.

jeremylongshore/tons-of-skills-marketplace

Production reference architecture for ClickHouse-backed applications — project layout, data flow, multi-tenant patterns, and operational topology.

jeremylongshore/tons-of-skills-marketplace

Production-ready patterns for @clickhouse/client — streaming inserts, typed queries, error handling, and connection management.

jeremylongshore/tons-of-skills-marketplace

A skill your agent uses when upgrading ClickHouse server versions or the @clickhouse/client SDK, handling breaking changes between versions, or migrating from older client libraries — covers version…

jeremylongshore/tons-of-skills-marketplace

Fix duplicate Nostr events in ClickHouse when using ReplacingMergeTree for NIP-33 addressable events (Kind 30000+).

divinevideo/divine-mobile

Production operational practices: insert batching, async writes, query cache, connection pooling, and recommended settings.

chmonitor/chmonitor