Analytics · ClickHouse

ClickHouse Analytics by Volade

HTTP queries and optional event INSERT from WordPress — amber dashboard, SELECT safety, connection test.

v1.0.0 · queries on

Realtime analytics from ClickHouse

Run default SELECT in wp-admin — optional server-side page_view INSERT when ingest is enabled.

Test connection

Settings · wp-admin

Host, database & credentials

https://host:8443, database name, masked password. Override via CHA_USER / CHA_PASSWORD.

connected
SettingValue
Host URLhttps://clickhouse.example:8443
Databaseanalytics
Password••••••••abcd (masked)
Event insertenabled

Query results table

SELECT with FORMAT JSON — read-only by default

hourviews
2026-07-24 14:00:00128
2026-07-24 15:00:00142
2026-07-24 16:00:0097

4 analytics presets

📊
Realtime Dashboard

Default SELECT queries

📡
Event Ingest

INSERT · page_view lite

🏢
Agency Report

Cached read-only KPIs

🛡️
Privacy Minimal

DNT · manual cha_track

REST, CLI & export

cha/v1REST namespace
wp chaWP-CLI
JSONFree export
HealthSite Health test
Endpoint / commandAction
GET cha/v1/statusConnection snapshot
POST cha/v1/queryRun SELECT
wp cha preset privacy-minimalApply privacy preset