Can AI agents automate ClickHouse?

ClickHouse is automatable today through its HTTP interface, which the vendor documents as a REST API, and through first-party MCP. The HTTP interface listens on port 8123 (HTTPS 8443) and runs SQL. GET requests are read-only; INSERT and other writes require POST. Documented HTTP authentication methods are HTTP Basic, user and password URL parameters, and the X-ClickHouse-User and X-ClickHouse-Key headers. ClickHouse also documents JWT Bearer tokens on the HTTP interface, including a Cloud built-in JWT authenticator used by SQL Console and clickhouse-client --login. Default HTTP output is TabSeparated; FORMAT selects JSON, CSV, Parquet, and other documented formats. The ClickHouse Cloud API at https://api.clickhouse.cloud/v1 is a separate OpenAPI REST management plane authenticated with HTTP Basic using Key ID and Key secret. It creates and manages organizations and services. It is not the SQL query contract. Each Cloud API key is limited to 10 requests in a 10-second window. Official language clients include JavaScript, Python, Go, and Java. Official CLIs are clickhouse-client, with interactive and batch --query modes over the native protocol, and clickhousectl, which runs local and Cloud queries and can emit JSON. First-party MCP exists in two forms. ClickHouse/mcp-clickhouse is the official open-source server with run_query, list_databases, and list_tables; writes are off unless CLICKHOUSE_ALLOW_WRITE_ACCESS is enabled. ClickHouse Cloud documents a managed remote MCP server at https://mcp.clickhouse.cloud/mcp. It must be enabled per service, authenticates with OAuth 2.0, and exposes 13 read-only tools spanning SELECT, schema, services, backups, ClickPipes, and billing. Zapier, Make, Power Automate, and n8n listings were not opened. Computer-use viability is unassessed. API, MCP, and CLI all score 8; API is the best path because Cloud remote MCP is read-only and off until enabled per service, and the open-source MCP runs as a local process.

Best path today: api · Overall automatability: 8/10