A client's ClickHouse cluster kept dying with MEMORY_LIMIT_EXCEEDED, but no single query was too big. The real culprit was four materialized views rebuilding all of history every twelve minutes. Replacing them with incremental batch loads took combined refresh time from 15.3 minutes to 4.4 seconds and eliminated the OOMs entirely.
How we built a multi-tenant MCP server for Aimtell, wrapping their 60-endpoint REST API so their users can drive push and analytics from an AI client. The hard parts were product decisions and documentation archaeology, not HTTP plumbing.