Run any Skill in Manus with one click

altinity-expert-clickhouse-replication

Stars13

Forks2

UpdatedJune 1, 2026 at 07:48

Diagnose ClickHouse replication health, Keeper connectivity, replica lag, and queue issues. Use for replication lag and read-only replica problems.

Installation

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

Run Skill in Manus

Source

Altinity

Altinity/altinity-skills

View GitHub Repository View Creator Repositories

Download

Run Skill in Manus

Related occupationsSOC

Based on SOC occupation classification

Network and Computer Systems AdministratorsComputer and Mathematical Occupations·SOC 15-1244

File Explorer

5 files

SKILL.md

readonly

name	altinity-expert-clickhouse-replication
description	Diagnose ClickHouse replication health, Keeper connectivity, replica lag, and queue issues. Use for replication lag and read-only replica problems.
license	Apache-2.0

Read the SQL files below from this skill's directory, run the queries, and analyse the results:

triage.sql
queue.sql
fetches.sql
keeper.sql

Chaining

On mutation problems follow the altinity-expert-clickhouse-mutations skill.

More from this repository

same repository

altinity-expert-clickhouse-security

Altinity/altinity-skills

Read-only ClickHouse security audit expert for live or exported systems. Use when assessing ClickHouse security posture, reviewing users, roles, grants, settings profiles, row policies, table functions, external sources, table engines, executable UDFs, audit logs, named collections, password hash hygiene, SQL SECURITY DEFINER, impersonation, TLS/network exposure, Keeper/interserver security, encryption at rest, backups, the HTTP interface surface, cluster security, or version-specific ClickHouse security behavior. Diagnoses from SQL/system tables, supplied configuration files, query logs, access metadata, and ClickHouse/Altinity documentation.

2026-06-0313

altinity-expert-clickhouse-grants

Altinity/altinity-skills

Diagnose and resolve ClickHouse grant and authentication errors, especially after upgrades. Use when queries fail with ACCESS_DENIED/NOT_ENOUGH_PRIVILEGES, AUTHENTICATION_FAILED/WRONG_PASSWORD/REQUIRED_PASSWORD, or ON CLUSTER privilege errors; when system.* or INFORMATION_SCHEMA access is denied; or when grant behavior changes after version upgrades.

2026-06-0313

altinity-expert-clickhouse-caches

Altinity/altinity-skills

Analyze ClickHouse cache systems including mark cache, uncompressed cache, and query cache. Use for cache hit ratio issues and cache tuning.

2026-06-0113

altinity-expert-clickhouse-connection

Altinity/altinity-skills

Establishes the ClickHouse connection mode, cluster macro, and default log timeframe for diagnostics. Use first, before any other altinity-expert-clickhouse skill, to verify connectivity and set shared analysis rules.

2026-06-0113

altinity-expert-clickhouse-dictionaries

Altinity/altinity-skills

Analyze ClickHouse external dictionaries including configuration, memory usage, reload status, and performance. Use for dictionary issues and load failures.

2026-06-0113

altinity-expert-clickhouse-index-analysis

Altinity/altinity-skills

Analyze whether ClickHouse indexes (PRIMARY KEY, ORDER BY, skipping indexes, projections) are being used effectively for actual query patterns. Use when investigating index effectiveness, ORDER BY key design, query-to-index alignment, or when queries scan more data than expected.

2026-06-0113

Run any Skill with one click