ClickHouse has released clickhousectl, an official CLI tool in beta for managing both local ClickHouse installations and ClickHouse Cloud. It functions as a version manager (inspired by uv and pnpm), supports project scaffolding with a standard directory structure, and can start and manage isolated local server instances. For cloud, it covers service creation, scaling, backups, API keys, and team management, with JSON output for scripting. The tool is explicitly designed for both human developers and AI agents, including support for installing agent skills into coding assistants. Authentication for cloud uses OAuth (read-only) or API keys (read-write), with a caution about granting agents destructive permissions.
Table of contents
Why a CLI, and why now #Local development #ClickHouse Cloud #Destructive operations and permissions #Agent skills #Get started #Sort: