Individual skill
snowflake-query-forensics
Audit, analyze, and diagnose completed or failed Snowflake queries from query history, Query Insights, and GET_QUERY_OPERATOR_STATS evidence. Use when investigating slow queries, queueing, lock waits, local or remote spill, poor pruning, exploding joins, repeated query-hash regressions, or requests for a defensible query root-cause packet. Trigger with "Snowflake query spilled", "why is this Snowflake query queued", "Snowflake query ID", "exploding join", or "Snowflake pruning regression". Do not use for generic SQL tutoring, automatic query rewrites, warehouse resizing, cancellation, or clustering changes.
plugins/saas-packs/snowflake-pack/skills/snowflake-query-forensics/SKILL.md
Source commit 0500b275e963c027f6b410e8c49c0446945c574e
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- No
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Not checked yet
- Last checked
- Nov 12, 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)
- 2,917
- Repository last updated
- Nov 12, 2026
- License
- MIT
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- ai Repository topic
- automation Repository topic
- claude-code Repository topic
- devops Repository topic
- mcp Repository topic
- ai-agents Repository topic
- anthropic Repository topic
- claude-code-plugins Repository topic
- developer-tools Repository topic
- llm Repository topic
- saas Declared skill tag
- data-warehouse Declared skill tag
- analytics Declared skill tag
- snowflake Declared skill tag
- performance Declared skill tag
- data Derived category
- data-databases 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 · 17,397 bytesSKILL.mdcore · 17,397 bytesSKILL.mdcore · 17,397 bytesSKILL.mdcore · 17,397 bytesSKILL.mdcore · 17,397 bytesSKILL.mdcore · 17,397 bytesSKILL.mdcore · 17,397 bytesSKILL.mdcore · 17,397 byteseval-spec.yamlasset · 7,224 bytesreferences/history-and-collection.mddoc · 9,941 bytesreferences/load-hash-and-sos.mddoc · 1,859 bytesreferences/operator-statistics.mddoc · 3,925 bytesreferences/output-contract.mddoc · 7,699 bytesreferences/query-insights-boundaries.mddoc · 2,613 bytesscripts/analyze_query_evidence.pyruns · 99,060 bytesscripts/collect_snowflake_evidence.pyruns · 98,463 bytesscripts/sql/query.sqlasset · 2,233 bytestests/fixtures/collector_query_output.jsonasset · 1,098 bytestests/fixtures/query_evidence.jsonasset · 2,460 bytestests/fixtures/query_evidence_incomplete.jsonasset · 672 bytestests/test_analyze_query_evidence.pyruns · 73,110 bytes
Read excerpt
# Snowflake Query Forensics
## Overview
Build a read-only query root-cause packet from platform evidence. Distinguish observed
facts, derived metrics, and hypotheses; isolate one variable for any later experiment.
**Problem:** A slow elapsed time does not identify whether compilation, execution,
queueing, blocking, spill, pruning, or query shape is responsible, and some diagnostic
surfaces are delayed or unavailable for particular query classes.
**Outcome:** A query-scoped packet that ranks observed operator evidence, preserves
competing explanations, and defines the next read-only check without changing SQL or
compute.