About

Imported from borghei/claude-skills (engineering/snowflake-development/SKILL.md). Install upstream with npx skills add borghei/claude-skills --skill snowflake-development. Copyright stays with the author (MIT + Commons Clause).

Snowflake Development

Name: snowflake-development
Author: borghei

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

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

Warehouse Right-Sizing

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

Reference Documentation

Snowflake Best Practices - Query patterns, warehouse management, cost optimization

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

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml

targets:
  - https://api.opensmartroute.ai/api/v1/registry/borghei-claude-skills-snowflake-development/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

borghei-claude-skills-snowflake-development.ocm.jsonjson

{
  "ocm": "1",
  "id": "borghei-claude-skills-snowflake-development",
  "kind": "skill",
  "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\".",
  "publisher": "borghei",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "coding",
      "data_analysis"
    ],
    "tags": [
      "skill-md",
      "snowflake",
      "sql",
      "data-warehouse",
      "query-optimization",
      "warehouse-sizing",
      "skills-sh"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "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\"."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "skills.sh",
      "repository": "https://github.com/borghei/claude-skills",
      "path": "engineering/snowflake-development/SKILL.md",
      "ref": "HEAD",
      "url": "https://github.com/borghei/claude-skills/blob/HEAD/engineering/snowflake-development/SKILL.md",
      "key": "borghei/claude-skills/engineering/snowflake-development/SKILL.md"
    },
    "license": "MIT + Commons Clause"
  },
  "instructions": "# Snowflake Development\n\n> **Category:** Engineering\n> **Domain:** Data Warehouse\n\n## Overview\n\nThe **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.\n\n## Clarify First\n\nBefore analyzing or sizing, confirm these inputs. If any is unknown or vague, ASK — do not assume:\n\n- [ ] **Action** — analyze / optimize / warehouse-sizing (`--action`; selects the workflow)\n- [ ] **SQL file or query** — the specific qu",
  "cost": {
    "context_tokens": 620
  }
}

Fetch it by URL: GET /api/v1/registry/borghei-claude-skills-snowflake-development/manifest?version=1.0.0

Reviews

Star ratings from people who tried it. One review per account; edit yours any time.

No reviews yet. Install it, try it, and be the first to rate it.