Skip to content
cccskills
FreePublished on GitHub

snowflake-development

This skill should be used when the user asks to "optimize Snowflake queries", "analyze Snowflake SQL performance", "size Snowflake warehouses", "review Snowflake data models", or "troubleshoot Snowflake cost issues".

The English summary is being prepared. Showing the original description.

Works withSnowflake
See how to install

Files included (3)

  • SKILL.md2.9 KB
  • references/snowflake-best-practices.md3.7 KB
  • scripts/snowflake_query_helper.py19.1 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Snowflake Development

Category: Engineering Domain: Data Warehouse

Overview

The Snowflake Development skill provides tools for analyzing and optimizing Snowflake SQL queries, recommending warehouse sizing, and enforcing Snowflake-specific best practices. Helps data engineers reduce costs and improve query performance.

Clarify First

Before analyzing or sizing, confirm these inputs. If any is unknown or vague, ASK — do not assume:

  • Action — analyze / optimize / warehouse-sizing (--action; selects the workflow)
  • SQL file or query — the specific query(ies) to optimize (--file; the subject of the analysis)
  • Workload type & data volume — ETL / BI / ad-hoc and the GB scale (--workload/--data-volume; drives the warehouse recommendation)

Stop rule: ask only the 2-3 that most change the output. If the user says "just draft it," proceed and list your assumptions at the top of the artifact.

Quick Start

# Analyze a Snowflake SQL file for optimization opportunities
python scripts/snowflake_query_helper.py --file queries.sql --action analyze

# Get warehouse sizing recommendations
python scripts/snowflake_query_helper.py --action warehouse-sizing --workload "etl" --data-volume "500GB"

# Optimize a specific query
python scripts/snowflake_query_helper.py --file slow_query.sql --action optimize

Tools Overview

ToolPurposeKey Flags
snowflake_query_helper.pyAnalyze, optimize Snowflake SQL and recommend warehouse sizes--file, --action, --workload, --data-volume

Workflows

Query Performance Optimization

  1. Collect slow queries from query history
  2. Run analyzer to identify optimization opportunities
  3. Apply recommended changes
  4. Compare before/after execution plans

Warehouse Right-Sizing

  1. Identify workload type (ETL, BI, ad-hoc, etc.)
  2. Run warehouse-sizing with data volume
  3. Review recommendations
  4. Implement multi-cluster settings if applicable

Reference Documentation

Common Patterns

Cost Reduction

  • Right-size warehouses (don't use XL for small queries)
  • Set auto-suspend to 60 seconds for ad-hoc warehouses
  • Use materialized views for frequently accessed aggregations
  • Partition large tables with clustering keys
  • Avoid SELECT * in production queries

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

This skill should be used when the user asks to "check accessibility", "audit WCAG compliance", "scan HTML for a11y issues", "check color contrast", or "find accessibility violations in web pages".

The English summary is being prepared. Showing the original description.

borghei/Claude-Skills942Updated Oct 7, 2026

Design and run statistically rigorous A/B tests and experiments. Use when planning experiments, calculating sample sizes, designing test variants, selecting metrics, analyzing results, or when someone says "let's test that."

The English summary is being prepared. Showing the original description.

borghei/Claude-Skills942Updated Oct 7, 2026

Design and analyze A/B tests: sample size, test duration, and statistical significance for conversion experiments. Use when setting up an A/B test, calculating sample size, designing an experiment, or analyzing results.

The English summary is being prepared. Showing the original description.

borghei/Claude-Skills942Updated Oct 7, 2026

Sales execution across pipeline, discovery, demos, negotiation, and closing. Use when qualifying opportunities, running MEDDIC discovery, building account plans, handling objections, structuring proposals, or forecasting pipeline.

The English summary is being prepared. Showing the original description.

borghei/Claude-Skills942Updated Oct 7, 2026

Design ad creative across Google, Meta, LinkedIn, Twitter/X, and TikTok with platform format specs, headline formulas, and A/B testing. Use when writing ad copy, generating headline variations, creating ad sets, or validating creative.

The English summary is being prepared. Showing the original description.

borghei/Claude-Skills942Updated Oct 7, 2026

aeo

Free

Answer Engine Optimization (AEO): optimize content to be cited by LLMs (ChatGPT, Claude, Perplexity, Gemini) in their answers. Use when designing content for LLM citation, auditing citability, or structuring Q&A schema.

The English summary is being prepared. Showing the original description.

borghei/Claude-Skills942Updated Oct 7, 2026

See all skills by borghei

Report a problem with this skill