Introducing ClickHouse Agent Skills

The official ClickHouse Agent Skills have been released as a set of open-source tools encoded with best practices for schema design, query optimization, and data ingestion, aiming to enhance the functionality of AI assistants through 28 prioritized rules. These skills are designed to transform general-purpose language models into ClickHouse power users by addressing common issues such as inefficient ORDER BY choices, non-scalable JOINs, and improper use of Materialized Views or specialized indexes. The skills are packaged in an agent-agnostic format, making them easily adoptable for developers who can add them to their local environments or invoke them manually. The initiative, which encourages community contributions under an Apache license, seeks to support developers in overcoming challenges posed by less-than-perfect AI-generated solutions and plans to expand into more complex areas like cluster configurations and engine-specific optimizations.