TL;DR
Cloudflare processes over a billion events per second across distributed systems, but analysts struggled to query data scattered across dozens of databases, data warehouses, and message queues with different credentials and query languages. The company built Town Lake, a unified SQL interface consolidating all data sources, and Skipper, an AI agent enabling plain-English queries.
✦ Why It Matters
Engineers can adopt unified data platforms and AI agents to democratize analytics access and accelerate decision-making in data-intensive organizations.
Key Takeaways
Full Summary
Cloudflare's rapid growth created data sprawl: analytics data lived in ClickHouse clusters (columnar databases optimized for analytics), Kafka streams (real-time message queues), BigQuery datasets (cloud data warehouse), production Postgres databases, and Google Cloud buckets, each with separate credentials and query languages. Answering basic questions required knowing which system held relevant data and whether it was sampled or stale.
To solve this, Cloudflare built Town Lake, a unified SQL query layer abstracting all underlying data sources into a single interface. On top of Town Lake, they deployed Skipper, an AI data agent that translates natural language questions into SQL queries and returns auditable answers within seconds.
This approach eliminates context-switching between systems and reduces barriers to data access across the organization.