Real-Time Analytics

Overview

This skill enables AI agents to build self-hosted, real-time analytics systems. It covers the full pipeline from event ingestion through storage to query and visualization, using ClickHouse as the analytical database for sub-second query performance at scale.

Instructions

Event Schema Design

1. Every event must have these base fields:
   • event_name — LowCardinality(String) for efficient storage
   • timestamp — DateTime64(3) for millisecond precision
   • session_id — String, client-generated UUID
   • user_id — Nullable(String) for anonymous tracking
   • device_type — LowCardinality(String): desktop, mobile, tablet
   • country_code — LowCardinality(FixedString(2))
   • properties — String containing JSON for event-specific data