Syn Mysql Indexing

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

legendtkl 9f25e10 729 B Updated

File contents

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.

legendtkl/agentic-skill-router/tree/main/experiments/dci-compare/synthetic-skills/syn-mysql-indexing commit 9f25e1091b

Frequently asked questions

npx skillmds@latest add legendtkl/syn-mysql-indexing