---

name: syn-mysql-indexing description: Operate, configure, troubleshoot, and manage MySQL. Use for MySQL engineering tasks, day-to-day operations, and production support.

MySQL: index and query optimization

When to use

Use this skill for index and query optimization in MySQL. This skill specifically handles index and query optimization and nothing else in the MySQL family.

Procedure

Read EXPLAIN output, add composite/covering indexes, fix non-sargable predicates, and remove unused indexes.

Notes

This is the MySQL skill dedicated to index and query optimization. Sibling skills cover other MySQL capabilities; this one is the right choice only when the task is about index and query optimization.