altinity-expert-clickhouse-replication
Diagnose ClickHouse replication health, Keeper connectivity, replica lag, and queue issues. Use for replication lag and readonly replica problems.
Explorez les skills IA publiés de Altinity et consultez leurs instructions source.
Skills indexés
16Étoiles des dépôts des skills indexés
64Forks du dépôt
16Moyenne des étoiles par skill indexé
4Les étoiles d’un dépôt peuvent se répéter entre ses skills.
Diagnose ClickHouse replication health, Keeper connectivity, replica lag, and queue issues. Use for replication lag and readonly replica problems.
Router skill for ClickHouse diagnostics. Runs a quick overview and chains to other skills based on findings.
Use the GitHub CLI (gh) to find and summarize relevant GitHub issues/PRs from an error message or keywords, preferring exact-phrase searches scoped to a repo and returning issue/PR numbers + URLs.
Track and diagnose ClickHouse ALTER UPDATE, ALTER DELETE, and other mutation operations. Use for stuck mutations and mutation performance issues.
Diagnose ClickHouse merge performance, part backlog, and 'too many parts' errors. Use for merge issues and part management problems.
Real-time monitoring of ClickHouse metrics, events, and asynchronous metrics. Use for load average, connections, queue monitoring, and resource saturation.
Analyze ClickHouse system log table health including TTL configuration, disk usage, freshness, and cleanup. Use for system log issues and TTL configuration.
Diagnose ClickHouse RAM usage, OOM errors, memory pressure, and allocation patterns. Use for memory-related issues and out-of-memory errors.
Summarize huge articles (URL or local file) via a Codex CLI-driven chunk→reduce pipeline, keeping only the final short summary in context and saving it to summaries/*.md.
Diagnose ClickHouse disk usage, compression efficiency, part sizes, and storage bottlenecks. Use for disk space issues and slow IO.
Analyze ClickHouse table structure, partitioning, ORDER BY keys, materialized views, and identify schema design anti-patterns. Use for table design issues and optimization.
Analyze ClickHouse external dictionaries including configuration, memory usage, reload status, and performance. Use for dictionary issues and load failures.
ClickHouse incident response, periodic audits, and ad-hoc debugging via focused agents (run in waves). Uses ClickHouse system tables to diagnose slow queries/inserts, too many parts/merge backlog, wrong partiti...
Analyze ClickHouse cache systems including mark cache, uncompressed cache, and query cache. Use for cache hit ratio issues and cache tuning.
Diagnose ClickHouse INSERT performance, batch sizing, part creation patterns, and ingestion bottlenecks. Use for slow inserts and data pipeline issues.
Diagnose ClickHouse SELECT query performance, analyze query patterns, identify slow queries, and find optimization opportunities. Use for query latency and timeout issues.
Le classement utilise les étoiles du dépôt GitHub indexé. Plusieurs skills peuvent partager ce nombre : ce n’est ni un nombre d’installations ni une note de qualité.