signoz-writing-clickhouse-queries

Write raw ClickHouse SQL for a SigNoz dashboard panel: timeseries, value, or table widgets.

What this skill does for you

Write raw ClickHouse SQL for a SigNoz dashboard panel: timeseries, value, or table widgets that the builder UI cannot express (custom joins, window functions, regex extraction over log bodies, aggregations beyond builder syntax). Trigger when the user explicitly asks for a "ClickHouse query", a "raw SQL panel", a "custom SQL widget", or describes a SigNoz dashboard panel whose query needs SQL the builder cannot produce. Anchored to dashboard-panel SQL specifically. For ad-hoc data exploration that does not need to land in a panel, use `signoz-generating-queries` instead.

Quoted from the skill description in the pinned source

Who made it

Publishersignoz

Repositoryagent-skills

Installs317as of Sep 27, 2026

Use it with Edge

Set up Edge for me: read getedge.cc/SKILL.md and follow it. Then use Edge to load the signoz-writing-clickhouse-queries skill from signoz/agent-skills.

Paste it into Claude, ChatGPT, Codex or Cursor.

Or read the skill source first.

Security evidence

Security state at 2026-09-30: reviewed. State definitions. This records static evidence for this revision; live load eligibility is checked again.

3 static scans, 0 counted findings. The listed scanners recorded the results shown for this package revision.

Scanner	Date	Result
Edge static checks	2026-09-27	Pass
Cisco skill-scanner	2026-09-27	Pass
Semgrep Edge rules	2026-09-27	Pass

Static scans check the code, not how well the skill works.

Scanner scope, raw findings and mirrored provider records

Edge static checks (Edge-run): edge-static/1.0.1. Scope: Static patterns for remote execution, credentials with network sends, obfuscation, prompt overrides, hidden Unicode, binaries and persistence. Revision: eac09ab84fc628261437617d8db12618c144e0c7. Raw findings: . Counted findings: .

Cisco skill-scanner (Edge-run): cisco-skill-scanner/2.1.0. Scope: Local static, YARA, pipeline and behavioral analyzers; no LLM or AI Defense analysis. Revision: eac09ab84fc628261437617d8db12618c144e0c7. Raw findings: 1. Counted findings: .

Semgrep Edge rules (Edge-run): semgrep/1.178.0+edge-rules.c15016a36fd3+offline-v1. Scope: Six Edge-authored static rules with Semgrep CE; offline execution and metrics disabled. Semgrep-maintained rules excluded. Revision: eac09ab84fc628261437617d8db12618c144e0c7. Raw findings: . Counted findings: .

Source and licence

Repository: https://github.com/signoz/agent-skills
Pinned skill file: View source at revision
Revision: eac09ab84fc628261437617d8db12618c144e0c7
Package hash: sha256:6ba5c155ca27ec7c8bee95c8ecf9e4a27ae7ec04100b44745a380c6038b41ff8
Licence: MIT