Skip to main content

​
Install ClickHouse on Windows with WSL

​
Requirements

To install ClickHouse on Windows you will need WSL (Windows Subsystem for Linux).
1

​
Install WSL

Open Windows PowerShell as administrator and run the following command:
wsl --install
You will be prompted to enter a new UNIX username and password. After you have entered your desired username and password you should see a message similar to:
Welcome to Ubuntu 24.04.1 LTS (GNU/Linux 5.15.133.1-microsoft-WSL2 x86_64)
2

​
Install ClickHouse via script using curl

Run the following command to install ClickHouse via script using curl:
curl https://clickhouse.com/ | sh
If the script has successfully run you will see the message:
Successfully downloaded the ClickHouse binary, you can run it as:
  ./clickhouse
3

​
Start clickhouse-local

clickhouse-local allows you to process local and remote files using ClickHouse’s powerful SQL syntax and without the need for configuration. Table data is stored in a temporary location, meaning that after a restart of clickhouse-local previously created tables are no longer available.Run the following command to start clickhouse-local:
./clickhouse
4

​
Start clickhouse-server

Should you wish to persist data, you’ll want to run clickhouse-server. You can start the ClickHouse server using the following command:
./clickhouse server
5

​
Start clickhouse-client

With the server up and running, open a new terminal window and run the following command to launch clickhouse-client:
./clickhouse client
You will see something like this:
./clickhouse client
ClickHouse client version 24.5.1.117 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 24.5.1.

local-host :)
Table data is stored in the current directory and still available after a restart of ClickHouse server. If necessary, you can pass -C config.xml as an additional command line argument to ./clickhouse server and provide further configuration in a configuration file. All available configuration settings are documented here and in the example configuration file template.You’re now ready to start sending SQL commands to ClickHouse!