Agent skill

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…

MITAuto-check passedDatabases

Install Snowflake Development

skills CLI

$ npx skills add borghei/Claude-Skills --skill snowflake-development -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI

$ gh skill install borghei/Claude-Skills snowflake-development --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy

$ git clone --depth 1 https://github.com/borghei/Claude-Skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/engineering/snowflake-development .claude/skills/snowflake-development && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Paste into Claude Code

Install the "snowflake-development" agent skill from https://github.com/borghei/Claude-Skills/tree/main/engineering/snowflake-development into .claude/skills/snowflake-development/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "snowflake-development", then confirm the skill loads.

Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

$skill-installer

$skill-installer install https://github.com/borghei/Claude-Skills/tree/main/engineering/snowflake-development

Type this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.

skills CLI

$ npx skills add borghei/Claude-Skills --skill snowflake-development -a codex

Project install goes to .agents/skills/; add -g for ~/.codex/skills/.

GitHub CLI

$ gh skill install borghei/Claude-Skills snowflake-development --agent codex

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/borghei/Claude-Skills.git skills-src && mkdir -p .agents/skills && cp -r skills-src/engineering/snowflake-development .agents/skills/snowflake-development && rm -rf skills-src

Use ~/.agents/skills/ instead of .agents/skills for a personal install.

Codex skills documentation · loads skills from .agents/skills/

Paste into Codex

Install the "snowflake-development" agent skill from https://github.com/borghei/Claude-Skills/tree/main/engineering/snowflake-development into .agents/skills/snowflake-development/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "snowflake-development", then confirm the skill loads.

Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add borghei/Claude-Skills --skill snowflake-development -a cursor

Project install goes to .agents/skills/; add -g for ~/.cursor/skills/.

GitHub CLI

$ gh skill install borghei/Claude-Skills snowflake-development --agent cursor

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/borghei/Claude-Skills.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/engineering/snowflake-development .cursor/skills/snowflake-development && rm -rf skills-src

Use ~/.cursor/skills/ instead of .cursor/skills for a personal install.

Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/

Paste into Cursor

Install the "snowflake-development" agent skill from https://github.com/borghei/Claude-Skills/tree/main/engineering/snowflake-development into .cursor/skills/snowflake-development/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "snowflake-development", then confirm the skill loads.

Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

gemini skills install

$ gemini skills install https://github.com/borghei/Claude-Skills.git --path engineering/snowflake-development

--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.

skills CLI

$ npx skills add borghei/Claude-Skills --skill snowflake-development -a gemini-cli

Project install goes to .agents/skills/; add -g for ~/.gemini/skills/.

GitHub CLI

$ gh skill install borghei/Claude-Skills snowflake-development --agent gemini-cli

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/borghei/Claude-Skills.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/engineering/snowflake-development .gemini/skills/snowflake-development && rm -rf skills-src

Use ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.

Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/

Paste into Gemini CLI

Install the "snowflake-development" agent skill from https://github.com/borghei/Claude-Skills/tree/main/engineering/snowflake-development into .gemini/skills/snowflake-development/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "snowflake-development", then confirm the skill loads.

Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

GitHub CLI

$ gh skill install borghei/Claude-Skills snowflake-development

Installs for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).

skills CLI

$ npx skills add borghei/Claude-Skills --skill snowflake-development -a github-copilot

Project install goes to .agents/skills/; add -g for ~/.copilot/skills/.

Manual copy

$ git clone --depth 1 https://github.com/borghei/Claude-Skills.git skills-src && mkdir -p .github/skills && cp -r skills-src/engineering/snowflake-development .github/skills/snowflake-development && rm -rf skills-src

Use ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.

GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/

Paste into GitHub Copilot

Install the "snowflake-development" agent skill from https://github.com/borghei/Claude-Skills/tree/main/engineering/snowflake-development into .github/skills/snowflake-development/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "snowflake-development", then confirm the skill loads.

GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add borghei/Claude-Skills --skill snowflake-development -a opencode

OpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.

GitHub CLI

$ gh skill install borghei/Claude-Skills snowflake-development --agent opencode

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/borghei/Claude-Skills.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/engineering/snowflake-development .opencode/skills/snowflake-development && rm -rf skills-src

