Pyo
Pyo Cloud
Databasesby PyoOfficial template

Deploy ClickHouse on your own servers

Column-oriented database for fast analytics over large event tables.

Get started ClickHouse website

What Pyo sets up

Image
docker.io/clickhouse/clickhouse-server:24.8
Reached
Inside the cluster only
Runs as
One replica with its own data
Replicas
1
Requests
0.5 vCPU · 1 GiB
Limits
2 vCPU · 2 GiB
Storage
20 GiB at /var/lib/clickhouse
Health check
HTTP /ping

What you can configure

  • Userapp
  • Initial databaseapp
  • PasswordGenerated, or your own

    Leave empty to generate one.

How to deploy it

  1. 1

    Install Pyo

    Run the setup command on your server.

  2. 2

    Choose ClickHouse

    Open Templates in the dashboard and pick it. Pyo fills in sensible defaults.

  3. 3

    Deploy

    Pick a server and deploy. Pyo runs it and follows the rollout.

Ports

  • http 8123/HTTPPrivate
  • native 9000/TCPPrivate

Good to know

  • Query over HTTP on 8123, or with clickhouse-client on 9000.
  • Give it memory: large queries fail when they hit the limit.

Related templates

All templates

Get Pyo running on your server

Run Pyo on any machine, from your laptop or VPS to a dedicated server or homelab.

curl -fsSL https://pyo.dev/install.sh | bash
View on GitHub