I used both Gemini and Claude to query ClickHouse using natural language. I used a simple SQL test found online to try to compare them objectively. I think being able to do this type of generative BI is really becoming viable nowadays.

benjaminwootton.com/insights/cli...

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.

New article on ClickHouse in Capital Markets, where I show how we can investigate a realistic trading scenario to understand the PnL impact of trades being rejected.

benjaminwootton.com/insights/ana...

I'm increasingly seeing ClickHouse Cloud being compared with Snowflake for DWH/BI use cases. I ran this analysis last year and found that CH had a 50% lower cost for equivalent compute, before even accounting for it's better performance/scalability.

benjaminwootton.com/insights/com...

Good article about ClickHouse security: www.wiz.io/blog/clickho...