Search
Databases · ClickHouse · For data scientists
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Analyze ClickHouse Keeper stress-test results from play.clickhouse.com / keeperstresstests data warehouse. | ClickHouse/ | 50k | — | ~4.7k | Automated safety check: Pass | Apache-2.0 | today |
| 2 | Evaluate ClickHouse performance test results from existing CI/dashboard data or local perf.py runs. | ClickHouse/ | 50k | — | ~3.9k | Automated safety check: Notes | Apache-2.0 | today |
| 3 | 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/ | 50k | — | ~4k | Automated safety check: Notes | Apache-2.0 | today |
| 4 | A skill your agent uses when the user has tabular data (pandas DataFrame, parquet, csv, Arrow, json) and wants to filter, group, aggregate, join, or speed up slow pandas. | vemetric/ | 395 | 2 repos | ~1.4k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 5 | ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. | hellangleZ/ | 112 | 14 repos | ~2.5k | Automated safety check: Pass | No licence | 8 mo ago |
| 6 | MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs. | vemetric/ | 395 | 2 repos | ~791 | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 7 | Turns a Tushare API doc URL into a full data plugin for the stock_datasource repo: extractor, ClickHouse schema, query service, config and curl examples. | Yourdaylight/ | 189 | — | ~2.5k | Automated safety check: Pass | MIT | 1 mo ago |
| 8 | Rules for charts and visualization. An agent skill from FrankChen021/datastoria. | FrankChen021/ | 327 | — | ~1.2k | Automated safety check: Pass | Unknown | 2 mo ago |
| 9 | Extract the inner ELF from a ClickHouse self-extracting clickhouse binary, including when its architecture differs from the host (e.g. | ClickHouse/ | 50k | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | today |
| 10 | 10.Good PRs 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/ | 50k | — | ~1.8k | Automated safety check: Pass | Apache-2.0 | today |
| 11 | Load this FIRST whenever working with PyTorch CI data (any pytorch/ org repo), the torchci/HUD codebase, or the PyTorch HUD ClickHouse database. | pytorch/ | 113 | — | ~2.8k | Automated safety check: Pass | Unknown | today |
| 12 | Locally reproduce ClickHouse CI performance comparison results for a given commit. | ClickHouse/ | 50k | — | ~6.4k | Automated safety check: Notes | Apache-2.0 | today |
| 13 | Unattended variant of continue-pr for automation (driven by utils/continue-all-prs.sh). | ClickHouse/ | 50k | — | ~8.6k | Automated safety check: Notes | Apache-2.0 | today |
| 14 | Measures what a ClickHouse query change actually costs, turning a suspicion that a query is slow into numbers a reviewer can act on before it merges. | comet-ml/ | 22k | — | ~2.1k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 15 | ClickHouse数据库模式、查询优化、分析以及高性能分析工作负载的数据工程最佳实践. An agent skill from affaan-m/ECC. | affaan-m/ | 277k | 3 repos | ~2.3k | Automated safety check: Pass | MIT | today |
| 16 | 고성능 분석 워크로드를 위한 ClickHouse 데이터베이스 패턴, 쿼리 최적화, 분석 및 데이터 엔지니어링 모범 사례. | affaan-m/ | 277k | 2 repos | ~2.3k | Automated safety check: Pass | MIT | today |
| 17 | ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. | affaan-m/ | 277k | 1 repo | ~2.7k | Automated safety check: Pass | MIT | today |
| 18 | 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/ | 273 | — | ~2.4k | Automated safety check: Pass | AGPL-3.0 | yesterday |
| 19 | ClickHouse 数据库模式、查询优化、分析以及高性能分析工作负载的数据工程最佳实践. An agent skill from xu-xiang/everything-claude-code-zh. | xu-xiang/ | 2k | — | ~2.1k | Automated safety check: Pass | MIT | 7 mo ago |
| 20 | Time-series database implementation for metrics, IoT, financial data, and observability backends. | ancoleman/ | 525 | — | ~1.7k | Automated safety check: Pass | MIT | 10 mo ago |
| 21 | Produce and structure slow-query performance reports for PostHog's production ClickHouse (US and EU). | PostHog/ | 40k | — | ~5.1k | Automated safety check: Pass | Unknown | yesterday |
| 22 | ClickHouse 数据库模式、查询优化、分析以及高性能分析负载的数据工程最佳实践. An agent skill from xu-xiang/everything-claude-code-zh. | xu-xiang/ | 2k | — | ~2.2k | Automated safety check: Pass | MIT | 7 mo ago |
| 23 | ClickHouse migration patterns and rules. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~3k | Automated safety check: Pass | Unknown | yesterday |
| 24 | Debug the signals pipeline locally end-to-end. An agent skill from PostHog/posthog. | PostHog/ | 40k | — | ~2.4k | Automated safety check: Notes | Unknown | yesterday |
| 25 | Fix ClickHouse query errors when querying AggregatingMergeTree tables that use state functions. | divinevideo/ | 266 | — | ~1.7k | Automated safety check: Pass | MPL-2.0 | yesterday |
| 26 | Authenticate a new or changed service to ClickHouse with the rotating ch-podauth ServiceAccount token instead of a static password. | PostHog/ | 40k | — | ~585 | Automated safety check: Pass | Unknown | yesterday |
| 27 | Fix HTTP 500 / ClickHouse "column not found" errors when filtering by a MATERIALIZED column through a VIEW that doesn't expose it. | divinevideo/ | 266 | — | ~1k | Automated safety check: Pass | MPL-2.0 | yesterday |
| 28 | Explains core ClickHouse concepts with accurate mental models — MergeTree, indexes, replication, sharding, and special engines. | chmonitor/ | 300 | — | ~2.1k | Automated safety check: Pass | GPL-3.0 | 5 days ago |
| 29 | Detect server cores/RAM/disk from system tables, then recommend ClickHouse settings sized to that hardware. | chmonitor/ | 300 | — | ~2.1k | Automated safety check: Pass | GPL-3.0 | 5 days ago |
| 30 | Recommend table ORDER BY keys, partition strategies, column data-type right-sizing, codecs, skip indexes, and projections for ClickHouse tables. | chmonitor/ | 300 | — | ~2.2k | Automated safety check: Pass | GPL-3.0 | 5 days ago |
| 31 | Diagnose and resolve ClickHouse issues: OOM, slow merges, stuck mutations, query failures with error codes, and systematic error clustering. | chmonitor/ | 300 | — | ~674 | Automated safety check: Pass | GPL-3.0 | 5 days ago |
| 32 | Diagnose and fix the top 15 ClickHouse errors — query failures, insert problems, memory limits, and merge issues. | jeremylongshore/ | 2.8k | — | ~1.5k | Automated safety check: Pass | MIT | yesterday |
| 33 | Design ClickHouse schemas with MergeTree engines, ORDER BY keys, and partitioning. | jeremylongshore/ | 2.8k | — | ~1.6k | Automated safety check: Pass | MIT | yesterday |
| 34 | Optimize ClickHouse Cloud costs — compute scaling, storage tiering, compression, and query efficiency for lower bills. | jeremylongshore/ | 2.8k | — | ~1.4k | Automated safety check: Pass | MIT | yesterday |
| 35 | Collect ClickHouse diagnostic data — system tables, query logs, merge status, and server metrics for support tickets and troubleshooting. | jeremylongshore/ | 2.8k | — | ~1.7k | Automated safety check: Pass | MIT | yesterday |
| 36 | Create your first ClickHouse table, insert data, and run analytical queries. | jeremylongshore/ | 2.8k | — | ~1.5k | Automated safety check: Pass | MIT | yesterday |
| 37 | Optimize ClickHouse query performance with indexing, projections, settings tuning, and query analysis using system tables. | jeremylongshore/ | 2.8k | — | ~1.2k | Automated safety check: Pass | MIT | yesterday |
| 38 | Production readiness checklist for ClickHouse — server tuning, backup, monitoring, and deployment verification. | jeremylongshore/ | 2.8k | — | ~1.8k | Automated safety check: Pass | MIT | yesterday |
| 39 | Production reference architecture for ClickHouse-backed applications — project layout, data flow, multi-tenant patterns, and operational topology. | jeremylongshore/ | 2.8k | — | ~2k | Automated safety check: Notes | MIT | yesterday |
| 40 | Production-ready patterns for @clickhouse/client — streaming inserts, typed queries, error handling, and connection management. | jeremylongshore/ | 2.8k | — | ~1.4k | Automated safety check: Pass | MIT | yesterday |
| 41 | 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/ | 2.8k | — | ~1.7k | Automated safety check: Pass | MIT | yesterday |
| 42 | Fix duplicate Nostr events in ClickHouse when using ReplacingMergeTree for NIP-33 addressable events (Kind 30000+). | divinevideo/ | 266 | — | ~1.1k | Automated safety check: Pass | MPL-2.0 | yesterday |
| 43 | Production operational practices: insert batching, async writes, query cache, connection pooling, and recommended settings. | chmonitor/ | 300 | — | ~434 | Automated safety check: Pass | GPL-3.0 | 5 days ago |
| 44 | ReplicatedMergeTree operations, failover procedures, lag diagnosis, quorum writes, and Keeper management. | chmonitor/ | 300 | — | ~555 | Automated safety check: Pass | GPL-3.0 | 5 days ago |
| 45 | Printing Press CLI for Clickhouse Cloud. An agent skill from mvanhorn/printing-press-library. | mvanhorn/ | 2.1k | — | ~3.9k | Automated safety check: Notes | Apache-2.0 | yesterday |
| 46 | Fix Gorse recommendation engine failing to connect to ClickHouse Cloud with EOF errors. | divinevideo/ | 266 | — | ~810 | Automated safety check: Pass | MPL-2.0 | yesterday |