Traditionally, ClickHouse hasn't been that fast when it comes to joins. However, in recent releases it is now performing 20x faster in a TPC-H benchmark. Using another public benchmark a set of join heavy queries over a 500m row dataset now smokes Databricks and Snowflake.

Connecting Gemini CLI or Claude Code to your back end database via an MCP server is a really remarkable development experience.