Skip to content
TrustedSkillsbeta
Back to all skills

Sql Query Optimizer

Listed
jeremylongshore·vlatest·database·MIT

Provides querying guidance and assistance for working with databases and data persistence.

Repository

Install on your platform

Showing Claude Code. One command installs this skill into any of the agents below.

  1. 1

    Run this in your project

    terminal
    $ npx skills add jeremylongshore/tons-of-skills-marketplace --skill sql-query-optimizer -a claude-code

  2. Uses the open-source skills CLI and needs Node.js. Add -g to install it for your user instead of this project.

What we know about this skill

Publisher

jeremylongshore

Taken from the source listing. We haven't verified who controls this account.

Install target

Live repository

Not pinned. Installing fetches whatever the repository holds at the time you run the command.

Nobody has reviewed this code. TrustedSkills indexes and links skills; it does not audit, run or scan them. A skill runs with whatever access you give your agent — read the source before you install it.

Automated safety checks

scanned

We could not read this skill's source, so none of the checks below were run.

Not scanned. none of the 396 skills in the repository match this slug — it was most likely renamed or removed upstream after the registry indexed it Source recorded as jeremylongshore/claude-code-plugins-plus-skills.
This is a static scan, not a review. It reads the skill's files; it does not run them, and it cannot tell you whether the skill is any good or whether the code does what its description says. A skill runs with whatever access you give your agent.
What each check looks for →

About this skill

What it does

This skill optimizes SQL queries to improve performance and efficiency. It analyzes existing SQL code, identifies potential bottlenecks, and suggests modifications such as index creation or query restructuring. The goal is to reduce execution time and resource consumption for database operations.

When to use it

  • Slow Query Performance: When a specific SQL query takes an unacceptably long time to execute.
  • High Database Load: To alleviate strain on the database server by optimizing frequently run queries.
  • Complex Joins: When dealing with complex joins across multiple tables that are impacting performance.
  • Large Datasets: When querying large datasets where optimization can significantly reduce processing time.

Key capabilities

  • SQL query analysis
  • Performance bottleneck identification
  • Index suggestion
  • Query restructuring recommendations

Example prompts

  • "Optimize this SQL query: SELECT * FROM orders WHERE customer_id = 123;"
  • "Can you suggest ways to improve the performance of this stored procedure?"
  • "Analyze this query and recommend indexes that would speed it up: ...complex query..."

Tips & gotchas

The skill requires access to the SQL query for analysis. It's best suited for standard SQL dialects; proprietary extensions might not be fully supported.