SkillAgentSearch skills...

snowflake-development

Review Snowflake SQL for pruning and join problems, size warehouses and cut credit spend

Install / Use

npx skills add borghei/Claude-Skills --skill snowflake-development

Installs into whichever agent you are using.

About this skill
📄

SKILL.md

Installable skill definition

Quality Score

81/100

Supported Platforms

Universal

Our assessment of snowflake-development

snowflake-development scores 81/100 on our quality scale, 529th of 608 Data & Analytics skills we index.

Its SKILL.md is 2.9 KB long, well organised into 14 sections with 1 code example: a solid amount of guidance for an agent.

It has 817 GitHub stars, a meaningful sign that others use it.

Substance
26/30
Structure
17/20
Description
12/15
Adoption
12/20
Freshness
15/15

Maintenance, license and trust

  • The repository was last updated about 2 months ago, so snowflake-development is actively maintained.
  • Our last check on 2026-10-14 found the source still online.
  • No license is declared. By default that means all rights are reserved: you can read it, but reusing or redistributing it is not clearly permitted. Ask the author before building on it commercially.
  • Its trust signals score 88/100, with 1 caution from licensing, adoption, age or documentation. These come from repository metadata, not a code audit — read the skill file before letting an agent act on it.

Safety scan

No issues found

Our scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful.

AI review by kimi-k2.7-code on 2026-10-07. Automated pattern scan on 2026-10-07. It catches known dangerous patterns, not every risk — read a skill before letting an agent act on it.

snowflake-development compared with similar skills

All 4 of these similar skills score higher than snowflake-development; compare them before choosing.

SkillScoreStarsUpdatedFormat
snowflake-development (this skill)by borghei8181757d agoSKILL.md
claude-memby thedotmack100117.9ktodayCLAUDE.md
Claude-Code-Game-Studiosby Donchitos10039.9k8d agoCLAUDE.md
x402by browser-use100121.0k4d agoSKILL.md
algorithmic-artby anthropics100177.9k56d agoSKILL.md

Frequently asked questions

How do I install snowflake-development?
Run npx skills add borghei/Claude-Skills --skill snowflake-development. The install tabs above show the steps for each supported agent.
Which AI agents does snowflake-development work with?
It is written for Universal, as a SKILL.md file. Other agents that read the same format can often use it too.
Is snowflake-development safe to use?
Our scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful. It declares no license and scores 88/100 on trust signals. Skills are instructions an agent will follow, so read the file before installing it and do not approve commands you do not understand.
Is snowflake-development still maintained?
The repository was last updated about 2 months ago, so snowflake-development is actively maintained.

name: snowflake-development description: > 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". license: MIT + Commons Clause metadata: version: 1.0.0 author: borghei category: engineering domain: data-warehouse updated: 2026-04-02 tags: [snowflake, sql, data-warehouse, query-optimization, warehouse-sizing]

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

| Tool | Purpose | Key Flags | |------|---------|-----------| | snowflake_query_helper.py | Analyze, 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

Related Skills

View on GitHub
GitHub Stars817
CategoryData
Updated1mo ago
Forks141

Languages

HTML

Trust signals

88/100

From repository metadata: license, adoption, age and documentation. Not a code audit — see the Safety scan above for what the skill file itself contains.

1 medium
snowflake-development — Universal Skill: Install & Safety Check | SkillAgent