# Query Performance Analysis

> Detect N+1 queries, analyze slow queries with the engine-native plan tool (MySQL/MariaDB EXPLAIN or MongoDB explain()), identify missing indexes, and create safe online index migrations, branching on the profile's persistence.engine. Use when optimizing query performance, preventing performance regressions, or debugging slow endpoints. Complements database-migrations, which covers index creation syntax.

## Facts
- Page: https://tashan.sh/capability/skill-vilnacrm-org-query-performance-analysis
- tashan id: skill:VilnaCRM-Org/query-performance-analysis
- Source: https://github.com/VilnaCRM-Org/claude-plugins
- Type: skill
- Category: database
- tashan score: not scored (catalogued only — too little public evidence)
- Adoption: 9.0
- Upkeep: 99.0
- Freshness: 98.0
- Evidence coverage: 84% of the inputs this score can use
- Health: active
- Instruction depth: not yet graded
- Official: no

## Install

```sh
cp -r query-performance-analysis ~/.claude/skills/
```

## Security audit
Not scanned. We audit npm-published capabilities; this one has no npm package we can resolve, or has not reached the queue. This is not a clean bill of health.

---
Measured 2026-09-12 by tashan (https://tashan.sh) from public evidence. Scorer s5.