From minutes to seconds: How Skool’s migration from Postgres to ClickHouse transformed their analytics

Skool, an all-in-one community platform founded in 2019, has adopted ClickHouse as its database solution to support the company's growing user base and provide real-time observability, experimentation, and behavioral analytics. Initially using Postgres for both transactional and analytics workloads, Skool experienced bottlenecks due to running both workloads on the same technology. After evaluating different options, they chose ClickHouse, a columnar OLAP database management system, which brought immediate improvements in query performance. Over the past two years, Skool has expanded its use of ClickHouse for various purposes, including real-time observability through Grafana integration and behavioral analytics to monitor user behavior across key stages of the user journey. The adoption of ClickHouse has provided faster query times, enabling the team to focus on innovation and improving the user experience while ensuring scalability as data volumes increase.