ntk148vCommunity·16 Agent Skills Included

clicklens

ClickHouse diagnostics, query tuning, and cluster health audits

Diagnoses ClickHouse performance problems with ready-to-run SQL audits for queries, inserts, merges, memory, storage, caches, and replication. Rates every finding by severity so teams can spot critical issues without digging through raw system tables. Routes symptoms like slow queries, OOM errors, and replication lag to the right diagnostic module automatically.

42|7

↗

npx skills add ntk148v/clicklens --all -g -y

All Skills in This Repository (16)

Pure Emerald Level Indicators

📦 In Repo

ntk148v

altinity-expert-clickhouse-schema

Analyze MergeTree table schemas for partitioning and design anti-patterns.

altinity-expert-clickhouse-caches

Analyze ClickHouse cache systems and produce a prioritized tuning plan.

altinity-expert-clickhouse-overview

Diagnose ClickHouse deployment health with SQL queries and metric aggregation.

altinity-expert-clickhouse-text-log

Analyze ClickHouse server logs and traces from system.text_log and system.trace_log.

altinity-expert-clickhouse-logs

Analyze ClickHouse system log tables for TTL, disk usage, and freshness.

altinity-expert-clickhouse-expert

Diagnose ClickHouse server health issues by analyzing logs, metrics, and query patterns.

altinity-expert-clickhouse-errors

Analyzes ClickHouse errors and crashes from system logs to identify root causes.

altinity-expert-clickhouse-ingestion

Diagnose and optimize ClickHouse INSERT performance and ingestion pipelines.

altinity-expert-clickhouse-storage

Diagnose storage and IO bottlenecks in ClickHouse using SQL queries on system tables.

altinity-expert-clickhouse-reporting

Diagnose slow ClickHouse queries by analyzing system.query_log and related system views.

altinity-expert-clickhouse-memory

Diagnose RAM usage and OOM risks in ClickHouse clusters using system metrics and query logs.

altinity-expert-clickhouse-mutations

Diagnose ClickHouse mutation performance using system.mutations and related views.

Community

Advanced

Frequently Asked Questions

FAQPage Schema

How to install ClickLens skills?▼

Run `npx skills add ntk148v/clicklens --all -g -y` in your terminal to install all ClickHouse diagnostic skills globally.

How to find slow ClickHouse queries?▼

The reporting skill analyzes system.query_log to surface the slowest and most frequent queries, their memory usage, and read amplification so you can target optimization.

How to fix 'too many parts' errors in ClickHouse?▼

The merges and ingestion skills measure part creation rates against merge throughput, then recommend batch sizing and settings changes to clear the backlog.

Can these skills diagnose ClickHouse replication lag?▼

Yes. The replication skill checks readonly replicas, queue sizes, Keeper connectivity, and replica delay, then flags issues by severity.

Do I need ClickHouse expertise to use these skills?▼

No. Each skill provides pre-written audit queries with plain-English interpretations and severity ratings, so your agent can run health checks and explain results for you.