skills.rest
Altinity avatar

Altinity

Official

@altinity · United States of America

0Followers
|
125Public Repos
|
23Published Skills

Leading Service and Software Provider for ClickHouse®

🐙 GitHub ↗🌐 Website ↗
Skills Distribution
DomainData Systems...Database Performan.. (50%)Cluster Health Mon.. (30%)Schema & Storage O.. (20%)

Agent Skills by Altinity

Showing 23 vetted skills indexed across 2 GitHub repositories.

AltinityAltinity
37

codebase-consistency-reviewer

Analyze commits, pull requests, and diffs for duplication and naming inconsistencies.

Official
Advanced
AltinityAltinity
37

umbrella-go-review

Review Go code changes across security, performance, concurrency, compatibility, and tests.

Official
Advanced
AltinityAltinity
37

test-mcp-connector

Validate MCP server connectivity and tool invocation via AI frontends.

Official
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-schema

Identify schema design issues in ClickHouse tables and present actionable fixes.

Official
Advanced
AltinityAltinity
16

altinity-expert-clickhouse-index-analysis

Analyze ClickHouse index usage against query patterns to reduce data scanned.

Official
Advanced
AltinityAltinity
16

altinity-expert-clickhouse-caches

Analyze ClickHouse cache health and report sizing guidance for Mark, Uncompressed, Query, and Compiled Expression caches.

Official
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-overview

Aggregate ClickHouse health data by executing predefined SQL system queries.

Official
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-part-log

Diagnose ClickHouse part_log activity across clusters with per-table and per-host granularity.

Official
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-logs

Detect TTL misconfigurations and disk pressure in ClickHouse system log tables.

Official
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-ingestion

Diagnose ClickHouse INSERT performance bottlenecks with SQL checks.

Official
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-storage

Diagnose ClickHouse storage usage, compression efficiency, and part sizes via checks.sql queries.

Official
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-grants

Diagnose grant-related access errors in ClickHouse after upgrades.

Official
Advanced
AltinityAltinity
16

altinity-expert-clickhouse-reporting

Diagnose ClickHouse SELECT query performance issues by analyzing system.query_log and checks.sql outputs.

Official
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-memory

Diagnose ClickHouse memory usage and OOM risks across multi-node deployments.

Official
Advanced
AltinityAltinity
16

altinity-expert-clickhouse-kafka

Diagnose ClickHouse Kafka engine health and consumer performance across clusters.

Official
Advanced
AltinityAltinity
16

altinity-expert-clickhouse-mutations

Diagnose stuck ClickHouse ALTER UPDATE and ALTER DELETE mutations using system.mutations and system.part_log.

Official
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-replication

Diagnose ClickHouse replication health with SQL scripts against system tables.

Official
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-merges

Diagnose ClickHouse merge performance and part backlog via SQL system tables.

Official
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-metrics

Monitor ClickHouse metrics, events, and asynchronous metrics via SQL checks.

Official
Advanced
AltinityAltinity
16

altinity-expert-clickhouse-dictionaries

Analyze ClickHouse external dictionary configuration, memory usage, and reload status.

Official
Advanced
AltinityAltinity
16

altinity-expert-clickhouse-connection

Tests ClickHouse connectivity and validates access before running diagnostics.

Official
Intermediate
AltinityAltinity
16

skill-creator

Guide developers to create and update Codex skills with standardized SKILL.md structure.

Official
Intermediate
AltinityAltinity
16

skill-installer

Install Codex skills from curated lists or GitHub repositories into the skills directory.

Official
Advanced

Frequently Asked Questions About Altinity

FAQPage Schema
What specific ClickHouse tasks can these diagnostics perform?▼

These diagnostics enable deep inspection of ClickHouse clusters, including analyzing index usage, identifying memory OOM risks, diagnosing Kafka engine performance, and resolving replication or mutation backlogs. They utilize system table queries to provide actionable insights into storage efficiency, cache health, and query performance bottlenecks.

Which technical personas benefit from these diagnostic capabilities?▼

Database administrators, site reliability engineers, and data engineers managing large-scale ClickHouse deployments benefit most. These capabilities are designed for technical teams requiring precise, SQL-driven visibility into cluster health, configuration consistency, and performance tuning across multi-node environments.

What are the prerequisites for running these diagnostic checks?▼

Users require an active ClickHouse instance and appropriate read-only access to system tables. The diagnostics rely on executing predefined SQL queries against system.query_log, system.mutations, and system.part_log to extract performance data, ensuring compatibility with standard ClickHouse deployments.