Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →borghei/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".
Passed 21 of 22 test cases with the skill, and 11 of 22 without it.
and 10 more in the full report
10 fixed11 passed either way1 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 10 test cases the skill fixed. Same model, same prompt, with and without the skill.
Which two specific flags are required by `snowflake_query_helper.py` to drive warehouse recommendations for an ETL workload?
| Checked | Without skill | With skill |
|---|---|---|
| Identifies --workload and --data-volume as the required flags. | Missed | Passed |
The instructions your model reads when the skill loads.
Category: Engineering Domain: Data Warehouse
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.
Before analyzing or sizing, confirm these inputs. If any is unknown or vague, ASK — do not assume:
--action; selects the workflow)--file; the subject of the analysis)--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.
# 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
| Tool | Purpose | Key Flags |
|---|---|---|
snowflake_query_helper.py | Analyze, optimize Snowflake SQL and recommend warehouse sizes | --file, --action, --workload, --data-volume |
test cases passed, vs 11 / 22 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.