Databases · ClickHouse · For developers

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

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

langfuse/langfuse

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

Analyzes a single GitHub issue at a time. An agent skill from ClickHouse/clickhouse-java.

ClickHouse/clickhouse-java

Build, refactor, or review production-grade admin interfaces with Vue 3 + JavaScript + Ant Design Vue 4.x.

lazzyfu/goInsight

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

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

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

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

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

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

hypequery/hypequery

Rules for charts and visualization. An agent skill from FrankChen021/datastoria.

FrankChen021/datastoria

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

Write or review Timeplus/Proton C++20 code covering naming conventions, Proton fences, clang-format, IProcessor patterns, and checkpointing.

timeplus-io/proton

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

GFS MCP Server for AI agent integration. An agent skill from Guepard-Corp/gfs.

Guepard-Corp/gfs

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

Understand onepixel database topology by environment, data ownership across app/events stores, and initialization/migration behavior.

championswimmer/onepixel_backend

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