optimizing-query-text

What problem does it solve?

This Skill helps you improve the performance of Snowflake SQL by rewriting your provided query to eliminate common performance anti-patterns while preserving identical results.

Core Features & Use Cases

• Snowflake query tuning from text: Optimizes SQL performance based on the query you paste, without changing the intent or output.
• Safe pattern-based rewrites: Applies targeted transformations like converting function-wrapped filters into equivalent range predicates and replacing implicit joins with explicit JOIN syntax.
• Result-preservation guardrails: Ensures column order, selected fields, filtering semantics, ORDER BY, and LIMIT behavior remain identical; if it cannot guarantee equivalence, it returns the original query unchanged.
• Use case: A business analyst has a slow Snowflake dashboard query and needs it optimized for faster interactive performance.

Quick Start

Paste your Snowflake SQL query and ask the assistant to optimize it for better performance.