AI-powered text-to-SQL feature in ClickHouse
Mark Needham
This video explores the exciting new AI-powered text-to-SQL feature introduced in ClickHouse 25.7. This nifty addition allows users to generate SQL queries using natural language, making database interactions more intuitive and accessible. We'll walk you through setting it up and demonstrate its capabilities using real-world examples from a UK property price dataset.
Key points covered:
- Setting up the AI-powered text-to-SQL feature with OpenAI or Anthropic API keys
- Exploring available databases and tables using AI-generated queries
- Demonstrating how the AI analyzes schema information to create relevant SQL
- Tips for framing questions to get the most accurate results
This tutorial offers a practical look at how AI can simplify database querying, potentially making ClickHouse more accessible to those less familiar with SQL syntax. Whether you're a seasoned data analyst or just starting with databases, you'll find valuable insights in this demonstration of ClickHouse's latest innovation.
Docs - https://clickhouse.com/docs/use-cases/AI/ai-powered-sql-generation
Scaling ClickHouse to petabytes of logs at OpenAI
How ClickHouse helps Anthropic scale observability
How Capital One Slingshot cut infrastructure costs by 50%
Engineering leaders at Capital One Slingshot share how they cut infrastructure costs by 50% and reduced average dashboard load time from 5+ to under 500ms with ClickHouse Cloud.
