Agentic coding with ClickHouse. One person, one data stack, one full-stack application

A Solutions Architect at ClickHouse developed a comprehensive AI-driven retail analytics platform called ClickShop in just a few days, demonstrating the effectiveness of agentic coding when supported by a robust data platform that handles complex tasks natively. The application integrates real-time analytics with transactional workflows and features 18 AI agents specialized for various business roles, enhanced by a dual-layer observability system for both infrastructure and AI performance. Utilizing open-source components like ClickHouse for analytics, PostgreSQL for transactions, and tools like LibreChat and Langfuse for AI and monitoring, the project underscores the advantages of a cohesive, open-source data stack that simplifies architecture and accelerates development. The use of an AI-powered IDE like Cursor enabled rapid iteration and deployment, highlighting the potential for streamlined application development when leveraging a well-integrated data platform.