Cogent Security built an AI-native vulnerability management platform on ClickHouse, migrating from PostgreSQL to achieve sub-second query performance on hundreds of millions of rows without caching. Key design principles include query-driven schema design, full denormalization, ClickHouse projections and indexes, and appropriate compression codecs. Their Chart Agent uses an agentic loop with RAG, live SQL execution, and interleaved reasoning to generate ClickHouse SQL from natural language, improving accuracy from 40% to 94%. The biggest accuracy gain came from pre-computing aggregations as ClickHouse projections, simplifying the SQL the agent needs to write. An Ontology Service maintains a single source of truth for data model semantics, enabling tenant-specific schema overlays for enterprise customers.
