SewerAI, a company founded in 2019, aims to modernize the sewer management industry by automating the tedious task of defect detection in inspection footage through artificial intelligence. They have developed the first web-based platform for underground infrastructure management, utilizing computer vision to streamline processes and enable real-time analytics powered by ClickHouse. The company's transition from Postgres to ClickHouse involved overcoming challenges in data handling and compliance, ultimately adopting PeerDB for seamless data replication. Their innovative "Megatable," a denormalized data structure, enhances analytical performance but initially strained computational resources, prompting optimization strategies like filtering before joining and focusing on recent data. Despite scaling challenges, SewerAI successfully maintained performance and customer satisfaction, proving that even niche industries can benefit from advanced data solutions.