Insights for people building with ClickHouse.
Field notes, technical guides and informed opinions drawn from production ClickHouse work across analytics, AI, architecture and operations.
Written for engineers, data leaders
and teams making platform decisions.
Self Hosting An Open Source Model With ClickHouse
A walkthrough of self hosting an open source model such as GLM, connecting it to ClickHouse for agentic analytics, and the benefits around data locality, cost and privacy.
Benjamin Wootton
Founder & CTO
Using Open Source and Open Weight LLMs With ClickHouse
How to combine open source and open weight models such as Deepseek, GLM and Kimi with ClickHouse using third party inference providers like Fireworks.ai and Baseten.
Benjamin Wootton
Founder & CTO
What Do We Mean By Agentic Analytics
Agentic analytics is a step beyond text-to-SQL — planning, decomposition and iteration over your data. Here's what it means in practice and why ClickHouse is a natural fit.
Benjamin Wootton
Founder & CTO
Why ClickHouse Is The Best Data Platform For Agentic AI
As companies execute their AI strategies, most databases can't keep up with the concurrency, freshness and price/performance that agentic workloads demand. Here's why ClickHouse is uniquely well suited.
Benjamin Wootton
Founder & CTO
How To Evaluate The TCO of ClickHouse
Considerations when analysing the cost of ClickHouse.
Benjamin Wootton
Founder & CTO
ClickHouse In Capital Markets
How ClickHouse is entering buy side and sell side firms and being adopted for front office use cases.
Benjamin Wootton
Founder & CTO
Deploying Agentic Analytics In Financial Services
Agentic analytics is changing how financial services firms explore data — moving beyond text-to-SQL into scenario modelling, strategy development and real partnership with the LLM. Here's why ClickHouse is the right database to build on.
Benjamin Wootton
Founder & CTO
ClickHouse Cloud Deployment Options
Comparing the four ways to deploy ClickHouse - Open Source, Cloud, Bring Your Own Cloud, and Private - and the strengths and weaknesses of each.
Benjamin Wootton
Founder & CTO
Building Real-Time OHLC Candlestick Charts with ClickHouse
How to implement OHLC candlestick charts in ClickHouse using AggregatingMergeTree and materialized views for real-time, multi-resolution financial data at any time granularity.
Benjamin Wootton
Founder & CTO
The Agentic Data Stack
How ClickHouse have assembled ClickHouse, the ClickHouse MCP server and LibreChat into an integrated agentic data stack — and why this combination is well suited for building agentic analytics and internal agent teams.
Benjamin Wootton
Founder & CTO
Introducing Query Dog, A Tool For Working With The ClickHouse Query Log
Introducing Query Dog, an open source tool for analysing and optimising ClickHouse query performance through visualisation of the query log and system tables.
Benjamin Wootton
Founder & CTO
The Risk Of Misusing ClickHouse Partitions
Learn why ClickHouse partitions can hurt rather than help performance, and what alternatives to consider.
Benjamin Wootton
Founder & CTO
Why We're Not Convinced About Data Lakehouse Architecture
After building 3 data lakehouses, we're skeptical about this architecture. Here's what we learned from these projects.
Benjamin Wootton
Founder & CTO
Comparing The TCO Of ClickHouse Cloud vs Open Source
Exploring the TCO when deciding between ClickHouse Cloud vs Open Source.
Benjamin Wootton
Founder & CTO
Using Gemini and Claude For SQL Analytics - A Bake Off
A bake off of Claude and Gemini in order to test their SQL performance against a ClickHouse database.
Benjamin Wootton
Founder & CTO
Using ClickHouse Cloud For Real Time Sports Analytics
A demonstration of a real time sports analytics use case powered by ClickHouse.
Benjamin Wootton
Founder & CTO
Simplifying Your Data Stack With ClickHouse Cloud
How ClickHouse can simplify your data estate and technology stack.
Benjamin Wootton
Founder & CTO
Analysing FIX Data With ClickHouse
Using ClickHouse String and Array Processing functions to analyse FIX Protocol data.
Benjamin Wootton
Founder & CTO
Reliably Replicating Data Between PostgreSQL and ClickHouse Part 3 - Demo
A video walkthrough of PeerDB open source and ClickPipes for Postgres CDC.
Benjamin Wootton
Founder & CTO
Reliably Replicating Data Between PostgreSQL and ClickHouse Part 2 - ClickPipes For PostgreSQL CDC
Using ClickPipes to reliably replicate data from PostgreSQL to ClickHouse.
Benjamin Wootton
Founder & CTO
Reliably Replicating Data Between PostgreSQL and ClickHouse Part 1 - PeerDB Open Source
Using PeerDB open source to reliably replicate data from PostgreSQL to ClickHouse.
Benjamin Wootton
Founder & CTO
Time Series Classification Using ClickHouse Machine Learning Functions
An example of how we classify time series by leveraging machine learning functions baked into ClickHouse.
Benjamin Wootton
Founder & CTO
Optimising Vehicle Routing Using ClickHouse Cloud And Google OR-Tools
Operational Analytics is about using real time data to make better day to day decisions
Benjamin Wootton
Founder & CTO
Building A Recommendation System Using ClickHouse and SQL
In recent blog posts we demonstrated how data science techniques such as forecasting and anomaly detection can be implemented entirely within ClickHouse using only SQL.
Benjamin Wootton
Founder & CTO
Linear Regression Using Clickhouse Machine Learning Functions
Using functions integrated into ClickHouse to implement a linear regression.
Benjamin Wootton
Founder & CTO
Load And Performance Testing Your ClickHouse Deployment With K6
We've recently used K6 to directly load test a ClickHouse environment and found it to be very powerful and expressive.
Benjamin Wootton
Founder & CTO
Comparing ClickHouse Cloud With Snowflake Pricing
In this article we analyse the differences in pricing between Snowflake and ClickHouse Cloud
Benjamin Wootton
Founder & CTO
Anomaly Detection Using ClickHouse
This article is part of a series where we look at doing data science work within ClickHouse
Benjamin Wootton
Founder & CTO
Using Cube And ClickHouse To Power Data Applications In Financial Services
Last week we delivered a webinar with the Cube team, covering why we believe that Cube is an excellent fit for building data-oriented applications.
Benjamin Wootton
Founder & CTO
Combining ClickHouse Cloud And AWS SageMaker For Machine Learning
Machine learning professionals can learn how to combine ClickHouse Cloud and AWS SageMaker for powerful data analytics and predictive modeling. This comprehensive guide demonstrates end-to-end workflow including data preparation, feature engineering, model training, deployment, and real-time inference, with practical insights into traffic volume forecasting using CatBoost algorithm.
Benjamin Wootton
Founder & CTO
Calculating Value At Risk For An Equities Portfolio Using ClickHouse
ClickHouse is increasingly being used by capital markets firms such as investment banks, hedge funds and trading technology vendors.
Benjamin Wootton
Founder & CTO
Why Cloud Data Warehouses Are Too Expensive For Emerging Data Requirements
The cost model behind many cloud data warehouses is not defined for low latency big data workloads.
Benjamin Wootton
Founder & CTO
Solving A Workforce Optimisation Problem With ClickHouse Cloud and Google OR-Tools
This article walks through a workforce allocation problem and demonstrates how to solve it using ClickHouse Cloud and Google OR-Tools.
Benjamin Wootton
Founder & CTO
Using ClickHouse Cloud As A Real Time Data Warehouse
When you think of data warehouse technology, you may think of legacy on premise offerings such as Oracle or Terradata, or more modern cloud based platforms such as Snowflake, AWS Redshift or BigQuery.
Benjamin Wootton
Founder & CTO
Using ClickHouse Cloud To Power ML Feature Stores - A Fraud Detection Example
A feature store is a place to store the cleaned and prepared input data used to train a machine learning model
Benjamin Wootton
Founder & CTO
How ClickHouse Cloud Simplifies Your Data Stack
How ClickHouse cloud has the potential to take complexity out of your data stack.
Benjamin Wootton
Founder & CTO
Why ClickHouse Cloud Disrupts The Data Warehouse Industry
In recent years, when we have been asked by businesses which data warehouse to choose, there were 3 candidates at the top of the list
Benjamin Wootton
Founder & CTO
Combining Large Language Models With Real Time Data
Learn how large language models can be used to interrogate a real time analytical database like ClickHouse Cloud.
Benjamin Wootton
Founder & CTO
ClickHouse Cloud And Hex Are A Great Stack For Analytics And Data Science
Two of our favourite tools which combine to be a brilliant serverless stack for data and analytics.
Benjamin Wootton
Founder & CTO
Forecasting Using ClickHouse Machine Learning Functions
This article is part of a series where we look at doing data science work within ClickHouse
Benjamin Wootton
Founder & CTO
How We Built A Crypto Analytics Platform Based On ClickHouse
A walkthrough of our architecture for a DeFi analytics platform.
Benjamin Wootton
Founder & CTO
Combining dbt And ClickHouse
Learn how to effectively combine dbt and ClickHouse for data transformation and analytics. Discover best practices, use cases, and implementation strategies for leveraging dbt's transformation capabilities with ClickHouse's high-performance database.
Benjamin Wootton
Founder & CTO
Why We Went "All In" On ClickHouse
ClickHouse is a uniquely differentiated database which we decided to take a big bet on.
Benjamin Wootton
Founder & CTO
Controlling Memory With ClickHouse Group Bys
Learn how to control memory usage when performing GROUP BY queries on large datasets in ClickHouse.
Benjamin Wootton
Founder & CTO
Bring us your hardest ClickHouse challenge.
From architecture and migration to performance engineering and managed support, we help businesses move from decisions to dependable production systems.