1
Step 1Open the server Apps tab
Select the tutorial-vps VPS, open the Apps tab, and start a new app deployment. Keep sensitive server details hidden before capturing or sharing screenshots.
Back to all templates
ClickHouse
Database2048MB+ RAM
Fast open-source OLAP database for real-time analytics
databaseolapanalyticscolumnar
Deploy ClickHouse in 3 Steps
1
Connect Your VPS
Add your server credentials to Server Compass
2
Select ClickHouse
Choose from our template library
3
Deploy & Configure
Fill in settings and click Deploy
No Docker knowledge required
Step-by-step deployment guide
Deploy ClickHouse on a VPS with Server Compass
Use the ClickHouse template in Server Compass to deploy an OLAP analytics database on your VPS, then verify it with clickhouse-client.
About 10 minutesBrowser verified
2
Step 2Choose an app template
Click New App and choose the template deployment path so Server Compass can load the built-in catalog.
3
Step 3Search for ClickHouse
Use the template picker search to find ClickHouse in the Server Compass template catalog.
4
Step 4Select the ClickHouse template
Choose the ClickHouse template. Server Compass fills the ClickHouse container, persistent data and log volumes, HTTP port, native protocol port, username, and generated password.
5
Step 5Review the ClickHouse settings
Confirm the app name and compose service. In this run, the app was named clickhouse-demo and used host port 8123.
6
Step 6Deploy ClickHouse
Review the generated environment values, keep the ClickHouse password masked, confirm the HTTP and native ports are available, and click Deploy Now.
7
Step 7Watch the deployment progress
Keep the deployment modal open while Server Compass uploads the compose file, pulls the ClickHouse image, starts the container, and verifies the stack.
8
Step 8Confirm ClickHouse is running
After deployment finishes, return to the Apps tab and confirm the ClickHouse app is marked Running with the database port available.
9
Step 9Verify ClickHouse is reachable
Open the app detail view and verify the running ClickHouse container. In this tutorial run, clickhouse-client returned a successful SELECT 1 result without exposing the generated password.
After ClickHouse Opens
- Store the generated ClickHouse password in a secure password manager.
- Create application-specific databases and users before production use.
- Restrict external access to ports 8123 and 9000 unless remote clients explicitly need them.
- Configure regular backups for the ClickHouse data volume before storing production data.
- Plan table engines, partitions, and retention policies before ingesting production analytics data.
Verified Result
The ClickHouse container returned 1 from an internal clickhouse-client query.
ClickHouse deployment questions
What does the ClickHouse template deploy?
It deploys a ClickHouse server with persistent data and log volumes, an HTTP interface, native client port, configured username, and generated password.
Which port did the tutorial use?
The tutorial used host port 8123, which maps to ClickHouse HTTP port 8123. The template also exposes the native client port.
Why is there no browser verification screenshot?
ClickHouse is a database service, not a web application. The tutorial verifies it with clickhouse-client inside the running container instead of opening a browser page.
Should this become a blog post?
No. The deployment guide should live on the ClickHouse template detail page and be linked from the reusable template deployment docs page.
Manual Deployment Guide
Manual ClickHouse Setup
For terminal enthusiasts: deploy ClickHouse manually with these simple steps.
1
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-ipFirst time? Make sure Docker is installed on your VPS. Run: curl -fsSL https://get.docker.com | sh
2
Set Up Project Folder
Create a workspace for your deployment files.
terminal
# Create and navigate to project directory
mkdir -p ~/apps/clickhouse
cd ~/apps/clickhouse3
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_PASSWORDPassword4
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 -f5
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:8123Skip 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
1
Test connection via HTTP or native client
2
Create databases and tables
3
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.
Ready to Self-Host ClickHouse?
Download Server Compass and deploy ClickHouse to your VPS in under 3 minutes. No Docker expertise required.
Download Server Compass