v.25.8New Feature

AI Powered SQL generation can now infer

Official CH changelog text
AI Powered SQL generation can now infer from env ANTHROPIC_API_KEY and OPENAI_API_KEY if available, this is to make it so that we can have a zero config option to use this feature. #83787 (Kaushik Iska).
AI Powered SQL generation in ClickHouse now supports automatic inference of API keys from environment variables ANTHROPIC_API_KEY and OPENAI_API_KEY enabling zero-configuration usage.

Why it matters

This feature removes the need for manual API key configuration by automatically detecting available API keys from environment variables. It simplifies setup and enhances user experience by allowing immediate use of AI-powered SQL generation without additional configuration steps.

How to use it

Set your AI provider API keys in the environment variables ANTHROPIC_API_KEY or OPENAI_API_KEY. Once these are set, ClickHouse will automatically use them for AI Powered SQL generation without any further configuration.

Related resources

PreviousNext