---
title: "Deploy ClickHouse"
description: "Fast open-source column-oriented database for analytics"
category: "Analytics"
url: https://railway.com/deploy/clickhouse-2
---

# Deploy ClickHouse

Fast open-source column-oriented database for analytics

**[Deploy ClickHouse on Railway](https://railway.com/template/clickhouse-2)**

Machine-readable deploy manifest (JSON, validated by TemplateCI): https://railway.com/deploy/clickhouse-2/manifest.json

- **Creator:** zer0person's Projects
- **Category:** Analytics
- **Total deploys:** 1

## Template content

### ClickHouse

- **Image:** clickhouse/clickhouse-server:latest
- **Public domain:** Yes

## Documentation

# Deploy and Host ClickHouse on Railway

[ClickHouse](https://github.com/ClickHouse/ClickHouse) is a column-oriented SQL database built for real-time analytics over very large datasets.

## About Hosting ClickHouse

This template runs the official `clickhouse/clickhouse-server:latest` image with a persistent volume at `/var/lib/clickhouse`. The `default` user is protected by a random `CLICKHOUSE_PASSWORD` generated into the service variables: read it in the Variables tab. The public URL exposes the HTTP interface (port 8123): check `/ping`, and run queries with `curl --user default: --data 'SELECT 1' https:///`. The native TCP protocol is not exposed.

## Common Use Cases

- Product and event analytics over billions of rows
- Log and metrics storage queried with SQL over HTTP
- Backend for dashboards such as Grafana or Metabase

## Dependencies for ClickHouse Hosting

- One service with a volume; nothing else

### Deployment Dependencies

- [ClickHouse on GitHub](https://github.com/ClickHouse/ClickHouse)
- [Docker image](https://hub.docker.com/r/clickhouse/clickhouse-server)

## Why Deploy ClickHouse on Railway?

Railway gives you a public HTTPS URL, persistent storage where needed and automatic restarts with no server to maintain. Use the HTTP interface with the generated password right away.


## Similar templates

- [Plausible WordPress](https://railway.com/deploy/deploy-plausible-for-wordpress-sites) — Cookie-free WordPress stats from your own Plausible
- [Typesense Multilingual](https://railway.com/deploy/deploy-typesense-multilingual-search) — Locale-aware multilingual search with Typesense
- [Formbricks](https://railway.com/deploy/formbricks-surveys) — Surveys, NPS and in-app feedback on your own Postgres, Hub and Cube

Open this page in a browser: https://railway.com/deploy/clickhouse-2
