skills/modelscope.cn/query-performance-analysis

query-performance-analysis

SKILL.md

Query Performance Analysis & Index Management

Context (Input)

Use this skill when:

  • New or modified endpoints are slow
  • Profiler shows many database queries for single operation
  • Need to detect N+1 query problems
  • Query execution time is high
  • Slow query warnings in MySQL logs
  • Performance regression after code changes
  • Planning safe index migrations for production
  • Need to verify index effectiveness

Task (Function)

Analyze query performance, detect N+1 issues, identify missing indexes, and create safe online index migrations with verification steps.

Installs
1
First Seen
May 18, 2026
query-performance-analysis from modelscope.cn