A look back at 2025 demo development at ClickHouse

As the year concludes, a reflective look at the demos built by the ClickHouse team highlights their role in showcasing the platform's capabilities in real-world applications. These demos, ranging from real-time market analytics with StockHouse to open analytics for RubyGems with ClickGems, and natural language querying with AgentHouse, demonstrate how ClickHouse enables fast, transparent, and scalable data processing. StockHouse exemplifies real-time data ingestion and visualization with minimal configuration, while ClickGems facilitates community-driven SQL exploration of large datasets. AgentHouse illustrates how ClickHouse can support agentic applications by allowing natural language interfaces to query data. Additionally, the ClickStack demo provides insight into observability practices by simulating a microservices-based e-commerce application with integrated telemetry. Throughout these projects, the emphasis is on storing raw data, utilizing materialized views for efficiency, and maintaining transparent query processes, thus allowing developers to adapt and build upon these systems. The openness and real-world data of these demos enable users to experience the rapid query responses and scalability that ClickHouse provides, complementing traditional benchmarks by offering a tangible sense of the platform's performance.