home/categories/sql-databases/vilnacrm-org-user-service-claude-skills-query-performance-analysis-skill-md
sql-databasesdatabases

query-performance-analysis

Detect N+1 queries, analyze slow queries with EXPLAIN, identify missing indexes, and ensure safe online index migrations for MySQL/MariaDB. Use when optimizing query performance, preventing performance regressions, or debugging slow endpoints. Complements database-migrations skill which covers index creation syntax.

VilnaCRM-Org
maintainer
VilnaCRM-Org
更新於 1/14/2026
星標
16
分支
2
quick start

Installation and usage

Detect N+1 queries, analyze slow queries with EXPLAIN, identify missing indexes, and ensure safe online index migrations for MySQL/MariaDB. Use when optimizing query performance, preventing performance regressions, or debugging slow endpoints. Complements database-migrations skill which covers index creation syntax.

安裝
$ install --globalskills.sh
使用

安裝後,您可以透過在終端機執行以下指令來使用此技能:

skills use query-performance-analysis