Agentic coding with ClickHouse. One person, one data stack, one full-stack application
Blog post from ClickHouse
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.
| Trend | Post Mentions | Total Month Mentions | Posts | Companies | MoM |
|---|---|---|---|---|---|
| Observability | 14 | 4,900 | 921 | 200 | +5% |
| AI Agents | 12 | 5,835 | 1,407 | 272 | -21% |
| LLM | 11 | 6,889 | 1,263 | 265 | -9% |
| Real-time | 4 | 7,450 | 1,704 | 292 | -47% |
| MCP | 3 | 7,956 | 795 | 196 | +24% |
| OpenTelemetry | 3 | 1,168 | 142 | 46 | +24% |
| AI Coding Assistant | 1 | 1,759 | 518 | 180 | +12% |
Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.