Use ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.

OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/

Paste into OpenCode

Install the "snowflake-development" agent skill from https://github.com/borghei/Claude-Skills/tree/main/engineering/snowflake-development into .opencode/skills/snowflake-development/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "snowflake-development", then confirm the skill loads.

OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

Facts

Skill name: snowflake-development
GitHub stars: 881
Token cost: ~746 tokens
SKILL.md length: 247 words
Files: 3 (incl. scripts, references)
Skills in repo: 349
Repo updated: Oct 7, 2026
First seen: Oct 7, 2026
Licence: MIT

At a glance

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…

Works in 4 steps: Collect slow queries from query history → Run analyzer to identify optimization… → Apply recommended changes → …
Asks to optimize Snowflake queries
SKILL.md covers Overview, Clarify First, Quick Start and Tools Overview, plus 3 more sections
Runs Python scripts from its folder; calls python

What it does

Snowflake Development is an agent skill from borghei/Claude-Skills. 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".

Its SKILL.md is about 750 tokens, which your agent loads only when the skill is triggered. The skill folder holds 4 other files, including scripts and reference files (for example `references/snowflake-best-practices.md` and `scripts/snowflake_query_helper.py`).

It sits in Databases, covering Data warehousing. It works with Snowflake and SQL. The repository describes itself as: 385 AI skills, 77 expert agents, and 900 stdlib Python tools for every team: engineering, PM, marketing, C-level, compliance, business ops, research, and a LinkedIn toolkit… The licence is MIT.

When your agent uses it

Asks to optimize Snowflake queries
Analyze Snowflake SQL performance
Size Snowflake warehouses
Review Snowflake data models

Example prompts

“optimize Snowflake queries”
“analyze Snowflake SQL performance”
“size Snowflake warehouses”
“/snowflake-development”

Requirements

Python 3

Workflow steps

4 steps, taken from the first numbered list in SKILL.md.

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

What it can do on your machine

Read from SKILL.md and the folder at commit 4a698e8. It shows what the files ask for, not the result of running them.

Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
Ships 1 file in scripts/ (Python), which the agent can run.
Shell commands in SKILL.md call:
- python
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Snowflake Development loads about 746 tokens when it runs, and up to ~1.7k if it reads all its reference files. Until then it costs about 60 tokens; SKILL.md has 247 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it: ~60
When it runs · the whole SKILL.md, loaded when a task matches: ~746
With references · SKILL.md plus every file in references/, read only if the agent opens them: ~1.7k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

The full file from borghei/Claude-Skills at commit 4a698e8, republished under its MIT licence (© borghei). 247 words, ~746 tokens.

Download SKILL.mdSave it as .claude/skills/snowflake-development/SKILL.md (or your agent's skills folder). This skill also uses 2 other files; get the full folder from GitHub.

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
metadata.author: borghei
metadata.category: engineering
metadata.domain: data-warehouse
metadata.updated: 2026-04-02
metadata.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

bash

# 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

Files

SKILL.md and 2 other files (scripts, references) in engineering/snowflake-development of borghei/Claude-Skills.

SKILL.md
references/snowflake-best-practices.md
scripts/snowflake_query_helper.py

Open the folder on GitHubat commit 4a698e8

Compare with similar skills

Snowflake Development next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Snowflake Development compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Snowflake Development this skillborghei/Claude-Skills	881	—	~746	Automated safety check: Pass	MIT	today
Expensive Snowflake Query FinderAltimateAI/data-engineering-skills	128	—	~662	Automated safety check: Pass	MIT	6 days ago
SQL Queriesw95/awesome-claude-corporate-skills	237	3 repos	~2.8k	Automated safety check: Pass	MIT	7 mo ago
Optimizing Query By IdAltimateAI/data-engineering-skills	128	—	~919	Automated safety check: Pass	MIT	6 days ago
Snowflake Semanticviewgithub/awesome-copilot	40k	1 repos	~1.1k	Automated safety check: Pass	MIT	today
Snowflake Developmentsickn33/agentic-awesome-skills	47k	2 repos	~2.1k	Automated safety check: Pass	MIT	today

Similar skills

Expensive Snowflake Query Finder
AltimateAI/data-engineering-skills
Ranks the costliest, slowest or heaviest-scanning Snowflake queries from query history and suggests how to optimize them.
128 GitHub stars~662 tokensUpdated 6 days ago
DatabasesAuto-check passed
SQL Queries
w95/awesome-claude-corporate-skills
Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.).
237 GitHub starsUsed in 3 repos~2.8k tokens
DatabasesAuto-check passed
Optimizing Query By Id
AltimateAI/data-engineering-skills
Optimizes Snowflake query performance using query ID from history.
128 GitHub stars~919 tokensUpdated 6 days ago
DatabasesAuto-check passed
Snowflake Semanticview
github/awesome-copilot
Official
Create, alter, and validate Snowflake semantic views using Snowflake CLI (snow).
40k GitHub starsUsed in 1 repo~1.1k tokens
DatabasesAuto-check passed
Snowflake Development
sickn33/agentic-awesome-skills
Comprehensive Snowflake development assistant covering SQL best practices, data pipeline design (Dynamic Tables, Streams, Tasks, Snowpipe), Cortex AI functions, Cortex Agents, Snowpark Python, dbt…
47k GitHub starsUsed in 2 repos~2.1k tokens
DatabasesAuto-check passed
Warehouse SQL
HybridAIOne/hybridclaw
Review and run read-only natural-language SQL against a customer data warehouse with cached schema introspection and explicit write grants.
158 GitHub stars~1.8k tokensUpdated today
DatabasesAuto-check passed

