SaaS · ClickHouse HTTP

ClickHouse Analytics by Volade

ClickHouse dashboards in wp-admin, read-only SQL by default.

Name: ClickHouse Analytics by Volade
Availability: InStock
Author: Volade

ClickHouse Analytics by Volade connects WordPress to your ClickHouse HTTP interface — saved queries, dashboard tiles, optional event ingest and privacy-minimal preset without a Volade account.

v1.0.0WordPress 6.0+PHP 7.4+No Volade account

Not rated yet0 views0 downloads

Download v1.0.0 Compare alternativesVirusTotal scan…See features

3-step workflow

1Copy ClickHouse HTTP endpoint and create a read-only user
2Volade → ClickHouse Analytics → paste credentials → test connection
3Apply realtime-dashboard preset — run saved queries in wp-admin

ClickHouse Analytics by Volade

Column-store analytics 2026

Ops wants warehouse KPIs — engineering shares another clickhouse-client one-liner

Metabase needs JVM ops. Tinybird is a different stack. Mixpanel won't run arbitrary SQL on your tables. Hand-rolled HTTP calls rot in mu-plugins.

Read-only

default query mode — writes blocked unless event-ingest preset

HTTP query runner, wp-admin dashboards, optional ingest log, 4 presets and free JSON export — ClickHouse host + credentials, read-only by default, no Volade account.

HTTP

Query interface

Read-only

Default safety

Analytics presets

JSON

Free export

At a glance

Data teams still leave WordPress for clickhouse-client or Metabase. ClickHouse Analytics by Volade v1.0.0 runs HTTP queries in wp-admin: real-time dashboard, optional ingest, read-only queries by default, four presets and JSON export — free without an account (ClickHouse credentials required).

Screenshots

Full-page real admin UI — presets, diagnostics and detailed settings.

2026 pricing comparison

Run Metabase DIY, or CHA at $0

Metabase Cloud and BI seats add up. Self-hosted Metabase needs patching. CHA ships WordPress → ClickHouse HTTP dashboards, read-only guard and privacy-minimal preset free.

Plugin free · your ClickHouse cluster · ClickHouse Cloud or self-hosted billing on your side

$85+/mo

Metabase Cloud / BI seats

ClickHouse Analytics by Volade

Why teams SSH to clickhouse-client — or rebuild Metabase — when editors need KPIs in wp-admin

Tinybird ships managed pipes. Mixpanel targets product funnels. Metabase DIY needs another server. Raw clickhouse-client skips WordPress presets. CHA runs read-only HTTP queries from wp-admin with optional event ingest and agency-report presets.

The SSH-and-SQL problem

You need ClickHouse in WordPress — not another BI login.

Editors won't SSH. Metabase is another host to patch. Tinybird is ideal for pipes but not your existing tables. Raw clickhouse-client skips presets, ingest logs and agency handoff.

KPIs live in ClickHouse — only devs run clickhouse-client
Metabase embeds don't match WordPress roles and presets
Optional ingest needs guardrails — ad-hoc writes risk production
Agency clients want wp-admin tiles — not JDBC strings
No wp-admin log when HTTP queries fail
No WP-CLI to export config across client sites

The Volade answer

HTTP credentials, presets, dashboards — from wp-admin.

CHA runs read-only ClickHouse HTTP queries by default, embeds dashboard tiles, optional event ingest with event-ingest preset, 4 presets and free JSON export — ClickHouse credentials only.

Dedicated Volade → ClickHouse Analytics dashboard
Query log with HTTP status and duration
Saved queries for realtime-dashboard preset
Optional event ingest — event-ingest preset with write guard
privacy-minimal preset — hashed ids and trimmed columns
4 presets: realtime-dashboard, event-ingest, agency-report, privacy-minimal
Free JSON export — config, presets, health
wp cha status | query | preset | export

4 ClickHouse presets

realtime-dashboard, event-ingest, agency-report or privacy-minimal — one click, credentials preserved.

Recommended📊

realtime-dashboard

Saved SELECT queries and KPI tiles — blogs and marketing sites.

Dashboard

📥

event-ingest

