Individual skill
write-hql
Write, validate, and run HQL (Harness Query Language) queries against Harness data, and analyze pipeline, deployment, CI and security data with them. Use when asked to write, fix, explain, or validate an HQL query, create dashboard widget queries, find which types and fields can be queried, or answer "how many", "top N", trend, dashboard widget, or failure-rate questions over a time window or many runs. Do NOT use for the current state of one named pipeline run (use debug-pipeline) or for cloud cost totals (use analyze-costs). Trigger phrases: HQL, Harness Query Language, write a query, validate query, queryable types.
skills/unified-data-platform/write-hql/SKILL.md
Source commit e01dc7275f7e261f390be2fe7be4559feadb74ef
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- No
- Repository scan complete
- No
- Skill scan complete
- Yes
- Observed behavior
- Not checked yet
- Last checked
- Nov 5, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 133
- Repository last updated
- Oct 28, 2026
- License
- Apache-2.0
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- agent-skills Repository topic
- agents Repository topic
- data Derived category
- devops Derived category
- security Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
SKILL.mdcore · 13,374 bytesreference.mddoc · 6,830 bytesreferences/analysis-workflow.mddoc · 6,710 bytesreferences/entity-reference/ci.mddoc · 1,771 bytesreferences/patterns/batch.mddoc · 1,283 bytesreferences/patterns/bottleneck-analysis.mddoc · 1,814 bytesreferences/patterns/build-time-analysis.mddoc · 1,707 bytesreferences/patterns/failure-diagnosis.mddoc · 1,926 bytesreferences/patterns/flakiness.mddoc · 2,688 bytesreferences/patterns/intermittent-vs-consistent.mddoc · 1,592 bytesreferences/patterns/lint-first.mddoc · 1,690 bytesreferences/patterns/retry-signals.mddoc · 1,629 bytes
Read excerpt
# Write HQL
Write, validate, and run HQL queries against Harness data, primarily for dashboard widget creation. This skill teaches the query language, the type discovery workflow, and the validation loop. For non-dashboard multi-query analysis (overview, drill-down, synthesis), also follow [analysis-workflow.md](references/analysis-workflow.md).
## Instructions
### Step 0: Learn HQL syntax
Read the companion files in this skill directory before writing any queries:
- **`reference.md`** — practical examples, type casting rules, JOIN syntax, anti-patterns.
- **`references/patterns/*.md`** — worked query patterns per question shape (failure-diagnosis, build-time-analysis, bottleneck-analysis, flakiness, retry-signals, intermittent-vs-consistent, lint-first, batch).
- **`references/entity-reference/ci.md`** — CI-native field discipline (`stage_build_time` vs `duration`, `start_timestamp` vs `start_ts`).
Fetch the live grammar via `harness_get(resource_type='kg_grammar')` only when the reference files do not cover the syntax you need.