# Syn Mysql Indexing

> Operate, configure, troubleshoot, and manage MySQL. Use for MySQL engineering tasks, day-to-day operations, and production support.

- Skill: `legendtkl/syn-mysql-indexing` (Agent Skill)
- Install (CLI): `npx skillmds@latest add legendtkl/syn-mysql-indexing`
- Raw SKILL.md: https://api.skillmd.com/api/skills/legendtkl/syn-mysql-indexing/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: legendtkl (https://skillmd.com/u/legendtkl)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/legendtkl/syn-mysql-indexing

---


# 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.