Skills
.Work. You
Rest

query-performance-analysis

Official

Analyze and optimize query performance safely

Software Engineering#performance#indexing#profiling#mongodb#analyze#n+1#explain
AuthorVilnaCRM-Org
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Detects N+1 queries, slow queries, and missing indexes in MongoDB-backed endpoints to prevent performance regressions.

Core Features & Use Cases

  • N+1 query detection and resolution using profiling and efficient loading strategies.
  • Slow query identification with EXPLAIN analysis and index recommendations.
  • Safe online index migrations with verification steps to minimize production impact.

Quick Start

Enable MongoDB profiling, run the targeted endpoint, and review EXPLAIN results to validate index usage and performance improvements.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: query-performance-analysis
Download link: https://github.com/VilnaCRM-Org/core-service/archive/main.zip#query-performance-analysis

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.