ClickHouse

Database2048MB+ RAM

Fast open-source OLAP database for real-time analytics

Download Server Compass View Documentation

databaseolapanalyticscolumnar

Deploy ClickHouse in 3 Steps

Connect Your VPS

Add your server credentials to Server Compass

Select ClickHouse

Choose from our template library

Deploy & Configure

Fill in settings and click Deploy

No Docker knowledge required

Video Tutorials

Learn How to Deploy ClickHouse

All tutorials

Self Host ClickHouse on VPS — Install + Manage with GUI and Database Command feature

Learn how to self-host ClickHouse on your VPS and manage it with GUI tools and database commands using Server Compass.

Watch tutorial

Manual Deployment Guide

Manual ClickHouse Setup

For terminal enthusiasts: deploy ClickHouse manually with these simple steps.

Access Your VPS via Terminal

Open a terminal session and log into your VPS. Replace the placeholder with your actual IP.

terminal

# Connect via SSH
ssh root@your-vps-ip

# Alternative with key file
ssh -i /path/to/key root@your-vps-ip

First time? Make sure Docker is installed on your VPS. Run: curl -fsSL https://get.docker.com | sh

Set Up Project Folder

Create a workspace for your deployment files.

terminal

# Create and navigate to project directory
mkdir -p ~/apps/clickhouse
cd ~/apps/clickhouse

Create the Compose File

Configure your containers with this Docker Compose setup:

docker-compose.yml

services:
  clickhouse:
    image: clickhouse/clickhouse-server:latest
    ports:
      - "8123:8123"
      - "9000:9000"
    environment:
      - CLICKHOUSE_USER=default
      - CLICKHOUSE_PASSWORD=<your-clickhouse-password>
      - CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT=1
    volumes:
      - clickhouse_data:/var/lib/clickhouse
      - clickhouse_logs:/var/log/clickhouse-server
    restart: unless-stopped
    ulimits:
      nofile:
        soft: 262144
        hard: 262144

volumes:
  clickhouse_data:
  clickhouse_logs:

Environment Configuration

PORTHTTP port(default: 8123)

NATIVE_PORTNative protocol port(default: 9000)

CLICKHOUSE_USERUsername(default: default)

CLICKHOUSE_PASSWORDPassword

Deploy Your Stack

Spin up the containers and verify the deployment.

terminal

# Start all services
docker compose up -d

# List running containers
docker compose ps

# Watch the logs
docker compose logs -f

Update Firewall Settings

Allow incoming traffic on the application port.

terminal

# Allow the application port through firewall
sudo ufw allow 8123/tcp
sudo ufw reload

# Access your app at:
# http://your-server-ip:8123

Skip the Terminal

Skip the terminal. Use Server Compass instead.

Deploy ClickHouse without touching the command line. Server Compass gives you a clean UI for one-click deployments.

Beautiful interface
One-click deploys
Let's Encrypt SSL
Zero downtime
Container monitoring
Easy rollbacks

Download Server Compass$29 one-time • Lifetime license

After Deployment

After deploying ClickHouse with Server Compass, complete these steps to finish setup

Test connection via HTTP or native client

Create databases and tables

Set up data ingestion pipelines

Need help? Check out our documentation for detailed guides.

ClickHouse FAQ

Common questions about self-hosting ClickHouse

How do I deploy ClickHouse with Server Compass?

Simply download Server Compass, connect to your VPS, and select ClickHouse from the templates list. Fill in the required configuration and click Deploy. The entire process takes under 3 minutes.

What are the system requirements for ClickHouse?

ClickHouse requires a minimum of 2048MB RAM. We recommend a VPS with at least 4096MB RAM for optimal performance. Any modern Linux server with Docker support will work.

Can I migrate my existing ClickHouse data?

Yes! Server Compass provides volume mapping that allows you to import existing data. You can also use standard ClickHouse backup and restore procedures.

How do I update ClickHouse to the latest version?

Server Compass makes updates easy. Simply click the Update button in your deployment dashboard, and the latest ClickHouse image will be pulled and deployed with zero downtime.

Is ClickHouse free to self-host?

ClickHouse is open-source software. You only pay for your VPS hosting (typically $5-20/month) and optionally Server Compass ($29 one-time). No subscription fees or per-seat pricing.