How ChatFeatured migrated from PlanetScale Postgres to Postgres Managed by ClickHouse to power AI brand discovery

ChatFeatured, a Toronto-based startup, helps brands influence their visibility in AI search engines by optimizing content and analytics. Initially relying on Postgres for both application and analytics needs, they faced performance issues as their customer base grew. To address this, they combined Postgres for transactional tasks and ClickHouse for analytical queries, significantly improving speed and efficiency. This integration allowed them to cut analytics query times from minutes to milliseconds, enhancing user experience and enabling new features. The switch was facilitated by ClickHouse's managed Postgres service, which offers a seamless data sync between the two databases. This move not only improved performance but also reduced operational overhead, providing a unified platform that supports their rapid growth and customer demands. ChatFeatured's co-founder, Nithiiyan Skhanthan, highlights the importance of execution and speed in delivering a superior user experience, which has attracted global customers, including billion-dollar companies, and positioned the startup as a leading solution in the AI-driven brand visibility space.