Questions about Snowflake Development

What does Snowflake Development do?

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 Development is an agent skill from borghei/Claude-Skills. 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".

When should I use Snowflake Development?

Snowflake Development fits situations like: asks to optimize Snowflake queries; analyze Snowflake SQL performance; size Snowflake warehouses; review Snowflake data models.

How do I install Snowflake Development in Claude Code?

Run `npx skills add borghei/Claude-Skills --skill snowflake-development -a claude-code`. Or copy the skill folder (engineering/snowflake-development in borghei/Claude-Skills) into .claude/skills/snowflake-development in your project. Claude Code loads it when a task matches its description.

How do I install Snowflake Development in Codex?

Run `npx skills add borghei/Claude-Skills --skill snowflake-development -a codex`. Or copy the skill folder (engineering/snowflake-development in borghei/Claude-Skills) into .agents/skills/snowflake-development in your project. Codex loads it when a task matches its description.

Can I use Snowflake Development in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add borghei/Claude-Skills --skill snowflake-development -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/snowflake-development, .gemini/skills/snowflake-development, .github/skills/snowflake-development and .opencode/skills/snowflake-development in your project.

What does Snowflake Development need to run?

Going by SKILL.md and its folder, Snowflake Development needs Python for the scripts in its folder and the command-line tools its instructions call (python). Our summary lists: Python 3.

Does Snowflake Development access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Snowflake Development safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.

What licence does Snowflake Development use?

Snowflake Development is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Snowflake Development use?

About 746 tokens (SKILL.md is roughly 3k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 949 tokens, read only when the agent opens those files.

What are the alternatives to Snowflake Development?

Skills that share tags, products or a category with Snowflake Development: Expensive Snowflake Query Finder (AltimateAI/data-engineering-skills, 128 stars), SQL Queries (w95/awesome-claude-corporate-skills, 237 stars), Optimizing Query By Id (AltimateAI/data-engineering-skills, 128 stars) and Snowflake Semanticview (github/awesome-copilot, 40k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Snowflake Development?

borghei (a GitHub user) maintains it in borghei/Claude-Skills, which has 881 GitHub stars. The repository holds 349 skills in this directory. The repository was last updated on October 7, 2026.

Source: borghei/Claude-Skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.

Install Snowflake Development

Facts

At a glance

What it does

When your agent uses it

Example prompts

Requirements

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

Snowflake Development

Overview

Clarify First

Quick Start

Tools Overview

Workflows

Query Performance Optimization

Warehouse Right-Sizing

Reference Documentation

Common Patterns

Cost Reduction

Files

Compare with similar skills

Similar skills

More from borghei/Claude-Skills

Related

Questions about Snowflake Development