Scalable, Cost-Effective Managed ClickHouse® Infrastructure for Blockchains

Blockchain data infrastructure is expensive. Teams building indexers, APIs, and analytics platforms face a familiar tradeoff: pay for managed services that don't quite fit, or absorb the operational burden of running it yourself.

We've spent years operating data infrastructure at scale across over a hundred of blockchain networks. We've felt this pain firsthand. And we've solved it.

Today, we're extending that solution to the broader blockchain ecosystem as part of the Numia Data Cloud.

The Problem Every Blockchain Data Team Faces

ClickHouse® technology has become the database of choice for blockchain analytics. It's fast, it handles the volume, and it speaks SQL. But at scale, the operational reality gets painful.

Managed ClickHouse works well for real-time workloads, but becomes prohibitively expensive for warehouse queries. Most teams end up running a separate system for heavy analytics and spending engineering time keeping data synchronized.

Self-hosted ClickHouse means managing replicas, capacity planning, and waiting days to scale. Every new replica copies the entire dataset. A single large query can starve your production API.

The result: teams either overpay, underperform, or burn engineering cycles on infrastructure instead of product.

What We Built

At Numia, we operate near petabyte-scale blockchain data infrastructure serving billions of API requests. By late 2024, we hit a wall. We were running ClickHouse for real-time APIs, BigQuery for warehouse workloads, and hundreds of jobs keeping everything synchronized. Costs were unsustainable.

We needed a different architecture: separated storage and compute, workload isolation, and the ability to scale in seconds. We partnered with ObsessionDB to build exactly that.

After six months in production across Numia's infrastructure:

• •75% reduction in infrastructure costs
• •Two systems consolidated into one
• •Over 500 sync jobs eliminated
• •Scaling time reduced from days to seconds

Now Available to the Blockchain Ecosystem

This technology now powers all of Numia's core products: our Data Warehouse, Real-Time APIs, and Analytics platform. If you're a Numia customer, you're already benefiting.

But we're also making this available directly to teams building their own blockchain data infrastructure.

Blockchain foundations running analytics platforms and public dashboards can dramatically reduce infrastructure spend while improving reliability.

Protocol teams building indexers and APIs can scale elastically without overprovisioning or waiting for replicas.

Infrastructure providers serving the ecosystem can offer more competitive pricing by lowering their own costs.

If you're running ClickHouse workloads for blockchain data and spending more than $5,000 per month, this architecture can likely cut that in half.

Part of the Numia Data Cloud

This fits into our broader vision. When we announced Numia's evolution into the Blockchain Data Cloud, we committed to enterprise-grade infrastructure for any chain, any protocol, at any scale.

Scalable, cost-effective ClickHouse is foundational to that promise. It's how we deliver reliable, real-time APIs, fast warehouse queries, and analytics that don't break the budget.

And now it's how we help the broader ecosystem do the same.

Get Started

Already using Numia? You're running on this architecture today. Expect continued improvements in performance and cost efficiency.

Building your own infrastructure? We offer free workload assessments. Send us your current ClickHouse setup and we'll show you what the numbers could look like.

Any chain. Any scale. Half the cost.