sql-query-optimizer · jeremylongshore — Claude Code skill for SQL query tuning
A skill that walks through SQL query optimization and writes the code for you. It turns on by itself when your prompt mentions sql query optimizer, sql optimizer, or just sql.
MIT 1 installs ★ 2,935 updated 2026-11-01
npx skills add jeremylongshore/tons-of-skills-marketplace --skill sql-query-optimizer -a claude-codeWhat sql-query-optimizer does
The skill gives step-by-step guidance for tuning SQL queries and generates code you can put into production. It follows common practices and checks the output against typical standards.
It belongs to the Data Analytics category, so it also covers sql queries, data visualization, statistical analysis, and business intelligence. You do not call it explicitly: mentioning sql query optimizer in a request is enough to trigger it.
Allowed tools are Read, Write, Edit, Bash(cmd:*), and Grep. You need a configured development environment and access to whatever tools you work with. The skill targets Claude Code, but installs into Codex, Cursor, Copilot, Gemini CLI, and OpenCode too.
What it helps with
- Pick apart a slow SQL query and find what holds it back
- Get a step-by-step optimization plan
- Generate production-ready SQL and configuration code
- Check queries against standard validation rules
- Pull data analytics help without leaving the agent
Example prompts for the agent
- Help me optimize this SQL query: SELECT ... FROM ...
- Look at this query and suggest how to make it run faster
- Check this SQL against common best practices
How to install sql-query-optimizer
1Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill sql-query-optimizer -a claude-code2Manually: put the files in place
~/.claude/skills/sql-query-optimizer/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/sql-query-optimizer/
1Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill sql-query-optimizer -a codex2Manually: put the files in place
.agents/skills/sql-query-optimizer/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill sql-query-optimizer -a cursor2Manually: put the files in place
.cursor/skills/sql-query-optimizer/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install jeremylongshore/tons-of-skills-marketplace skills/12-data-analytics/sql-query-optimizer2Manually: put the files in place
.github/skills/sql-query-optimizer/SKILL.md1Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill sql-query-optimizer -a gemini-cli2Platform CLI
gemini skills install https://github.com/jeremylongshore/tons-of-skills-marketplace --path skills/12-data-analytics/sql-query-optimizerManually: put the files in place
.devin/skills/sql-query-optimizer/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill sql-query-optimizer -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about sql-query-optimizer
How do I install sql-query-optimizer in Claude Code?
Run npx skills add jeremylongshore/tons-of-skills-marketplace --skill sql-query-optimizer -a claude-code. The skill lands in ~/.claude/skills/sql-query-optimizer/SKILL.md.
What does sql-query-optimizer do?
It gives step-by-step SQL optimization guidance, generates code and configurations, and validates results against common standards.
What tools does the skill have access to?
Read, Write, Edit, Bash(cmd:*), and Grep. It can read and write files, run commands, and search the project.
Source text
SKILL.md · MIT
--- name: sql-query-optimizer description: 'Optimize sql query optimizer operations. Auto-activating skill for Data Analytics. Triggers on: sql query optimizer, sql query optimizer Part of the Data Analytics skill category. Use when working with sql query optimizer functionality. Trigger with phrases like "sql query optimizer", "sql optimizer", "sql". ' allowed-tools: Read, Write, Edit, Bash(cmd:*), Grep version: 1.0.0 license: MIT author: Jeremy Longshore <[email protected]> tags: - data - analytics compatibility: Designed for Claude Code --- # Sql Query Optimizer ## Overview This skill provides automated assistance for sql query optimizer tasks within the Data Analytics domain. ## When to Use This skill activates automatically when you: - Mention "sql query optimizer" in your request - Ask about sql query optimizer patterns or best practices - Need help with data analytics skills covering sql queries, data visualization, statistical analysis, and business intelligence. ## Instructions 1. Provides step-by-step guidance for sql query optimizer 2. Follows industry best practices and patterns 3. Generates production-ready code and configurations 4. Validates outputs against common standards ## Examples **Example: Basic Usage** Request: "Help me with sql query optimizer" Result: Provides step-by-step guidance and generates appropriate configurations ## Prerequisites - Relevant development environment configured - Access to necessary tools and services - Basic understanding of data analytics concepts ## Output - Generated configurations and code - Best practice recommendations - Validation results ## Error Handling | Error | Cause | Solution | |-------|-------|----------| | Configuration invalid | Missing required fields | Check documentation for required parameters | | Tool not found | Dependency not installed | Install required tools per prerequisites | | Permission denied | Insufficient access | Verify credentials and permissions | ## Resources - Official documentation for related tools - Best practices guides - Community examples and tutorials ## Related Skills Part of the **Data Analytics** skill category. Tags: sql, analytics, visualization, statistics, bi
© Jeremy Longshore · MIT · jeremylongshore/tons-of-skills-marketplace
Similar skills
All skills for Data and databases →sql-query-optimizer by other authors comes first.