Skip to content
← All services

Databases

Managed ClickHouse on your own cluster

ClickHouse for analytics: aggregations over billions of rows, managed by the Altinity operator.

Created inside a project, beside the apps that use it. Each project gets its own instance, storage and credentials.

01What it does

ClickHouse, run for you

ClickHouse 24.8 or 25.3 on the Altinity operator.

A column store for the questions a row store answers slowly: event tables, metric tables, and the dashboards you would rather own than rent. ClickHouse trades memory for query speed, so the size is the knob that decides how big a query stays fast.

Bound apps get the HTTP and native ports beside the database, username and password. The HTTP interface can be published on a hostname of its own for tools that speak it, and the native port can be opened on a public cluster for clients that need it.

02Options

What you choose

What the console asks when you create it, in the catalog's own numbers. Anything marked chosen once cannot change without creating a new instance.

Sizes
small 0.25 CPU / 1Gi, medium 1 / 4Gi, large 2 / 8Gi
Storage
20Gi by default; grows later if the storage class supports expansion
Versions
25.3 (default) or 24.8, chosen once
Pause
Yes; the volume is kept
Hostname
The HTTP interface (8123) can be published on a domain
Public port
The native port (9000) can be opened on a public cluster

03Binding

What your app receives

Bind it to an app and these arrive as environment variables. The values are generated once into a secret and reach the app from there, rather than as something you copy.

  • CLICKHOUSE_HOST
  • CLICKHOUSE_PORT
  • CLICKHOUSE_NATIVE_PORT
  • CLICKHOUSE_DATABASE
  • CLICKHOUSE_USERNAME
  • CLICKHOUSE_PASSWORD
  • CLICKHOUSE_URL

04Adding it

Add ClickHouse to a project

The same four steps as every service in the catalog.

  1. 01Open a project and go to Services.
  2. 02Pick it from the catalog and choose its options. Only the size is required; everything else has a default.
  3. 03Create it. Anyport installs it into the project's namespace, generates its credentials into a secret there, and tracks its health.
  4. 04Bind it to an app. The connection details arrive as environment variables, and rotating the credential never means editing an app.
Open the console →How services work →

Also under Databases