ClickHouse Hosting Live In 5 Minutes
ClickHouse hosting gives you a self-hosted columnar database for analytical queries, on a server you rent at a flat monthly price. Deploy ClickHouse from the OneClick catalog, choose the admin username, and xCloud serves the HTTP interface and the built-in /play SQL console over HTTPS, protected by a generated password, with your tables on a persistent volume you can back up and restore yourself.
- No terminal
- No technical skills needed
- No lock-in, cancel anytime
What is ClickHouse?
Self-hosted ClickHouse is a columnar database: an open-source, column-oriented database management system, licensed under Apache-2.0, that generates analytical data reports in real time using SQL. Its README points to ClickHouse Cloud as the hosted service from its creators, which is the managed alternative to running it yourself. As a self-hosted server it is an alternative to hosted warehouses such as Snowflake and BigQuery, for workloads one machine can hold.
On xCloud the template runs the official ClickHouse 26.3 LTS image as a single server, pinned by digest, with every database and table under /var/lib/clickhouse on the clickhouse_data volume. Only the HTTP interface is published, over HTTPS; the native port 9000 is not, and there is no clustering. xCloud generates a 24-character admin password and removes the default user.
From Sign-Up to Your First Query In Just 3 Easy Steps
A reachable ClickHouse normally needs a container, a volume, an authenticated HTTP endpoint and a certificate. This ends at a SQL prompt in your browser.
Step 01
Sign Up
Create your xCloud account and pick ClickHouse from the OneClick catalog. Choose a domain and a server; the only install field is the admin username, which defaults to admin.
Step 02
We Deploy It For You
One click. We run clickhouse/clickhouse-server 26.3 LTS, pinned by digest, mount the clickhouse_data volume at /var/lib/clickhouse, remove the passwordless default user and publish port 8123 over HTTPS.
Step 03
Run Your First CREATE TABLE
Open the /play URL from the credentials panel, sign in with the generated password and run CREATE DATABASE analytics, then CREATE TABLE. Point an HTTP client at the same endpoint to load data.
Not Just Fast — Built For Analytics From The Ground Up
ClickHouse is a column store for analytical reports, a different job from the row store behind your application.
Column-Oriented Engine
A database management system built to generate analytical data reports in real time, queried with ordinary SQL over tables stored by column.
Built-In /play Console
A web SQL console served at /play on your domain, behind the generated admin account, so the first query needs no client install.
Full SQL Over HTTP
The HTTP interface takes DDL, DML, INSERT … SELECT, materialized views and dictionaries, and returns formats such as JSON, Parquet, Arrow and Avro.
Server-Side Ingestion Engines
For large or continuous loads, engines such as S3, S3Queue, Kafka and PostgreSQL pull data in directly, bypassing the proxy's request-size cap.
HTTP Client Support
Python clickhouse-connect, Node @clickhouse/client, Go and JDBC in HTTP mode, plus Grafana, Metabase, Superset and DBeaver, connect to the HTTPS endpoint.
No Anonymous Access
The passwordless default user is removed on first launch, so unauthenticated and default-user requests get a 401 at the endpoint.
Everything You Need To Run Your Analytics Database 24/7
Hosting for a database whose whole point is that you can throw analytical queries at it.
- ClickHouse 26.3 LTS deployed instantly
- Image pinned by digest
- Persistent clickhouse_data volume
- Generated admin password
- Free SSL certificate
- Server backups and snapshots
- Server security updates included
- 30+ server locations
- Unused balance refunded
What You Can Do With ClickHouse
ClickHouse server hosting for product analytics
A product team streams event data into one ClickHouse server and charts it in Grafana or Metabase over the HTTPS endpoint, with the data on a server it controls rather than in a warehouse account.
Keep a log and event store you can query in SQL
An engineer lands application events on the server with the Kafka or S3Queue engine, then answers incident questions with SQL in the /play console.
Load Parquet files straight into tables
A data team points the S3 engine at a bucket of Parquet exports and inserts the rows server-side, which keeps big loads clear of the proxy's request-size cap.
Add an analytics store beside PostgreSQL
A developer keeps the transactional database for the app and reads rows into ClickHouse with the PostgreSQL engine, so reporting queries leave the main database alone.
ClickHouse vs Alternatives
- ClickHouse Cloud
- The hosted service built by ClickHouse's creators, according to the README. The template here is one self-managed server on your Cloud VPS, with no clustering and no hosted control plane.
- Snowflake
- A hosted cloud data warehouse, as is Google BigQuery. ClickHouse here is a server you run, with SQL over HTTP, so you decide the size, the network exposure and where the data sits.
- PostgreSQL
- PostgreSQL has its own OneClick page for application databases. ClickHouse is the column-oriented store you add beside it for analytical reports, and its PostgreSQL engine can read rows from a PostgreSQL server.
- TimescaleDB
- TimescaleDB also has its own OneClick page on xCloud. ClickHouse takes a different starting point: it is column-oriented from the start and built to generate analytical data reports in real time with SQL.
Ready To Own Your Analytics Database?
ClickHouse on xCloud runs on a dedicated Cloud VPS that we provision, patch, monitor and restore. The data, the queries and the memory limits you set stay under your control.
Fast Provisioning
Deploy faster using an xCloud Managed Server built with optimized stacks and high-speed SSDs.
Enterprise-grade security
Protect your infrastructure with a free SSL certificate and more advanced security features at no additional cost.
Intuitive Control Panel
From Server creation to application deployment, everything can be managed from our intuitive control panel.
Hear what people are saying about us
See why agencies, developers, startups, and growing businesses choose xCloud to power their projects.
xCloud works really well, I am surprised by its performance being this the release version, I have tried many paid platforms such as runcloud, cloudpages or serveravatar, as well as free platforms such as CyberPanel, CloudPanel or Hestia Control Panel and direct competitors such as SpinupWP and FlyWP. Of all those that I have tried, the platform that works best for WordPress is SpinupWP and I believe that xCloud can reach and surpass that development, its roadmap is promising. Congratulations to the xCloud team, I hope they become the leading platform in the segment, it has all the potential to achieve it!
Brian GeovannyI've been with runcloud for the last 3 years. However, after trying xcloud for the last month, I'm switching over. They are on a roll with their setup.
Kevin PinedaI'm moving my servers to xCloud, a cloud control panel by M Asif Rahman and the WPDeveloper team. Their roadmap looks interesting and no, there are no team mates nor API limits with xCloud! #xCloud #wordpress #hosting
Leo KooHow Cloud Nine Web Elevated Client Experience While Streamlining Hosting Operations using xCloud
Ed EllinghamxCloud is like having an expert server team on call — without the big agency costs. It's given me back my time and given my clients peace of mind. Highly recommended for freelancers and small teams who want reliable performance and security.
Dumitru ButucelxCloud isn't just a solution. It's like one of that friend who got your back when you screw things up pretty bad.
Waqar AhmedTrust me when I say, once people explore the potential of xCloud they gonna switch from other panels, just keep delivering the best tech, lots of love for the team 😍😍
Rahul SinghSo far my experience has been smooth like silk. I didn't imagine that configuring and managing a VPS would be so easy. As of today, I have deployed 8 sites. The support is good, and they treat users with respect, even if they ask stupid questions (myself included). For the future, I hope for greater flexibility in scheduled backups and more comprehensive and consistent documentation. I'm sure that within a few months, xCloud will become the leader in its segment. This community is amazing, and the Staff here is super helpful.
Massimo VillaCame from cloudways then to runcloud then to xcloud. Looks like I'm staying here.
Gerson ElI've recently taken all of my Vultr-hosted sites and gotten rid of cPanel for them to substitute it with xCloud. I have to say, I'm really impressed with xCloud so far! The interface is definitely the standout feature for me.
Tony LewisI came from Cloudways and won't go back. Highly impressed with xCloud. Glad I gave them a chance.
Jared McDowellI like xCloud better than RunCloud, but one thing I'll point out is that some years ago RunCloud was hungry for business, the support was outstanding, and the community was active and helped each other. Maybe it was sold, there was a change in management, or they stopped being hungry, but the quality of the RunCloud offering declined and it hasn't been moving forward quickly. My point is that currently the xCloud team has the edge and it is theirs to keep or lose
David McCanHow Kevin Heinrichs Cut Hosting Costs by 84% While Running WooCommerce & Node.js Sites Efficiently
Kevin HeinrichsI had 150 sites on cloudways and am in the process of moving them to xcloud. Much faster and better priced.
Dan SpinozaDear xCloud Team, I have been using xCloud for some time now and am genuinely impressed with its capabilities and the flexibility it offers by allowing users to bring their own VPS for management. It's a fantastic service, and my experience so far has been very positive. Successful migrated 5 sites on a single server. Xcloud migration tool worked great. There were few hiccups with security plugin like MalCare but disabling the plugin prior to migration worked just fine.
Rahil MaknojiaCame from runcloud. Tried xcloud and never came back.
Karl FanegaHow Advanced Web Strategies Saved Over $2,000 & Recovered 56 Hours per Month Managing 70+ Client Websites
Gary MoodyxCloud gave me what no other hosting platform could: the flexibility of a VPS with the convenience of managed WordPress. As a solo founder running an entire business on one server, that combination is an important unfair advantage.
Jorge de los Reyes MartínezI use Server Avatar and xCloud and I'll sooner use xCloud than Server Avatar personally.
Jay PaganoHow Newman Web Solutions Ensured Perfect Uptime and Seamless Scaling For 120+ WordPress Sites with xCloud
Lori NewmanI too have moved over to xCloud. It's pretty sweet. One click n8n and uptime Kuma apps
John ApertureI went from Cloudways to xCloud. No intention on switching in the foreseeable future.
Blaine MooreFrequently Asked Questions
Feel free to contact us with any questions or concerns you may have.
What is ClickHouse used for?
Real-time analytical reporting. Upstream describes it as a column-oriented database that generates analytical data reports in real time using SQL, and the template tags it for OLAP and data warehousing. It is not meant for the many small updates an application's own database handles.
Is ClickHouse free to self-host?
Yes. ClickHouse is open source under the Apache License 2.0, so the software costs nothing to run. Your xCloud bill covers the Cloud VPS and its setup. The hosted ClickHouse Cloud service is a separate offering from its creators.
How do I run ClickHouse with Docker?
On xCloud, ClickHouse Docker hosting is one click: the template starts the official clickhouse/clickhouse-server image, pinned by digest, with the data volume, nofile limits, a localhost-bound port 8123 and the HTTPS proxy already set up. There is no compose file to write.
How much RAM does ClickHouse need?
The manifest asks for 2048 MB of RAM, 1 CPU core and 5 GB of disk, and this page sells the 6 GB tier. Per-query memory limits are unbounded by default, so one heavy query can use all the RAM. Set max_memory_usage and size the server to your data and concurrency.
How do I back up ClickHouse?
Back up the clickhouse_data volume, which holds all databases, tables and access-management users. For a consistent online backup, use ClickHouse's BACKUP command, for example to an S3 target, rather than copying files from a running server, and test a restore before you rely on it.
How do I upgrade ClickHouse?
Manually. The image is pinned to 26.3 by digest and a catalog re-sync does not upgrade existing installs. Take a BACKUP, read the upgrade notes (do not skip far ahead of adjacent releases), keep the volume, change the image, then verify reads. Never use docker compose down -v.
What is the difference between ClickHouse and PostgreSQL?
ClickHouse is column-oriented and made for analytical reports; PostgreSQL is a relational database for application workloads. They work together: keep transactions in PostgreSQL and move event data into ClickHouse, which can read from a PostgreSQL server with its built-in engine.
Can ClickHouse replace Snowflake?
For some analytical workloads, but check what you use. This template is one self-managed server with no clustering, replication or hosted control plane. If a single server with SQL over HTTP covers your reports, you can run them on a Cloud VPS you size yourself, with the data on your own volume.
How do I connect to a self-hosted ClickHouse server?
Over HTTPS with the admin username and password, as basic auth, query parameters or the X-ClickHouse-User and X-ClickHouse-Key headers. Port 9000 is not published, so clickhouse-client and native drivers cannot connect; use HTTP clients such as clickhouse-connect or the Node client.
Who owns the data on a self-hosted ClickHouse?
You do. Databases and tables sit on the clickhouse_data volume of your own server, and xCloud runs only the server and the deployment. Rotate the admin password by editing CLICKHOUSE_PASSWORD in the Environment editor and redeploying, then update every client.
Are there limits on uploads or protocols?
Yes, two. The HTTPS proxy caps a single request body at about 100 MB, so batch client INSERTs below that or load bulk data with server-side engines such as S3 or Kafka. And only the HTTP interface is published, so native-protocol drivers will not connect.
Can I cancel anytime?
Yes. There is no lock-in — cancel any time. Hosting is billed monthly and charged for what you actually use, so when you delete the server the unused balance is refunded to your account, less up to 10% in payment-processing fees.
More Databases apps in one click
Browse all Database apps →Browse all one-click apps →AdminerSingle-file web console to browse, query, edit and export MySQL, MariaDB, PostgreSQL and SQLite databases you already run.
Apache CouchDBA document database that speaks HTTP and stores JSON, with multi-master replication that syncs to other CouchDB nodes and to PouchDB running in the browser.
Apache SolrAn enterprise search and indexing server with faceting, rich document handling and a JSON API, behind an authenticated admin interface.
ArangoDBA multi-model database that stores graphs, JSON documents and key-value data and queries them all with one language, AQL, behind a generated root password.
ArcadeDBOpen-source multi-model database for graph, document, key-value, full-text, vector, geospatial and time-series data, with an HTTP API and Studio.BaserowOpen-source no-code database and application builder for spreadsheet-style tables, forms and workflows.
Cassandra ReaperRepair scheduling and management dashboard for Apache Cassandra clusters you already run, with a REST API and a login-protected web UI.
ChartDBOpen-source database schema diagram editor. Import schema JSON, explore and edit an ERD, then export SQL, JSON, or an image without connecting ChartDB to your database.ChromaOpen-source vector database and search infrastructure for AI applications, semantic search, embeddings, and retrieval-augmented generation (RAG).
Ready to Own Your Analytics Database?
Connect your first server in minutes. No plan you have to grow into.