Search
Databases · ClickHouse
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Write, review, and migrate Supabase logs queries against the ClickHouse-backed logs table (the logs.all.otel analytics endpoint). | supabase/ | 111k | — | ~2.4k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 2 | 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 |
| 3 | 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 |
| 4 | 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 |
| 5 | 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 |
| 6 | Build or review Langfuse backend code. An agent skill from langfuse/langfuse. | langfuse/ | 36k | — | ~1.9k | Automated safety check: Pass | Unknown | today |
| 7 | 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 |
| 8 | 8.Chdb SQL A skill your agent uses when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse… | vemetric/ | 395 | 1 repo | ~1.2k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 9 | Speed up a GitHub PR review — sort every changed file into trivial / skim / review, mark the trivial ones as viewed on GitHub, and hand back a reading order for the rest. | wannabespace/ | 1.5k | — | ~811 | Automated safety check: Pass | AGPL-3.0 | yesterday |
| 10 | 10.Bisect Bisect a ClickHouse regression using pre-built master binaries from CI. | ClickHouse/ | 50k | — | ~1.4k | Automated safety check: Pass | Apache-2.0 | today |
| 11 | Analyzes a single GitHub issue at a time. An agent skill from ClickHouse/clickhouse-java. | ClickHouse/ | 1.6k | — | ~904 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 12 | Build, refactor, or review production-grade admin interfaces with Vue 3 + JavaScript + Ant Design Vue 4.x. | lazzyfu/ | 729 | — | ~2k | Automated safety check: Pass | MIT | 6 mo ago |
| 13 | Generate PR descriptions for ClickHouse/ClickHouse that match maintainer expectations. | ClickHouse/ | 50k | — | ~1.9k | Automated safety check: Pass | Apache-2.0 | today |
| 14 | Write, rewrite, and format documentation code snippets into reusable, production-ready methods with necessary library imports and clean linting. | ClickHouse/ | 1.6k | — | ~3.1k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 15 | 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 |
| 16 | Administers Observal users, settings, diagnostics, review queues, security events, audit logs, SAML, SCIM, the local Observal server, its upgrades and rollback, and its own PostgreSQL and ClickHouse… | Observal/ | 4.3k | — | ~774 | Automated safety check: Pass | Apache-2.0 | today |
| 17 | 17.Tamery UI Tamery's UI design system and hard rules — native macOS look, three-level color system, typography tokens, motion recipes, and the kit's known gotchas. | wannabespace/ | 1.5k | — | ~1.7k | Automated safety check: Pass | AGPL-3.0 | yesterday |
| 18 | 18.Codex Review Run a local pre-push AI code review of the current branch with the OpenAI codex CLI, the same way ClickHouse CI does, and optionally iterate fix and re-review until clean. | ClickHouse/ | 50k | — | ~1.8k | Automated safety check: Notes | Apache-2.0 | today |
| 19 | Generates TypeScript or JavaScript readers and writers for ClickHouse's RowBinary formats over HTTP in Node.js, after checking that RowBinary suits the data. | ClickHouse/ | 545 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | 12 days ago |
| 20 | MUST USE when reviewing ClickHouse schemas, queries, or configurations. | vemetric/ | 395 | 2 repos | ~2.6k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 21 | Query ClickHouse system tables to inspect query logs, monitor cluster health, check replication status, and analyze slow queries. | FrankChen021/ | 327 | — | ~731 | Automated safety check: Pass | Unknown | 2 mo ago |
| 22 | MUST USE when reviewing ClickHouse schemas, queries, or configurations. | langfuse/ | 36k | — | ~3.5k | Automated safety check: Pass | Apache-2.0 | today |
| 23 | Build interactive analytics webapps, demos, dashboards, or embedded app surfaces from Sidemantic semantic models using copyable component primitives and deterministic query inspection. | sidequery/ | 129 | — | ~5.5k | Automated safety check: Pass | AGPL-3.0 | 4 days ago |
| 24 | 24.Cpu Profile Profile a ClickHouse query using the sampling query profiler and system.tracelog. | ClickHouse/ | 50k | — | ~1.9k | Automated safety check: Notes | Apache-2.0 | today |
| 25 | Update ALLOWEDKEYWORDALIASES in ClickHouseSqlUtils.java and ENGINETOTABLETYPE in DatabaseMetaDataImpl.java from failing test output. | ClickHouse/ | 1.6k | — | ~457 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 26 | 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 |
| 27 | 27.Surf Use this skill — NOT browser or webfetch — for ALL Surf crypto-data calls. | BlockRunAI/ | 6.6k | — | ~4k | Automated safety check: Pass | MIT | 6 days ago |
| 28 | Create a ClickHouse git worktree with submodules hardlinked from the main repo. | ClickHouse/ | 50k | — | ~3.5k | Automated safety check: Pass | Apache-2.0 | today |
| 29 | Comprehensive backend development guide for Litefuse's Next.js 14/tRPC/Express/TypeScript monorepo. | litefuse/ | 101 | 1 repo | ~5.8k | Automated safety check: Pass | Unknown | 2 days ago |
| 30 | Operate any AR.IO node deployment — architecture, daily ops, diagnostics, and recurring pitfalls that apply to every operator. | ar-io/ | 127 | — | ~7.7k | Automated safety check: Notes | AGPL-3.0 | today |
| 31 | Java conventions for the Opik backend: layered resource, service and DAO classes, naming rules, Lombok and Guice usage, and notes on MySQL, ClickHouse, migrations and testing. | comet-ml/ | 22k | — | ~2.4k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 32 | 32.Release Cut a stable hypequery release via Changesets, or explain/check the canary flow. | hypequery/ | 103 | — | ~623 | Automated safety check: Pass | Unknown | yesterday |
| 33 | Rules for charts and visualization. An agent skill from FrankChen021/datastoria. | FrankChen021/ | 327 | — | ~1.2k | Automated safety check: Pass | Unknown | 2 mo ago |
| 34 | 34.Modeler Build, validate, and manage semantic models using Sidemantic. | sidequery/ | 129 | — | ~4.2k | Automated safety check: Pass | Apache-2.0 | 4 days ago |
| 35 | 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 |
| 36 | Generate C++ header files following Google Style Guide. An agent skill from ClickHouse/pg_stat_ch. | ClickHouse/ | 124 | — | ~772 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 37 | 37.Cpp Coding Write or review Timeplus/Proton C++20 code covering naming conventions, Proton fences, clang-format, IProcessor patterns, and checkpointing. | timeplus-io/ | 2.3k | — | ~582 | Automated safety check: Pass | Apache-2.0 | 21 days ago |
| 38 | 38.Code Review Review changes in clickhouse-java for correctness, compatibility, API stability, and missing tests. | ClickHouse/ | 1.6k | — | ~290 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 39 | Query indexed Tempo chain data via tidx HTTP API and CLI. An agent skill from tempoxyz/tidx. | tempoxyz/ | 108 | — | ~3.1k | Automated safety check: Pass | MIT | yesterday |
| 40 | Stand up benchmarks-platform locally (Postgres + MinIO + ClickHouse in docker) and run a real @benchsdk/runner benchmark against it, with no cloud or provider credentials. | computesdk/ | 126 | — | ~3k | Automated safety check: Notes | MIT | yesterday |
| 41 | Check C++ naming conventions against Google Style Guide. An agent skill from ClickHouse/pg_stat_ch. | ClickHouse/ | 124 | — | ~701 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 42 | 42.Use Gfs MCP GFS MCP Server for AI agent integration. An agent skill from Guepard-Corp/gfs. | Guepard-Corp/ | 158 | — | ~4k | Automated safety check: Pass | MIT | 2 days ago |
| 43 | Diagnose ClickHouse runtime query failures when the user wants database-level cause and fix guidance from an error or numeric error code, not source-code root cause analysis. | FrankChen021/ | 327 | — | ~610 | Automated safety check: Pass | Unknown | 2 mo ago |
| 44 | MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance. | ClickHouse/ | 545 | — | ~1.2k | Automated safety check: Pass | Apache-2.0 | 12 days ago |
| 45 | Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer. | sidequery/ | 129 | — | ~982 | Automated safety check: Pass | AGPL-3.0 | 4 days ago |
| 46 | 46.Manual Test Execute one of the model-runnable E2E test specs in testing/ (cli, datasets, serve, mcp, react) against a real ClickHouse instance. | hypequery/ | 103 | — | ~618 | Automated safety check: Pass | Unknown | yesterday |
| 47 | 47.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 |
| 48 | Write idiomatic application code with the ClickHouse Node.js client (@clickhouse/client). | vemetric/ | 395 | 1 repo | ~2.8k | Automated safety check: Pass | AGPL-3.0 | 2 days ago |