MariaDB Query Optimizer

An orchestration skill : a deterministic 7-step procedure Claude applies whenever a user hands over a slow query and wants it made faster. This skill does NOT teach EXPLAIN syntax. It is a checklist that drives the analysis and references three companion skills for the underlying mechanics.

When To Use This Skill

• The user pastes a SQL query and says it is slow, takes forever, or times out.
• The user pastes a query plus EXPLAIN output and asks for an optimization.
• The user asks "should I add an index here" or "which index do I need".
• The user proposes an index or FORCE INDEX and asks whether it is correct.

Quick Reference