ClickHouse Analytics by Volade
Dashboards ClickHouse dans wp-admin, SQL lecture seule par défaut.
ClickHouse Analytics by Volade connecte WordPress à l'interface HTTP ClickHouse — requêtes enregistrées, tiles dashboard, ingest optionnel et preset privacy-minimal sans compte Volade.
Workflow en 3 étapes
- 1Copier l'endpoint HTTP ClickHouse et un utilisateur lecture seule
- 2Volade → ClickHouse Analytics → coller les identifiants → tester
- 3Preset realtime-dashboard — requêtes dans wp-admin

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
Requêtes HTTP, dashboards wp-admin, journal ingest optionnel, 4 presets et export JSON gratuit — endpoint ClickHouse, lecture seule par défaut, sans compte Volade.
HTTP
Query interface
Read-only
Default safety
4
Analytics presets
JSON
Free export
En bref
Les équipes data collent encore clickhouse-client ou Metabase hors WordPress. ClickHouse Analytics by Volade v1.0.0 lance des requêtes HTTP dans wp-admin : dashboard temps réel, ingest optionnel, requêtes en lecture seule par défaut, quatre presets et export JSON — gratuit sans compte (identifiants ClickHouse requis).
Captures d'écran
Interface réelle en pleine page — préréglages, diagnostics et réglages détaillés.

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 / sièges BI
0 €
ClickHouse Analytics by Volade
Pourquoi les équipes SSH vers clickhouse-client — ou reconstruisent Metabase — quand les éditeurs veulent des KPI dans wp-admin
Tinybird gère des pipes. Mixpanel cible les funnels produit. Metabase DIY demande un autre serveur. clickhouse-client brut ignore les presets WordPress. CHA exécute des requêtes HTTP en lecture seule depuis wp-admin avec ingest optionnel.
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 presets ClickHouse
realtime-dashboard, event-ingest, agency-report ou privacy-minimal — un clic.
realtime-dashboard
Saved SELECT queries and KPI tiles — blogs and marketing sites.
Dashboardevent-ingest
Optional WordPress event rows into staging tables — write guard enabled.
Ingestagency-report
Multi-site query pack and dashboard embeds for client reporting.
Agencyprivacy-minimal
Minimal columns, hashed identifiers, read-only queries only.
Privacy4 surfaces de requête
Dashboards HTTP, garde lecture seule, ingest optionnel et privacy-minimal — visibles dans wp-admin.
Saved SELECT over ClickHouse HTTP — realtime-dashboard preset.
Destructive SQL blocked — optional ingest via preset only.
WordPress events to staging tables — event-ingest preset.
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.
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
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
Ce que Metabase DIY et clickhouse-client n'offrent pas pour WordPress
Requêtes HTTP ClickHouse, dashboards wp-admin, ingest optionnel, 4 presets et export — lecture seule par défaut, sans compte Volade.
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.
Complète Tinybird Analytics by Volade : CHA interroge votre cluster ClickHouse en HTTP en lecture seule — Tinybird pour les pipes managés, CHA si vous avez déjà ClickHouse.
What teams pay for WordPress + ClickHouse analytics
Public pricing July 2026 — managed pipes vs your own column store.
Tinybird (managed pipes)
$0–$
Fast Events API — not arbitrary SQL on your existing ClickHouse tables.
Mixpanel (product analytics)
$0–$
Great funnels — not wp-admin SQL dashboards on your ClickHouse schema.
Metabase DIY
$85+/mo
Another app to host — no WordPress presets or wp cha export.
Raw clickhouse-client
DevOps $
SSH and SQL files — no ingest log, presets or editor-friendly wp-admin.
ClickHouse Analytics by Volade
$0
HTTP queries from wp-admin, optional ingest, 4 presets, REST + wp cha.
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.
Trois tiers, un plugin
Requêtes, dashboards, ingest optionnel, presets et export JSON gratuits. Compte Volade pour REST. V+ pour rollup multisite.
No account
- ClickHouse HTTP credentials
- Read-only queries + dashboards
- 4 presets
- Optional ingest preset
- JSON export
Volade account
- REST cha/v1
- Query/tail via API
- Scheduled export
V+ Premium
- Multisite preset rollup
- wp cha network export
- Agency harmonization
WP-CLI `wp cha` et REST `cha/v1` pour tester, journal, presets et export.
WP-CLI
status, query, preset et export en 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
Télécharger
Installez le ZIP, collez endpoint HTTP et identifiants ClickHouse — premier tile dashboard en moins d'une minute.
ZIP avec SDK Volade — Volade → ClickHouse Analytics.
- 1Extensions → Ajouter → Téléverser → ZIP → Activer
- 2Volade → ClickHouse Analytics → endpoint HTTP, utilisateur lecture seule recommandé
- 3Preset realtime-dashboard → requête enregistrée → export JSON
Premiers résultats en moins de 60 secondes
FAQ
Identifiants ClickHouse, mode lecture seule, ingest, presets, multisite et compte Volade.
No. Paste ClickHouse HTTP endpoint and credentials — queries, dashboards and presets work without Volade signup.
Gratuit vs V+ Premium
L'extension fonctionne sans compte. V+ débloqué le premium sur cette extension et tout le catalogue.
| Fonctionnalité | Gratuit | V+ |
|---|---|---|
| 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 |
Avis, discussions & nouveautés
Partagez votre expérience avec ClickHouse Analytics by Volade et suivez les dernières mises à jour.
Prêt pour des dashboards ClickHouse dans WordPress ?
Téléchargez ClickHouse Analytics by Volade v1.0.0 — première requête en une minute, sans inscription Volade.
Télécharger v1.0.0