Building a Full-Stack Agentic AI Data Platform on ClickHouse: A Complete Architecture Guide

A production-grade, end-to-end agentic AI platform — chat UI, self-hosted LLM, MCP server, LLM observability, medallion data architecture, security guardrails, HA, and cost analysis. Same stack ClickHouse uses internally (DWAINE: 250+ employees, ~70% of internal analytics use cases covered, 50-70% workload reduction on the data-warehouse team). Adapted for a crypto-derivatives exchange. Why I'm writing this The phrase "AI platform" gets thrown around to describe everything from a single chatbot