Optional WordPress event rows into staging tables — write guard enabled.

Ingest

📋

agency-report

Multi-site query pack and dashboard embeds for client reporting.

Agency

🔒

privacy-minimal

Minimal columns, hashed identifiers, read-only queries only.

Privacy

4 query surfaces

HTTP dashboards, read-only guard, optional ingest and privacy-minimal — visible in wp-admin.

HTTP queries

Saved SELECT over ClickHouse HTTP — realtime-dashboard preset.

Read-only default

Destructive SQL blocked — optional ingest via preset only.

Optional ingest

WordPress events to staging tables — event-ingest preset.

privacy-minimal

Trimmed columns and hashed identifiers — consent-friendly.

Read-only mode blocks INSERT/ALTER unless event-ingest preset is applied — use privacy-minimal for consent-first sites.

Before / after

Same site, ClickHouse query log

realtime-dashboard preset — rows returned, tiles refreshed.

Credentials

Read-only HTTP user saved — connection OK.

Preset

« realtime-dashboard » applied — KPI tiles only.

Dashboard

Query cache refreshed — tiles live in wp-admin.

Export

cha-config.json for agency handoff.

Log preview

realtime-dashboard — 842ms p95 · 12 queries today

Raw clickhouse-client over SSHno wp-admin tiles · no presets · ingest writes unguarded

ClickHouse Analytics by VoladeSELECT page_views · last_24h · read-only user · preset realtime-dashboard

Config exported as cha-config.json for the agency runbook.

Real scenarios

What changes after activation.

Launch marketing site

Before: Wait for weekly Metabase refresh

After: realtime-dashboard preset + HTTP tiles

Live KPIs

Warehouse ingest

Before: Unreviewed INSERT in theme

After: event-ingest preset + query log

Guarded writes

Agency client reporting

Before: Screenshot Metabase once a week

After: agency-report preset + wp-admin embeds

Client-ready view

EU privacy review

Before: Full row SELECT exports

After: privacy-minimal preset

Minimal columns

What Metabase DIY and raw clickhouse-client don't ship for WordPress

ClickHouse HTTP queries, wp-admin dashboards, optional ingest, 4 presets and export — read-only by default, no Volade account required.

ClickHouse HTTP credentials

Endpoint, user and password from wp-admin settings.

Read-only by default

Blocks destructive SQL unless ingest preset allows writes.

Saved query dashboards

KPI tiles from SELECT over your tables.

Query log

HTTP status and duration when queries fail.

Optional event ingest

WordPress events into staging tables — event-ingest preset.

4 analytics presets

realtime-dashboard, event-ingest, agency-report, privacy-minimal.

JSON export

Config, presets and health — free.

WP-CLI + REST

wp cha status/query/preset/export.

Complements Tinybird Analytics by Volade: CHA queries your own ClickHouse cluster over HTTP with read-only defaults — use Tinybird for managed realtime pipes and CHA when you already run ClickHouse.

What teams pay for WordPress + ClickHouse analytics

Public pricing July 2026 — managed pipes vs your own column store.

Paid

Tinybird (managed pipes)

$0–$

Fast Events API — not arbitrary SQL on your existing ClickHouse tables.

Paid

Mixpanel (product analytics)

$0–$

Great funnels — not wp-admin SQL dashboards on your ClickHouse schema.

Paid

Metabase DIY

$85+/mo

Another app to host — no WordPress presets or wp cha export.

Paid

Raw clickhouse-client

DevOps $

SSH and SQL files — no ingest log, presets or editor-friendly wp-admin.

Free

ClickHouse Analytics by Volade

HTTP queries from wp-admin, optional ingest, 4 presets, REST + wp cha.

Competitive analysis

WordPress + ClickHouse landscape 2026

Tinybird vs Mixpanel vs Metabase DIY vs raw clickhouse-client — CHA targets HTTP analytics inside WordPress on your cluster.

Tinybird

Managed realtime pipes and Events API.

Limit: Different product — not arbitrary SQL on your self-hosted ClickHouse tables.

Mixpanel

Product analytics and funnels.

