Altinity

This skill performs a comprehensive ClickHouse diagnostic by orchestrating expert modules to reveal performance bottlenecks and actionable improvements.

This skill helps validate ClickHouse connections and prepare MCP or client queries for diagnostics and analysis.

This skill analyzes ClickHouse external dictionaries including configuration, memory usage, reload status, and performance to diagnose issues and optimize

This skill diagnoses and resolves ClickHouse grant and authentication errors after upgrades, guiding minimal grants and post-upgrade compatibility checks for

This skill analyzes ClickHouse index usage and suggests ORDER BY and projection improvements to align with query patterns and reduce scans.

This skill diagnoses ClickHouse Kafka engine health and consumer performance to reduce lag and prevent thread starvation.

This skill analyzes ClickHouse system logs health, TTL settings, disk usage, freshness, and cleanup to optimize retention and RCA readiness.

This skill helps diagnose ClickHouse RAM usage, OOM risks, and memory pressure, guiding you to optimize queries and configurations.

This skill analyzes ClickHouse system.part_log to diagnose issues from high part churn, mutations, and slow merges, guiding targeted remediation.

This skill analyzes ClickHouse table designs, partitions, ORDER BY keys, and materialized views to identify anti-patterns and optimization opportunities.