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,496 | 812 | 176 | +40% |
| AI Agents | 12 | 4,430 | 1,100 | 236 | -3% |
| LLM | 11 | 5,932 | 1,046 | 223 | -2% |
| Real-time | 4 | 6,296 | 1,346 | 246 | -2% |
| MCP | 3 | 6,108 | 613 | 170 | +36% |
| OpenTelemetry | 3 | 1,197 | 139 | 44 | +92% |
| AI Coding Assistant | 1 | 1,480 | 382 | 153 | +18% |
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.