Mysql Query Optimization Skills
Diagnostica y optimiza consultas MySQL/Aurora lentas con evidencia (EXPLAIN ANALYZE, loops × rows, páginas tocadas) en vez de con intuición, y aplica las reescrituras que sí pagan — ROW_NUMBER en vez de auto-join por máximo, STRAIGHT_JOIN condicionado al filtro, filtro selectivo primero, ventana acotada más rescate puntual, verificación de equivalencia por multiconjunto. Incluye la estrategia de saldo acumulado por período más delta, para cuando la query correcta es recorrer todo el histórico y el costo crece solo. Úsala siempre que una query o un reporte esté lento, no termine, o demore en la Lambda pero no en tu máquina; cuando haya que leer un EXPLAIN, proponer un índice, reescribir un JOIN, una subconsulta o un GROUP BY, obtener el último valor por grupo; o cuando el trabajo toque saldos, stock, existencias, inventario, costo promedio, cierres por período, o que un cálculo deje de recorrer todo el histórico.
Security AStatic scan found no risk patternsHow grading works ›
From the source SKILL.md
Dos cosas en una skill porque en la práctica van juntas: primero medir y arreglar la query (§A) y, cuando la query correcta es "toda la historia", cambiar la forma de leer con una ventana acotada (§A.6) o con la estrategia de saldo acumulado (§B).
What this skill does
Mysql Query Optimization Skills is a community-contributed Claude Code skill in the databases sub-category. It ships as a SKILL.md file that Claude Code auto-discovers under ~/.claude/skills/mysql-query-optimization-skills/ and loads when your prompt matches the skill's trigger.
Who uses this skill
The Mysql Query Optimization Skills Claude Code skill is built for software engineers, backend developers, full-stack teams, and technical leads building and maintaining production systems. It's part of ClaudSkills (also referred to as Claude Skills or Claude Code Skills) — the open community-curated registry of 196,000+ SKILL.md files for Anthropic's Claude Code agent and the wider Claude ecosystem (Claude API, Claude Agent SDK).
How to install
Free
Manual install (2 steps)
mkdir -p ~/.claude/skills/mysql-query-optimization-skills
curl -L https://claudskills.com/skills/mysql-query-optimization-skills/SKILL.md \
-o ~/.claude/skills/mysql-query-optimization-skills/SKILL.md
Or just download SKILL.md directly and drop it into ~/.claude/skills/mysql-query-optimization-skills/. Claude Code auto-discovers it on next session.
Skills live at ~/.claude/skills/mysql-query-optimization-skills/SKILL.md on macOS/Linux, or %USERPROFILE%\.claude\skills\mysql-query-optimization-skills\SKILL.md on Windows. See the full install guide for step-by-step instructions.
Telegram
📱 Install from your phone or desktop Telegram
Open @claudskills_bot on Telegram, tap Open Desktop App, and the desktop app installs this skill for you. Or share the bot link with a colleague — they get the same one-tap install. Learn more →
Pro
One-click install via the desktop app
The ClaudSkills desktop app installs any skill directly into ~/.claude/skills/ with one click — no terminal required. Pro starts at $9/mo or $149 lifetime.
Pro
For the full experience including quality scoring and one-click install features for each skill — upgrade to Pro.
Frequently asked questions
How do I install the Mysql Query Optimization Skills Claude Code skill?
Install via the ClaudSkills desktop app (one click) or copy
SKILL.md from the source repository to
~/.claude/skills/mysql-query-optimization-skills/SKILL.md and restart Claude Code. Both flows are detailed at
claudskills.com/install/.
What does the Mysql Query Optimization Skills skill do?
Diagnostica y optimiza consultas MySQL/Aurora lentas con evidencia (EXPLAIN ANALYZE, loops × rows, páginas tocadas) en vez de con intuición, y aplica las reescrituras que sí pagan — ROW_NUMBER en vez de auto-join por máximo, STRAIGHT_JOIN condicionado al filtro, filtro selectivo primero, ventana acotada más rescate puntual, verificación de equivalencia por multiconjunto. Incluye la estrategia de saldo acumulado por período más delta, para cuando la query correcta es recorrer todo el histórico y el costo crece solo. Úsala siempre que una query o un reporte esté lento, no termine, o demore en la Lambda pero no en tu máquina; cuando haya que leer un EXPLAIN, proponer un índice, reescribir un JOIN, una subconsulta o un GROUP BY, obtener el último valor por grupo; o cuando el trabajo toque saldos, stock, existencias, inventario, costo promedio, cierres por período, o que un cálculo deje de recorrer todo el histórico.
Is this skill free to install?
Yes. ClaudSkills is an open registry — every skill keeps its source repository's license, and manual install via copy is free. ClaudSkills Pro ($9/mo, $79/yr, or $149 one-time) adds one-click install via the desktop app and a multi-signal Quality Score.
When should I use the Mysql Query Optimization Skills skill?
Use Mysql Query Optimization Skills when your Claude Code task falls under the Engineering category — specifically in the databases area. Claude Code auto-discovers installed skills and invokes the right one based on the task description, so you can also ask Claude directly (e.g. "use Mysql Query Optimization Skills" or describe the task and let Claude pick). Browse related skills at
/category/engineering/.
What is a Claude Code skill and how does the Mysql Query Optimization Skills skill fit in?
A Claude Code skill is a
SKILL.md file that lives under
~/.claude/skills/<name>/ and tells the Claude Code CLI agent how to perform a specific task (instructions, prompts, allowed tools). Skills are auto-discovered at session start. Mysql Query Optimization Skills is one of 67,000+ skills indexed in the open ClaudSkills catalog, classified under the Engineering category. Learn more at
/learn/what-is-a-claude-skill/.
Attribution & license
Cite this skill
If you reference this skill in a blog post, paper, or documentation, you can cite it as:
APA
JoseLuis21. (2026). Mysql Query Optimization Skills [Claude Code skill]. ClaudSkills. https://claudskills.com/skills/mysql-query-optimization-skills/
BibTeX
@misc{mysql-query-optimization-skills-2026,
author = {JoseLuis21},
title = {Mysql Query Optimization Skills [Claude Code skill]},
year = {2026},
publisher = {ClaudSkills},
url = {https://claudskills.com/skills/mysql-query-optimization-skills/}
}Embed this skill
Promote, attribute, or link this skill from your own README, blog post, or documentation. All three snippets are free to use — no sign-up, no API key. More distribution surfaces →
Badge
[](https://claudskills.com/skills/mysql-query-optimization-skills/?utm_source=badge&utm_medium=readme&utm_campaign=skill_badge)
<script>
<script src="https://claudskills.com/embed/mysql-query-optimization-skills.js" async></script>
<iframe>
<iframe src="https://claudskills.com/embed/mysql-query-optimization-skills.html" width="100%" height="160" frameborder="0" loading="lazy" title="ClaudSkills: Mysql Query Optimization Skills"></iframe>
Security scan
Grade A · scanned 2026-09-28 — free static scan against the OWASP Agentic Skills Top 10.
No risk patterns were found in any of the ten OWASP-aligned categories. How grading works ›
- ✓ Prompt injection
- ✓ Data exfiltration
- ✓ Supply chain
- ✓ Reverse shell
- ✓ Credentials
- ✓ Execution
- ✓ Filesystem
- ✓ Persistence
- ✓ Obfuscation
- ✓ Network
Show this grade on your repo (click to copy):
[](https://claudskills.com/skills/mysql-query-optimization-skills/#security)
More Engineering skills
Browse all Engineering skills in the ClaudSkills registry, or explore these other picks from the same category:
Part of Acreator Store — Adam Lankamer's AI tools:
PerfectStudio ·
Ucaption ·
UTagger ·
AutoXPoster ·
TestYourSkills ·
AutomationFlows ·
Au Naturel ·
Telegram @acreatorstore