clickhouse-validation
CommunityValidate ClickHouse metrics: NRT vs Fast
Authorhuangcd
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Compare Agile (NRT Pulse) vs Fast Pipeline RL24 DAU metrics in ClickHouse to validate data consistency, enabling repeatable, automated validation and reducing manual reconciliation effort.
Core Features & Use Cases
- Template-driven validation: Reuses predefined SQL templates to compare NRT Pulse and Fast Pipeline metrics across multiple dimensions.
- Automatic credential handling: Uses MCP's submit_clickhouse_query to extract credentials, removing manual login steps.
- Per-dimension analysis: Iterates over dimension values (Type, Endpoint, Platform, Operating System, Area, etc.) and reports hourly differences.
- Latest timestamp alignment: Ensures comparisons are performed at the latest common timestamp to avoid skew.
- Extensible output: Generates structured results suitable for dashboards or automation workflows.
Quick Start
Run the comparison against a template (e.g., agent_au) to start validating NRT Pulse vs Fast Pipeline across supported dimensions.
Dependency Matrix
Required Modules
requests
Components
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: clickhouse-validation Download link: https://github.com/huangcd/gcusage/archive/main.zip#clickhouse-validation Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.