skills/smithery.ai/optimizing-sql-queries

optimizing-sql-queries

SKILL.md

Overview

This skill empowers Claude to analyze SQL queries, identify performance bottlenecks, and suggest optimizations such as index creation or query rewriting. It leverages the sql-query-optimizer plugin to provide actionable recommendations for improving database performance.

How It Works

  1. Query Input: The user provides an SQL query to be optimized.
  2. Analysis: The plugin analyzes the query structure, potential indexing issues, and execution plan (if available).
  3. Recommendations: The plugin generates optimization suggestions, including index recommendations and query rewrites.

When to Use This Skill

This skill activates when you need to:

  • Optimize a slow-running SQL query.
  • Identify missing or unused indexes in a database.
  • Improve the performance of a database application.

Examples

Installs
2
First Seen
Apr 1, 2026