Sql Query Optimizer
Analyze and optimize SQL queries for better performance, suggesting indexes, query rewrites, and execution plan improvements
- Type
- Plugin
- Repository
- jeremylongshore/tons-of-skills-marketplace
- GitHub stars
- 2.8k
- License
- MIT
- Repo last updated
- Sep 27, 2026
- Version
- 1.27.0
- Author
- Claude Code Plugins
What Sql Query Optimizer is
Sql Query Optimizer is a plugin published in the jeremylongshore/tons-of-skills-marketplace repository on GitHub, which has about 2.8k stars. The repository describes itself as: “Model-agnostic agent-skills platform with a harness-free canonical layer, verified adapters, and the ccpi package manager. Explore at tonsofskills.com.”
A plugin is a package that bundles skills, slash commands, subagents, hooks, and MCP connectors so they install together. Plugins are plain files with a manifest at .claude-plugin/plugin.json, and they work in both Claude Code and Claude Cowork.
Installing Sql Query Optimizer adds everything it ships in one step. Connectors inside a plugin still need to be connected separately, and hooks and subagents only run in Cowork and Claude Code, not in regular chat.
How to install Sql Query Optimizer
Claude Code
- Add the repository as a plugin marketplace: claude plugin marketplace add jeremylongshore/tons-of-skills-marketplace
- Install the plugin: claude plugin install sql-query-optimizer@<marketplace-name>, using the marketplace name from the repository's .claude-plugin/marketplace.json.
- Restart the session if the new skills or commands don't appear straight away.
Claude Cowork
- Open Customize → Plugins and choose Add marketplace.
- Enter jeremylongshore/tons-of-skills-marketplace (the owner/repo shorthand works for GitHub).
- Find Sql Query Optimizer in the list, click Install, then connect any connectors it needs from its Connectors tab.
New to extending Cowork? Our plugins guide and Customize guide explain how skills, plugins, and connectors fit together.
Inside the source file
An excerpt from plugins/database/sql-query-optimizer/.claude-plugin/plugin.json, shared under the repository's MIT license. Read the full file on GitHub.
Analyze and optimize SQL queries for better performance with index suggestions and query rewrites.
Installation
/plugin install sql-query-optimizer@claude-code-plugins-plusUsage
/optimize-queryFeatures
- Query Analysis: Identify performance bottlenecks
- Index Recommendations: Suggest optimal indexes
- Query Rewriting: Provide optimized alternatives
- Execution Plan Review: Analyze EXPLAIN output
- Best Practices: Follow SQL optimization patterns
Example
Paste your slow query and get optimization suggestions with expected performance improvements.
Requirements
- SQL queries (PostgreSQL, MySQL, SQLite compatible)
- Access to EXPLAIN output (optional but helpful)
License
MIT
Before you install
- Read the whole file first. Skills, commands, and subagents are instructions Claude will follow, so make sure they match what you want.
- Check which tools, scripts, or MCP servers it uses. Local servers and scripts run with your permissions.
- Try it in a test project or a copy of your files before pointing it at real work.
- Pin the version you tested, and review changes before updating.
- Watch for instructions that fetch web content or run shell commands; those are where prompt injection risks start. See our prompt injection guide.
FAQ
What is Sql Query Optimizer?
Sql Query Optimizer is a plugin for Claude Code and Claude Cowork from the jeremylongshore/tons-of-skills-marketplace repository on GitHub. Analyze and optimize SQL queries for better performance, suggesting indexes, query rewrites, and execution plan improvements
How do I install Sql Query Optimizer in Claude Code?
Add the repository as a plugin marketplace: claude plugin marketplace add jeremylongshore/tons-of-skills-marketplace Install the plugin: claude plugin install sql-query-optimizer@<marketplace-name>, using the marketplace name from the repository's .claude-plugin/marketplace.json. Restart the session if the new skills or commands don't appear straight away.
Can I use Sql Query Optimizer in Claude Cowork?
Open Customize → Plugins and choose Add marketplace. Enter jeremylongshore/tons-of-skills-marketplace (the owner/repo shorthand works for GitHub). Find Sql Query Optimizer in the list, click Install, then connect any connectors it needs from its Connectors tab.
Is Sql Query Optimizer safe to install?
It is a third-party community resource, not reviewed by Anthropic or this site. Read the source file first, check which tools and connectors it uses, and install only from sources you trust.
Similar resources
- Dependency Checker Check dependencies for known vulnerabilities, outdated packages, and license compliance Plugin · jeremylongshore/tons-of-skills-marketplace
- Deployment Rollback Manager Manage and execute deployment rollbacks with safety checks Plugin · jeremylongshore/tons-of-skills-marketplace
- Deployment Specialist Deployment strategy and release management expert covering blue/green, canary, rolling, and recreate patterns across Kubernetes, AWS ECS, GCP, and Azure. Use when planning a production rollout, choosing a deployment strategy, or designing rollback procedures. Trigger with \"deployment strategy\", \"zero-downtime deploy\". Subagent · jeremylongshore/tons-of-skills-marketplace
- Demo Generator Creates product demo video scripts with user journey narratives, feature walkthroughs, shot lists, and CTA copy designed to convert viewers to users. Use when building a launch or onboarding video for a product. Trigger with \"create demo video\", \"generate product walkthrough script\". Subagent · jeremylongshore/tons-of-skills-marketplace
- Stackblitz Pack Production StackBlitz workflows for WebContainer lifecycle, embeds, testing, diagnostics, capacity, and security (10 skills) Plugin · jeremylongshore/tons-of-skills-marketplace
- Sprint Autonomous multi-agent development framework with spec-driven sprints and convergent iteration Plugin · jeremylongshore/tons-of-skills-marketplace
- Staking Rewards Optimizer Optimize staking rewards across multiple protocols and chains Plugin · jeremylongshore/tons-of-skills-marketplace
- Speak Pack Claude Code skill pack for Speak AI Language Learning Platform (24 skills) Plugin · jeremylongshore/tons-of-skills-marketplace