LLMs Are Good at SQL. We Gave Ours Terabytes of CI Logs.
Summary
Mendral explains how LLMs can operate inside a SQL-first analytics workflow for CI logs, enabling rapid root-cause analysis. They detail storing 1.5B log lines per day across 700K jobs in a denormalized ClickHouse schema with 48 metadata columns, and how a SQL interface lets the agent answer questions by combining job metadata with raw log lines. They also cover ingestion rate limits, durable execution, and performance metrics that show fast query times even on large scans.