Connect to Managed ClickHouse® with Node.js

Learn how to connect to your Managed ClickHouse® service with Node.js using the official Node.js client for connecting to ClickHouse and the HTTPS port.

Prerequisites

• Node.js in your environment
• Node.js client for connecting to ClickHouse

npm i @clickhouse/client

Identify connection information

To run the code for connecting to your service, first identify values of the following variables:

Connect to the service

Replace the placeholders in the code with meaningful information on your service connection and run the code.

import { createClient } from "@clickhouse/client"

const client = createClient({
    url: "CLICKHOUSE_URL",
    username: "CLICKHOUSE_USER",
    password: "CLICKHOUSE_PASSWORD",
    database: "default",
})
const response = await client.query({
    query : "SELECT 1",
    format: "JSONEachRow",
    clickhouse_settings: {
        wait_end_of_query: 1,
    },
})
const data = await response.json()
console.log(data)

Now you have your service connection set up and you can proceed to uploading data into your database.

For information on how to connect to the Managed ClickHouse service with the ClickHouse client, see Connect with the ClickHouse client.