Finding Expensive Queries

Quality score: 70/100 · Category: General · Sub-category: general-misc

Finds and ranks expensive Snowflake queries by cost, time, or data scanned. Use when: (1) User asks to find slow, expensive, or problematic queries (2) Task mentions "query history", "top queries", "most expensive", or "slowest queries" (3) Analyzing warehouse costs or identifying optimization candidates (4) Finding queries that scan the most data or have the most spillage Returns ranked list of queries with metrics and optimization recommendations.

What this skill does

Finding Expensive Queries is a production-ready Claude Code skill (quality score 70/100) in the general-misc sub-category. It ships as a SKILL.md file that Claude Code auto-discovers under ~/.claude/skills/finding-expensive-queries/ and loads when your prompt matches the skill's trigger.

When to invoke it: Use when: (1) User asks to find slow, expensive, or problematic queries (2) Task mentions "query history", "top queries", "most expensive", or "slowest queries" (3) Analyzing warehouse costs or identifying optimization candidates (4) Finding queries that scan the most data or have the most spillage Returns ranked list of queries with metrics and optimization recommendations.

Who uses this skill

The Finding Expensive Queries skill is built for Claude Code users and developers across all disciplines looking for general-purpose AI assistance. It is part of the open ClaudSkills registry, a community-curated catalog of 15,000+ capabilities you can install for Claude Code — the Claude CLI agent.

How to install

Free

Manual install (2 steps)

mkdir -p ~/.claude/skills/finding-expensive-queries
curl -L https://claudskills.com/skills/finding-expensive-queries/SKILL.md \
  -o ~/.claude/skills/finding-expensive-queries/SKILL.md

Or just download SKILL.md directly and drop it into ~/.claude/skills/finding-expensive-queries/. Claude Code auto-discovers it on next session.

Skills live at ~/.claude/skills/finding-expensive-queries/SKILL.md on macOS/Linux, or %USERPROFILE%\.claude\skills\finding-expensive-queries\SKILL.md on Windows. See the full install guide for step-by-step instructions.

Pro

One-click install via the desktop app

The ClaudSkills desktop app installs any skill directly into ~/.claude/skills/ with one click — no terminal required. Pro starts at $9/mo or $149 lifetime.

More General skills

Browse all General skills in the ClaudSkills registry, or explore these top-rated picks from the same category:

Browse all General skills → Top 100 skills

Part of ClaudSkills — the open registry for Claude Code skills. · What's New · Install guide · About · llms.txt

Part of Acreator Store — Adam Lankamer's AI tools: GifPerfect · AspectPerfect · SlomoPerfect · Ucaption · UTagger · AutoXPoster · TestYourSkills