optimizing-clickhouse-and-hogql-queries
Pass
Audited by Gen Agent Trust Hub on Jun 24, 2026
Risk Level: SAFE
Full Analysis
- [SAFE]: The skill consists of technical documentation and playbooks designed to assist developers in optimizing database queries. It references internal PostHog models, ClickHouse system tables, and official documentation.
- [EXTERNAL_DOWNLOADS]: The skill mentions an external tool,
pi-autoresearch, hosted on GitHub atgithub.com/davebcn87/pi-autoresearch. This tool is presented as an optional 'powertool' for automated performance research, with the instructions explicitly stating that the user (human) should handle its setup and execution. - [DATA_EXPOSURE]: While the skill mentions the requirement for an
ANTHROPIC_API_KEYwhen using the optionalpi-autoresearchtool, it does not contain any hardcoded credentials. It correctly identifies the key as a configuration requirement for the user to provide in their own environment.
Audit Metadata