Katalog
SaaS · ClickHouse HTTP

ClickHouse Analytics by Volade

ClickHouse-Dashboards in wp-admin, Read-only SQL standardmäßig.

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+Kein Volade-Konto
Noch nicht bewertet0 Aufrufe0 Downloads

3-step workflow

  1. 1Copy ClickHouse HTTP endpoint and create a read-only user
  2. 2Volade → ClickHouse Analytics → paste credentials → test connection
  3. 3Apply realtime-dashboard preset — run saved queries in wp-admin
ClickHouse Analytics by Volade
Screenshot 1 — 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

4

Analytics presets

JSON

Free export

Auf einen Blick

Data-Teams verlassen WordPress noch für clickhouse-client oder Metabase. ClickHouse Analytics by Volade v1.0.0 führt HTTP-Abfragen in wp-admin aus: Echtzeit-Dashboard, optionales Ingest, standardmäßig nur Leseabfragen, vier Presets und JSON-Export — kostenlos ohne Konto (ClickHouse-Zugangsdaten nötig).

Screenshots

Ganzseitige echte Admin-Oberfläche — Voreinstellungen, Diagnose und detaillierte Einstellungen.

Screenshot 1 — ClickHouse Analytics by Volade

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

$0

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.

Ergänzt Tinybird Analytics by Volade — CHA nutzt Ihren ClickHouse-Cluster per HTTP read-only; Tinybird für managed Pipes, CHA wenn ClickHouse bereits läuft.

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

$0

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.

FeatureCHA VoladeTinybirdMixpanelMetabase DIYclickhouse-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 und export per 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
Verifizierter 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
  1. 1Plugins → Add New → Upload → ZIP → Activate
  2. 2Volade → ClickHouse Analytics → paste HTTP endpoint, user and password (read-only user recommended)
  3. 3Apply realtime-dashboard preset → run saved query → optional event-ingest → export JSON

First query results in under 60 seconds

Antiviren-Scan wird ausgeführt…

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.

Kostenlos vs V+ Premium

Die Erweiterung funktioniert ohne Konto. V+ schaltet Premium auf dieser Erweiterung und dem gesamten Katalog frei.

FunktionKostenlosV+
Identifiants HTTP ClickHouse + requêtes lecture seule par défaut
Dashboards wp-admin, journal requêtes & ingest optionnel
4 presets realtime-dashboard / event-ingest / agency-report / privacy-minimal
Journal & export JSON gratuit
API REST cha/v1/* programmatique
Rollup multisite, wp cha network export & presets agence

ClickHouse Analytics by Volade

Kostenloser Download · V+ optional

Download v1.0.0V+
Community

Bewertungen, Diskussionen & Updates

Teile deine Erfahrung mit ClickHouse Analytics by Volade und verfolge die neuesten Veröffentlichungen.

Bereit für ClickHouse-Dashboards in WordPress?

ClickHouse Analytics by Volade v1.0.0 — erste Abfrage in einer Minute, ohne Volade-Anmeldung.

Download v1.0.0

Volade account or V+ Premium? Optional · Pricing