sql-optimization

Name: sql-optimization
Availability: InStock
Author: miptah21

Route SQL optimization requests to Snowflake and cross-dialect guidance.

2|Updated Apr 8, 2026

Search Tags:#query optimization #sql #performance tuning #snowflake #query id #sql writing

Ready to run

npx skills add https://github.com/miptah21/skills --skill sql-optimization-miptah21

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sql-optimization
Source: https://github.com/miptah21/skills/tree/main/.agents/skills/_deprecated/sql-optimization
Command: npx skills add https://github.com/miptah21/skills --skill sql-optimization-miptah21

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This deprecated skill helps you find Snowflake and cross-dialect SQL optimization guidance, but it no longer provides the primary instructions itself.

Core Features & Use Cases

Snowflake optimization (by SQL text): Route optimization requests when you have the full query text available.
Snowflake optimization (by query ID): Route optimization requests when you reference a query by its ID.
General SQL optimization (any dialect): Route new SQL writing and performance guidance across SQL dialects.

Quick Start

Use the optimizing-query-text skill when you want Snowflake query optimization from the SQL text you already have.

Frequently Asked Questions about sql-optimization

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I optimize a slow Snowflake SQL query from its text?▼

To optimize Snowflake SQL performance from query text, you need routing to a dedicated performance tuning skill. This layer redirects your SQL text to the correct downstream optimizer for execution plan analysis and rewriting.

Can I use a Snowflake query ID to get SQL performance tuning recommendations?▼

Yes, SQL performance tuning can be routed using a Snowflake query ID. The system directs your query identifier to a specialized optimization skill to retrieve and analyze the historical execution plan for improvements.

Does this tool support SQL performance tuning for BigQuery, Redshift, or Databricks?▼

Yes, cross-dialect SQL performance tuning is supported for platforms like BigQuery, Redshift, and Databricks. The routing layer evaluates your query and directs it to the appropriate general SQL writing and optimization skill.

What is the best way to get general SQL writing guidance across different dialects?▼

The best way to get cross-dialect SQL writing guidance is through a routing skill that directs your request to specialized optimization tools. It evaluates your SQL text and matches it to the correct dialect-specific performance tuner.

Why is my SQL optimization skill only redirecting my query instead of executing it?▼

Your SQL optimization skill is functioning as a deprecated routing layer rather than executing its own optimization logic. It intentionally redirects your Snowflake or general SQL text to dedicated downstream skills for actual performance tuning.

Do I need the full SQL text to get performance tuning recommendations for Snowflake?▼

No, you do not strictly need the full SQL text for Snowflake performance tuning. You can alternatively provide a Snowflake query ID, which the routing layer will direct to the appropriate optimization skill for analysis.