ClickHouse · Data warehousing

Write, review, and migrate Supabase logs queries against the ClickHouse-backed logs table (the logs.all.otel analytics endpoint).

supabase/supabase

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

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/vemetric

Build or review Langfuse backend code. An agent skill from langfuse/langfuse.

langfuse/langfuse

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

hellangleZ/burn-in-cceverywhere-ralph

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/vemetric

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/conar

Bisect a ClickHouse regression using pre-built master binaries from CI.

ClickHouse/ClickHouse

Generate PR descriptions for ClickHouse/ClickHouse that match maintainer expectations.

ClickHouse/ClickHouse

Write, rewrite, and format documentation code snippets into reusable, production-ready methods with necessary library imports and clean linting.

ClickHouse/clickhouse-java

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

vemetric/vemetric

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/Observal

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/conar

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/ClickHouse

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/agent-skills

MUST USE when reviewing ClickHouse schemas, queries, or configurations.

vemetric/vemetric

Query ClickHouse system tables to inspect query logs, monitor cluster health, check replication status, and analyze slow queries.

FrankChen021/datastoria

MUST USE when reviewing ClickHouse schemas, queries, or configurations.

langfuse/langfuse

Build interactive analytics webapps, demos, dashboards, or embedded app surfaces from Sidemantic semantic models using copyable component primitives and deterministic query inspection.

sidequery/sidemantic

Profile a ClickHouse query using the sampling query profiler and system.tracelog.

ClickHouse/ClickHouse

Update ALLOWEDKEYWORDALIASES in ClickHouseSqlUtils.java and ENGINETOTABLETYPE in DatabaseMetaDataImpl.java from failing test output.

ClickHouse/clickhouse-java

Use this skill — NOT browser or webfetch — for ALL Surf crypto-data calls.

BlockRunAI/ClawRouter

Create a ClickHouse git worktree with submodules hardlinked from the main repo.

ClickHouse/ClickHouse

Comprehensive backend development guide for Litefuse's Next.js 14/tRPC/Express/TypeScript monorepo.

litefuse/litefuse

Operate any AR.IO node deployment — architecture, daily ops, diagnostics, and recurring pitfalls that apply to every operator.

ar-io/ar-io-node

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

hypequery/hypequery

Build, validate, and manage semantic models using Sidemantic.

sidequery/sidemantic

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

ClickHouse/ClickHouse

Review changes in clickhouse-java for correctness, compatibility, API stability, and missing tests.

ClickHouse/clickhouse-java

Query indexed Tempo chain data via tidx HTTP API and CLI. An agent skill from tempoxyz/tidx.

tempoxyz/tidx

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/benchmarks

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/datastoria

MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance.

ClickHouse/agent-skills

Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer.

sidequery/sidemantic

Execute one of the model-runnable E2E test specs in testing/ (cli, datasets, serve, mcp, react) against a real ClickHouse instance.

hypequery/hypequery

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

Write idiomatic application code with the ClickHouse Node.js client (@clickhouse/client).

vemetric/vemetric

Helps users configure mirrord.json for database branching, enabling isolated database copies for safe development and testing.

metalbear-co/mirrord

Load this FIRST whenever working with PyTorch CI data (any pytorch/ org repo), the torchci/HUD codebase, or the PyTorch HUD ClickHouse database.

pytorch/test-infra

Work inside the Databuddy monorepo for internal implementation, debugging, review, and refactoring.

databuddy-analytics/Databuddy

Expert system for generating, validating, and optimizing ClickHouse SQL.

FrankChen021/datastoria

Troubleshoot and resolve common issues with the ClickHouse Node.js client (@clickhouse/client).

vemetric/vemetric

Continue work on an existing PR - resolve conflicts, fix CI failures, address reviewer feedback, and push updates.

ClickHouse/ClickHouse

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

ClickHouse/ClickHouse

Edit an auto-generated ClickHouse release changelog into the form that gets committed to CHANGELOG.md.

ClickHouse/ClickHouse

Update a ClickHouse third-party library (contrib submodule) to a new version.

ClickHouse/ClickHouse