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 | 5,365 | 1,022 | 211 | +12% |
| AI Agents | 12 | 7,077 | 1,566 | 283 | -11% |
| LLM | 11 | 7,728 | 1,422 | 276 | -3% |
| Real-time | 4 | 8,063 | 1,857 | 307 | -46% |
| MCP | 3 | 12,895 | 917 | 204 | +80% |
| OpenTelemetry | 3 | 1,245 | 153 | 50 | +28% |
| AI Coding Assistant | 1 | 2,036 | 586 | 188 | +20% |
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.