clickhouse-grafana-monitoring

Query ClickHouse logs and build Grafana dashboards for 3-branch detection metrics.

14|2|Updated Nov 12, 2025
One-click install
npx skills add https://github.com/tbartel74/Vigil-Code --skill clickhouse-grafana-monitoring
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: clickhouse-grafana-monitoring
Source: https://github.com/tbartel74/Vigil-Code/tree/main/.claude/skills/clickhouse-grafana-monitoring
Command: npx skills add https://github.com/tbartel74/Vigil-Code --skill clickhouse-grafana-monitoring

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

ClickHouse analytics and Grafana dashboards for Vigil Guard v2.0.0 monitoring, enabling queries on 3-branch detection metrics, branch performance, and data retention.

Core Features & Use Cases

  • Log Analytics: Query n8n_logs.events_processed for branch scores and arbiter decisions.
  • Dashboards: Build Grafana dashboards to visualize branch metrics and timing.
  • Retention & Monitoring: Manage TTLs and monitor service health.

Quick Start

Use the ClickHouse schema and queries to analyze branch performance; connect to Grafana for dashboards.

Frequently Asked Questions about clickhouse-grafana-monitoring

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query ClickHouse logs to analyze branch detection metrics?

Query ClickHouse events_processed table to retrieve branch scores, arbiter decisions, and timing fields for Heuristics, Semantic, and LLM Guard detection branches. The schema includes threat scoring and labeling fields to support metric aggregation and filtering by branch performance.

Can I build Grafana dashboards to visualize ClickHouse metrics?

Yes. Connect Grafana to your ClickHouse instance and build dashboards using branch metrics, arbiter decisions, and performance data from the events_processed table. Dashboard configuration supports alerting and real-time visualization of 3-branch detection performance.

What's the best way to manage data retention in ClickHouse for monitoring?

Set TTL (time-to-live) retention policies on ClickHouse tables to automatically age out old events while preserving operational data for monitoring. The schema defines retention fields to support compliance and performance management within Vigil Guard v2.0.0.

How do I monitor branch performance and investigate detection events?

Use ClickHouse queries on events_raw and events_processed tables to investigate individual events, compare branch scores, and analyze arbiter decisions over time. Grafana dashboards enable real-time branch performance monitoring and anomaly detection across Heuristics, Semantic, and LLM Guard branches.

Does this work with Vigil Guard v2.0.0?

Yes. The Skill provides analytics and monitoring specifically for Vigil Guard v2.0.0, including the ClickHouse schema, 3-branch detection metrics, arbiter decision tracking, and dashboard configuration to support the full monitoring and alerting workflow.