Introducing clickhousectl: the CLI for ClickHouse local and cloud (beta)

clickhousectl is the official command-line interface for ClickHouse, designed to manage both local installations and ClickHouse Cloud environments, and is currently in beta. It supports agentic development by providing a streamlined interface for both human users and AI agents, allowing them to interact efficiently with ClickHouse's infrastructure. The CLI functions as a version manager, facilitating the discovery and installation of different ClickHouse versions, and offers project scaffolding to maintain consistent SQL file structures. It can manage local server instances with isolated data directories, while also handling cloud infrastructure tasks such as service creation, scaling, and management, with commands supporting JSON output for easy integration with scripts. clickhousectl also enables destructive operations, although caution is advised when pairing with AI agents, particularly in production environments. It supports OAuth and API key authentication, with the latter providing more extensive permissions for modifying cloud resources. Additionally, the CLI offers agent skills that can be installed to enhance interactions with ClickHouse, and feedback from users is encouraged to improve its functionality.