Hanzo Datastore

Hanzo Datastore is a managed, column-oriented analytics database for OLAP workloads. It runs sub-second aggregations over billions of rows using a ClickHouse-compatible engine, exposed over SQL, an HTTP interface, and the native binary protocol.

Provision a Datastore

Each datastore is a logical resource scoped to your organization and provisioned through the control plane.

curl -X POST https://api.hanzo.ai/v1/datastore \
  -H "Authorization: Bearer sk-..." \
  -H "X-Org-Id: org_a1b2c3" \
  -H "Content-Type: application/json" \
  -d '{ "name": "events" }'

The response returns the SQL/HTTP endpoint and credentials.

Query

Datastore speaks SQL over HTTP (port 8123) and the ClickHouse native protocol (port 9000), so ClickHouse clients and drivers connect directly.

Features

• MergeTree engine family with primary-key ordering, partitioning, and TTL
• Real-time inserts with background merges — no batch load windows
• Materialized views for incremental roll-ups and pre-aggregation
• Columnar compression that routinely reaches 10x or better
• Distributed queries and replication for horizontal scale
• Reads cold data directly from Storage (S3-compatible buckets)

Datastore is built for append-heavy analytics — events, logs, metrics, and time series — not transactional workloads. For OLTP, use SQL.

Related

• Analytics engine reference — the full SQL surface and table engines
• SQL — managed PostgreSQL for transactional data
• Storage — S3-compatible object storage for cold data
• API Keys — authenticate with sk- keys
• API Reference — every endpoint at api.hanzo.ai