snow-perf
Use when a Snowflake query is slow or expensive, a warehouse costs too much, or you are tuning tables, clustering or warehouse sizing.
Skill by Srimukh99
Install
Works with Claude Code, Claude apps, Codex, Cursor, Gemini CLI, GitHub Copilot, VS Code, OpenCode, Goose, Windsurf. Read the repository before you give any tool access to your data.
npx agentmarket install skill/srimukh99-snow-perf
Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.
Get the weekly diff
The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.
About
Use cases: data
Reviews
Write a reviewNo reviews yet. Installed it? Reviews come from verified installers only. How reviews work
Permissions
What this skill can do and what it asks for, from its SKILL.md. Checked Oct 25, 2026.
- Tools
- No tools found
- Secrets
- None asked for
- Install scripts
- None found
Network hosts it talks to 1
codeload.github.com· found in install command
Files it touches
~/.claude/skills/snow-perf
What's inside
- Skill name
snow-perf- Description
- Use when a Snowflake query is slow or expensive, a warehouse costs too much, or you are tuning tables, clustering or warehouse sizing.
- License
- MIT
- Instructions
- 32 lines in SKILL.md · view on GitHub
Files (1)
- SKILL.md
SKILL.md (first lines)
# snow-perf ## 1. Find what costs most Query `SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY` (and `WAREHOUSE_METERING_HISTORY` for credits) to rank queries and warehouses by time and cost. ## 2. Read the Query Profile | You see | Meaning | Try | | --- | --- | --- | | Partitions scanned close to total | Poor pruning | Filter on columns the data is naturally ordered by; consider a clustering key on large tables | | Bytes spilled to local or remote storage | Not enough memory | Reduce data early (filter, project); size the warehouse up for this workload | | Join output far larger than inputs | Exploding join | Fix join keys or duplicates | | Most time in one operator | That's the bottleneck | Rewrite that step first | ## 3. Fix options - Select only needed columns; filter as early as possible. - Clustering keys only on large tables with measured pruning problems; reclustering costs credits. - Search optimization for selective point lookups. - Dynamic tables or materialized views for repeated heavy aggregations. - Remember the result cache: re-running an identical query can look fast without being faster. ## 4. Warehouse hygiene Auto-suspend at around 60 seconds, auto-resume on, right-size per workload, multi-cluster for concurrency (not single-query speed), and resource monitors with alerts. ## Prove it Report elapsed time, bytes scanned and credits before and after (`ship`).
From Srimukh99/rubric, MIT.
More from Srimukh99/rubric
- 0.570score
drift
Srimukh99
Use when asked whether what is running matches what is in git, after a deploy, when a rollout seems stuck, or when someone changed infrastructure by hand.
SkillAFreshness: AClaude Code +9 - 0.570score
crd-check
Srimukh99
Use when writing or changing Kubernetes CustomResourceDefinitions, custom resources, operators or controllers, or before upgrading a cluster.
SkillAFreshness: AClaude Code +9 - 0.569score
delegate
Srimukh99
Use when a plan has independent tasks, several unrelated failures to fix, or work big enough to split across subagents.
SkillAFreshness: AClaude Code +9 - 0.565score
mongo-index
Srimukh99
Use when a MongoDB query or aggregation is slow, when explain shows COLLSCAN or an in-memory sort, or when designing indexes for a collection.
SkillAFreshness: AClaude Code +9 - 0.565score
k8s-triage
Srimukh99
Use when a Kubernetes pod, deployment or service misbehaves, including CrashLoopBackOff, ImagePullBackOff, Pending pods, OOMKilled, failing probes, 502 or 503…
SkillAFreshness: AClaude Code +9 - 0.565score
reg-audit
Srimukh99
Use when building or changing a regulated system in finance, healthcare or government that must show who did what, when and why, or when the work involves…
SkillAFreshness: AClaude Code +9 - 0.565score
reg-money
Srimukh99
Use when code calculates, stores, moves or displays money, including prices, balances, payments, refunds, interest, fees, taxes, FX, ledgers or invoices.
SkillAFreshness: AClaude Code +9 - 0.565score
reg-pci
Srimukh99
Use when code handles payment cards such as card numbers, CVV, expiry dates, cardholder names, checkout forms or tokenization, or touches any system in PCI…
SkillAFreshness: AClaude Code +9 - 0.565score
reg-phi
Srimukh99
Use when code, data, logs, tests or prompts may touch health information such as patient records, claims, diagnoses, prescriptions, lab results or member IDs…
SkillAFreshness: AClaude Code +9 - 0.565score
boot
Srimukh99
Use when starting any coding session or task in a repo.
SkillAFreshness: AClaude Code +9 - 0.565score
build
Srimukh99
Use when writing or changing code - features, bug fixes, refactors - starting feature work in a fresh isolated worktree with a clean baseline, or executing an…
SkillAFreshness: AClaude Code +9 - 0.565score
debug
Srimukh99
Use when there is a bug, failing test, crash, flaky behaviour or wrong output, an unexpected null or bad data far from its origin, a failing service that…
SkillAFreshness: AClaude Code +9
Signals
- Stars
- 0
- Forks
- 0
- Open issues
- 0
- Last commit (this folder)
- Oct 2, 2026 (26 days ago)
From GitHub (fetched Oct 24, 2026).
Details
- License
- MIT
- Repository
- github.com/Srimukh99/rubric
- First seen
- Oct 24, 2026
- Last checked
- Oct 24, 2026
- Source
- GitHubgithub-graphql
More from Srimukh99
- 0.570score
drift
Srimukh99
Use when asked whether what is running matches what is in git, after a deploy, when a rollout seems stuck, or when someone changed infrastructure by hand.
SkillAFreshness: AClaude Code +9 - 0.570score
crd-check
Srimukh99
Use when writing or changing Kubernetes CustomResourceDefinitions, custom resources, operators or controllers, or before upgrading a cluster.
SkillAFreshness: AClaude Code +9 - 0.569score
delegate
Srimukh99
Use when a plan has independent tasks, several unrelated failures to fix, or work big enough to split across subagents.
SkillAFreshness: AClaude Code +9 - 0.565score
dbx-perf
Srimukh99
Use when a Databricks or Spark job is slow, fails with out-of-memory or executor loss, costs too much, or when tuning Delta tables.
SkillAFreshness: AClaude Code +9 - 0.565score
mongo-index
Srimukh99
Use when a MongoDB query or aggregation is slow, when explain shows COLLSCAN or an in-memory sort, or when designing indexes for a collection.
SkillAFreshness: AClaude Code +9 - 0.565score
api-pick
Srimukh99
Use when designing a new API or endpoint, choosing between REST, GraphQL or gRPC, or reviewing an API contract for design and safety.
SkillAFreshness: AClaude Code +9
Cite this page
snow-perf skill. Agent Mart. https://agentmart.dev/skills/srimukh99-snow-perf (last updated 2026-10-24)