Can this skill help with slow database queries?

Yes, it specifically analyzes query performance and data flow to suggest optimizations such as indexing, query rewriting, or schema adjustments.

When is the best time to trigger this skill?

You should use this skill during the debugging phase when you notice application slowness, before a major release for proactive auditing, or when resource costs spike.

How does the Bottleneck Detector find performance issues?

The skill uses file analysis and shell commands to inspect application architecture, logs, and code patterns, identifying common indicators of CPU, memory, and I/O inefficiencies.

Does it provide the actual code to fix the bottlenecks?

Yes, the skill generates remediation strategies accompanied by specific code examples that you can apply to resolve the identified performance issues.

Performance Bottleneck Detector

Name: Performance Bottleneck Detector
Author: BbgnsurfTech

byBbgnsurfTech

•

Analytics & Monitoring

Identifies and resolves performance bottlenecks across application layers, optimizing CPU, memory, I/O, and database efficiency.

About

The Bottleneck Detector skill provides Claude with advanced diagnostic capabilities to pinpoint performance regressions and resource inefficiencies within your codebase. By analyzing application architecture, profiling resource usage, and examining database queries, the skill helps developers uncover the root causes of slowness and memory leaks. It offers actionable remediation strategies and code examples to enhance application responsiveness and ensure proactive performance management, making it an essential tool for maintaining high-performance production environments.

Key Features

Detailed database query profiling and indexing suggestions
Root cause analysis for application latency and responsiveness issues
3 GitHub stars
Multi-layer analysis covering CPU, memory, I/O, and database operations
Actionable remediation strategies with production-ready code examples
Automated identification of memory leaks and resource exhaustion

Use Cases

Identifying and fixing memory leaks in long-running background processes
Optimizing resource-heavy logic to reduce CPU overhead and infrastructure costs
Diagnosing and rewriting slow database queries to improve throughput

About

Key Features

Detailed database query profiling and indexing suggestions
Root cause analysis for application latency and responsiveness issues
3 GitHub stars
Multi-layer analysis covering CPU, memory, I/O, and database operations
Actionable remediation strategies with production-ready code examples
Automated identification of memory leaks and resource exhaustion

Use Cases

Identifying and fixing memory leaks in long-running background processes
Optimizing resource-heavy logic to reduce CPU overhead and infrastructure costs
Diagnosing and rewriting slow database queries to improve throughput