Connect ProbeDeck to ClickHouse

​

Before you begin

• Install ProbeDeck from the App Store.
• Use iOS or iPadOS 17.0 or later.
• Allow the device to reach the ClickHouse HTTP or HTTPS endpoint over its network, a VPN, or an SSH bastion.
• Create a ClickHouse user with access to the databases you want to query.
• Grant the user SELECT access to the relevant system tables for monitoring.

​

How it works

1. ProbeDeck sends SQL requests to the ClickHouse HTTP(S) endpoint.
2. It reads monitoring data from system tables with the configured ClickHouse user.
3. The app shows query results and monitoring views on the device. An SSH bastion can carry the same HTTP(S) connection when the endpoint has no direct route from the device.

​

Connect to ClickHouse Cloud

1

Gather the service connection details

In the ClickHouse Cloud console, open your service, select Connect, and choose HTTPS.To connect to ClickHouse with HTTP(S) you need this information:

Parameter(s)	Description
HOST and PORT	Typically, the port is 8443 when using TLS or 8123 when not using TLS.
DATABASE NAME	Out of the box, there is a database named default, use the name of the database that you want to connect to.
USERNAME and PASSWORD	Out of the box, the username is default. Use the username appropriate for your use case.

The details for your ClickHouse Cloud service are available in the ClickHouse Cloud console. Select a service and click Connect:

Choose HTTPS. Connection details are displayed in an example curl command.

If you’re using self-managed ClickHouse, the connection details are set by your ClickHouse administrator.

2

Add the connection in ProbeDeck

1. On the Connections screen, tap +.
2. Enter a connection name and the host without https://.
3. Set Port to 8443 and turn on TLS.
4. Enter the database username and password from the Connect dialog. The database name is optional.
5. Tap Test Connection. ProbeDeck shows the server version and round-trip time after a successful check.
6. Tap Save.

ProbeDeck authenticates SQL requests to the service endpoint with these database credentials. ClickHouse Cloud uses organization-level keys from the API Keys page for the Cloud API and Query API endpoints. ProbeDeck’s SQL connection flow does not use those keys.

​

Connect to self-hosted ClickHouse

​

Connect through an SSH bastion

1. The bastion host and SSH port (22 by default).
2. The SSH username.
3. Either an SSH password or a private key.

​

Configure authentication and TLS

​

Monitor ClickHouse

​

Query the UK property price dataset

1. Open the connection and select Data.
2. Open the SQL editor.
3. Run this bounded, read-only query:

SELECT
    town,
    count() AS sales,
    round(avg(price)) AS average_price
FROM uk_price_paid
GROUP BY town
ORDER BY sales DESC
LIMIT 10

​

Known limits

• ProbeDeck runs on iOS and iPadOS 17.0 or later.
• Free users can save one connection at a time. Deleting it frees the slot; ProbeDeck Pro allows unlimited saved connections.
• It supports the ClickHouse HTTP(S) interface, not the native protocol.
• ProbeDeck loads SQL results in pages of 200 rows and caps each request at 10,000 rows. Use a selective WHERE clause and LIMIT for large tables.
• Monitoring visibility depends on the ClickHouse user’s grants and on optional log tables.
• The device needs a route to the endpoint over its network, a VPN, or the built-in SSH tunnel.
• Monitoring and read-only SQL do not require an in-app purchase. KILL QUERY, KILL MUTATION, write and DDL statements, and other operational actions require ProbeDeck Pro.

​

Troubleshooting

​

Next steps

• See the ProbeDeck website for product-specific details.
• See the ClickHouse HTTP interface documentation for server configuration.