skills.rest
miptah21
miptah21COMMUNITY
Explore all skills by this author →
GitHub

sql-optimization

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
One-click install
npx skills add https://github.com/miptah21/skills --skill sql-optimization-miptah21
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
miptah21miptah21
2

optimizing-query-text

Optimize Snowflake SQL query text with semantics-preserving transformations.

Community
Intermediate
alexander-danilenkoalexander-danilenko
14

sql-pro

Optimize slow SQL queries and schemas with EXPLAIN plan analysis and index recommendations.

Community
Advanced
fakhriaditiarahmanfakhriaditiarahman
1

sql-pro

Optimize SQL queries and design data models for Snowflake, BigQuery, and PostgreSQL.

Community
Advanced
jaimedhenriquesjaimedhenriques

sql-queries

Write performant SQL queries across Snowflake, BigQuery, Databricks, PostgreSQL, and Redshift.

Community
Advanced