ClickHouse on Unbroker

Fast open-source column database for real-time analytics

Deploy ClickHouse Template source Read Markdown

Plan requirements

Template container services, databases and persistent volumes require Pro. Resource usage is billed separately. Review the configuration and pricing before deploying. View pricing

Deployment inputs

CLICKHOUSE_PASSWORD Required: Password for the "default" user. Every query over the public URL needs it, so make it long.

Deploy button

Add this to a README or website. It opens this template's deploy form in Unbroker Cloud. Button guide

[![Deploy on Unbroker](https://unbroker.cloud/button.svg)](https://app.unbroker.cloud/apps?template=clickhouse)

The open-source column-oriented database for real-time analytics: SQL over billions of rows in milliseconds, with compression that keeps the disk small.

What gets deployed

Service	Image	Notes
ClickHouse	`clickhouse/clickhouse-server:26.8.27.9` (LTS)	Public HTTP interface. Data on a 10 GB volume

After deploy

Your URL serves ClickHouse’s HTTP interface over HTTPS. Sign in as default with the password from the deploy form:

In the browser: open https://<your-url>/play for the built-in SQL console.

From code: any HTTP client, e.g. Python’s clickhouse-connect:

import clickhouse_connect
client = clickhouse_connect.get_client(host="<your-url>", port=443, secure=True,
                                       username="default", password="…")

curl:

curl -u default:… https://<your-url>/ --data-binary "SELECT version()"

default can manage access: create a user per app with CREATE USER … IDENTIFIED BY … and GRANT.

Good to know

Only the HTTP interface is exposed. The native TCP protocol (port 9000, used by clickhouse-client) is not reachable from outside. Use clickhouse-client from inside the project, or an HTTP client.
Changing CLICKHOUSE_PASSWORD and redeploying changes the default user’s password.
ClickHouse uses up to 90% of the memory it is given. 2 GB or more is comfortable for real workloads.

Service configuration

ClickHouse: clickhouse/clickhouse-server:26.8.27.9. Public URL. 10 GiB persistent storage.

Project links

More templates

Directus: Instant REST and GraphQL API with a no-code admin app for any SQL database
Flowise: Build AI agents and LLM workflows visually
Ghost: Publishing platform for blogs, newsletters and memberships

Configuration and instructions from the public template repository. Check the application's license and complete the setup steps before using it in production.