query-optimize
CommunityOptimize SQL/NoSQL queries for peak performance.
Authormanastalukdar
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses database performance bottlenecks by analyzing and optimizing SQL and NoSQL queries, detecting common issues like N+1 problems, and recommending appropriate indexes.
Core Features & Use Cases
- N+1 Query Detection: Identifies inefficient query patterns common in ORMs.
- Index Recommendations: Suggests missing indexes based on query analysis.
- Query Plan Analysis: Provides insights into query execution for PostgreSQL, MySQL, MongoDB, and SQLite.
- Use Case: A developer notices their application is running slowly. They use this Skill to analyze their database queries, identify that many
findManycalls within loops are causing N+1 issues, and receive recommendations to use eager loading and add specific indexes to improve performance.
Quick Start
Use the query-optimize skill to analyze the database queries in the current project.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferences
💻 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-optimize Download link: https://github.com/manastalukdar/claude-devstudio/archive/main.zip#query-optimize Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.