The June 2025 ClickHouse newsletter announces the launch of ClickStack, an open-source observability solution that combines ClickHouse's database technology with a user interface from HyperDX, aiming to enhance the observability ecosystem. The newsletter highlights community member Joe Karlsson, a Senior Developer Advocate at CloudQuery, known for his contributions to data engineering content, including his work on a full-text search engine using ClickHouse's ngrambf_v1 Bloom filter indices. Various events and workshops, both virtual and in-person, are scheduled globally to provide training and networking opportunities for ClickHouse users. Additionally, the newsletter covers advancements like the ClickHouse 25.5 release, which includes improvements in vector similarity indexing and Hive metastore catalog support, and explores diverse use cases such as analyzing Financial Information eXchange (FIX) data, building agentic applications, and developing scalable user segmentation pipelines. Through detailed blog posts, the newsletter provides insights into leveraging ClickHouse for tasks like efficient query optimizations, constructing conversational analytics experiences, and executing K-Means clustering for user segmentation.