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.

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

01Detailed database query profiling and indexing suggestions

02Root cause analysis for application latency and responsiveness issues

033 GitHub stars

04Multi-layer analysis covering CPU, memory, I/O, and database operations

05Actionable remediation strategies with production-ready code examples

06Automated identification of memory leaks and resource exhaustion

Use Cases

01Identifying and fixing memory leaks in long-running background processes

02Optimizing resource-heavy logic to reduce CPU overhead and infrastructure costs

03Diagnosing and rewriting slow database queries to improve throughput

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection bottleneck-detector

For use in Claude.ai and ChatGPT

Download Skill