Limit: Not wp-admin SQL dashboards on your ClickHouse schema.

Metabase DIY

Self-hosted or Cloud BI on ClickHouse.

Limit: Another app to host — no WordPress presets or wp cha.

Raw clickhouse-client

SSH and native client SQL.

Limit: No wp-admin dashboards, ingest log or agency presets.

Tinybird Analytics by Volade

WordPress → Tinybird streaming layer.

Limit: Complementary — use with CHA when you also run ClickHouse.

Do nothing

Guess metrics from server logs.

Limit: No warehouse KPIs for editors — ops flies blind.

Comparison table — 5 approaches

CHA vs Tinybird, Mixpanel, Metabase DIY and raw clickhouse-client.

Feature	CHA Volade	Tinybird	Mixpanel	Metabase DIY	clickhouse-client
wp-admin ClickHouse HTTP dashboards		~		~
Read-only SQL by default		~		~
Query / ingest log in wp-admin		~	~
4 analytics presets		~	~
Free JSON export		~	~	~
Optional WordPress event ingest				~	~
privacy-minimal preset		~	~	~
Integrated WP-CLI (wp cha)					~
No Volade account (core)
Typical plugin cost	$0	$0–$	$0–$	$85+	DevOps $

ClickHouse remains your column store — CHA is the WordPress HTTP layer with read-only defaults and optional ingest. Pair with Tinybird Analytics by Volade when you also stream events to Tinybird pipes.

Three tiers, one plugin

Queries, dashboards, optional ingest, presets and JSON export free. Volade account for REST. V+ for multisite rollup.

Free

No account

ClickHouse HTTP credentials
Read-only queries + dashboards
4 presets
Optional ingest preset
JSON export

Connected

Volade account

REST cha/v1
Query/tail via API
Scheduled export

Optional

V+ Premium

Multisite preset rollup
wp cha network export
Agency harmonization

WP-CLI `wp cha` and REST `cha/v1` to test queries, tail the ingest log, apply presets and export across staging and production.

WP-CLI

status, query, preset and export from SSH — `wp cha preset privacy-minimal`.

wp cha status
wp cha query --saved=page_views_24h
wp cha preset realtime-dashboard
wp cha preset privacy-minimal
wp cha export

Multisite

Query log per site; harmonized privacy-minimal on V+.

Log per blog
Consolidated JSON export
Agency network presets

Verified download

Download

Install the ZIP, paste ClickHouse HTTP endpoint and credentials, run a saved query — first dashboard tile in wp-admin in under a minute.

ZIP with Volade SDK — Volade → ClickHouse Analytics (or Settings → ClickHouse Analytics).

Download v1.0.0clickhouse-analytics-by-volade-1.0.0.zip

1Plugins → Add New → Upload → ZIP → Activate
2Volade → ClickHouse Analytics → paste HTTP endpoint, user and password (read-only user recommended)
3Apply realtime-dashboard preset → run saved query → optional event-ingest → export JSON

First query results in under 60 seconds

Running antivirus scan…

FAQ

ClickHouse credentials, read-only mode, optional ingest, presets, multisite and Volade account.

No. Paste ClickHouse HTTP endpoint and credentials — queries, dashboards and presets work without Volade signup.

Free vs V+ Premium

The extension works without an account. V+ unlocks premium on this extension and the full catalog.

Feature	Free	V+
ClickHouse HTTP credentials + read-only queries by default
wp-admin dashboards, query log & optional event ingest
4 realtime-dashboard / event-ingest / agency-report / privacy-minimal presets
Audit log & free JSON export
Programmatic cha/v1/* REST API
Multisite rollup, wp cha network export & agency presets

Free account See V+ Premium

ClickHouse Analytics by Volade

Free download · V+ optional

Download v1.0.0 V+

Community

Reviews, discussions & updates

Share your experience with ClickHouse Analytics by Volade and follow the latest releases.

Ready to run ClickHouse dashboards in WordPress?

Download ClickHouse Analytics by Volade v1.0.0 — first query in one minute, no Volade signup.

Download v1.0.0

Volade account or V+ Premium? Optional · Pricing