ClickHouse agent skills, page 3

Database operations including querying, schema exploration, and data analysis.

xiaoyuge886/aigc

ClickHouse queries, Goose migrations, chdb test schema, or telemetry storage paths.

latitude-dev/latitude-llm

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

OpenFlare / Wavelet：当新增或修改日志/分析用途表（节点访问日志、用户访问日志、可观测时序）、接入 internal/repository/logstore、切换日志主库、实现 PG/SQLite 回落，或判断一张表该走业务主库还是日志库时必须使用。

Rain-kl/OpenFlare

Twice-monthly check that evlog's drain adapters still send what each provider's own client sends.

evloghq/evlog

Writing or debugging tests, choosing unit vs integration style, Postgres/ClickHouse tests, regenerating ClickHouse test schema, or exporting test helpers from packages without pulling test code into…

latitude-dev/latitude-llm

解答与开源产品有关的深度技术问题，输出图文并茂的 Markdown 技术文章。触发条件：用户提出与开源项目（如 PostgreSQL、Redis、Kafka、Kubernetes、ClickHouse、Flink 等）相关的技术问题，并提供源码目录或 URL、deepwiki repo 名称。即使用户只说"帮我解答这个开源问题"或"分析一下这个项目的某个机制"，也应使用本…

digoal/blog

Review and run read-only natural-language SQL against a customer data warehouse with cached schema introspection and explicit write grants.

HybridAIOne/hybridclaw

Run isolated Moraine dev sandbox validation. An agent skill from eric-tramel/moraine.

eric-tramel/moraine

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

xu-xiang/everything-claude-code-zh

Time-series database implementation for metrics, IoT, financial data, and observability backends.

ancoleman/ai-design-components

Root-cause a vLLM torch-nightly CI regression report. An agent skill from pytorch/test-infra.

pytorch/test-infra

Automated UI/UX + accessibility audit for the ClickHouse Monitor dashboard (apps/dashboard-tsr).

chmonitor/chmonitor

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

xu-xiang/everything-claude-code-zh

Routes crypto market, on-chain, wallet and prediction-market lookups to the Surf data API through a local ClawRouter, paid per call.

BlockRunAI/blockrun-mcp

Drive chmonitor the way a user does: the Rust CLI/TUI (chm / chmonitor in rust/ch-monitor-cli) is the primary surface; the dashboard at apps/dashboard and https://dash.chmonitor.dev is secondary.

chmonitor/chmonitor

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

divinevideo/divine-mobile

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

chmonitor/chmonitor

Fix ClickHouse Cloud migration failures caused by multi-table RENAME statements.

divinevideo/divine-mobile

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

A skill your agent uses when adding a new feature or changing an existing one that surfaces data in the dashboard — the demo org (app.getgram.ai/explore-demo) must show it — and when editing or…

speakeasy-api/gram

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

Schema migrations: ALTER patterns, engine changes, zero-downtime swaps, clickhouse-local offline migrations, lightweight UPDATE/DELETE strategies, and Postgres→ClickHouse migration planning (type…

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

Advises whether and how to upgrade ClickHouse — versioning scheme, upgrade path, what you gain, pre/post-upgrade checklist.

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

Insert, query, and aggregate data in ClickHouse with real SQL patterns.

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

Handle data lifecycle in ClickHouse — TTL expiration, data deletion (GDPR), column-level encryption, and audit logging with real ClickHouse SQL.

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

Deploy ClickHouse-backed applications to Vercel, Fly.io, and Cloud Run with connection pooling, secrets, and health checks.

jeremylongshore/tons-of-skills-marketplace

Configure ClickHouse enterprise RBAC — SQL-based users, roles, row policies, column-level grants, and quota management.

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

Install @clickhouse/client and configure authentication to ClickHouse Cloud or self-hosted.

jeremylongshore/tons-of-skills-marketplace

Run ClickHouse locally with Docker, configure test fixtures, and iterate fast.

jeremylongshore/tons-of-skills-marketplace

Execute ClickHouse schema migrations — ALTER TABLE operations, data migration between engines, versioned migration runners, and zero-downtime schema changes.

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