How do I trigger a performance analysis?

You can use triggers like 'slow query', 'optimize SQL', or 'API timeout', or simply share a log snippet showing high execution times for the AI to analyze.

Does it help with JVM or memory issues?

Yes, it includes specialized guidance for using Arthas to diagnose JVM issues, OOM errors, and thread pool exhaustion.

How does Performance Doctor help with slow SQL?

It analyzes your query patterns, suggests appropriate indexing strategies, and uses EXPLAIN plans to identify bottlenecks in your database execution.

Can this skill fix N+1 query problems automatically?

Yes, it identifies loops that perform individual database lookups and provides refactored code using batch queries and Map-based lookups for maximum efficiency.

What caching technologies does it support?

It specializes in Spring Cache, Redisson for distributed caching and locking, and Caffeine for high-performance local caching.

Performance Doctor

Name: Performance Doctor
Author: xu-cell

byxu-cell

•

数据库管理

Diagnoses and optimizes backend performance issues including SQL bottlenecks, caching strategies, and N+1 query problems.

Performance Doctor is a specialized Claude Code skill designed to identify and resolve backend latency and scalability issues. It provides expert guidance on optimizing MyBatis-Plus queries, implementing robust Redis caching with Redisson, fixing N+1 database access patterns, and performing deep-dive log analysis using tools like p6spy and Arthas. Whether you're dealing with slow API responses or database timeouts, this skill offers actionable patterns and automated diagnostic steps to streamline your system's performance and ensure high availability.

主要功能

01Automated SQL slow query diagnosis and index optimization recommendations

02Optimization of large-scale batch operations to prevent timeouts and OOM

0311 GitHub stars

04Performance log analysis using p6spy, SkyWalking, and Arthas JVM diagnostics

05Pattern-based detection and fixing of N+1 database query issues

06Implementation of multi-layer caching using Redisson, Spring Cache, and Caffeine

使用场景

01Reducing API response times for complex endpoints from seconds to milliseconds

02Restructuring database interactions to eliminate redundant queries in loops

03Designing distributed locking and rate-limiting strategies for high-concurrency environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xu-cell/ai-engineering-init performance-doctor

For use in Claude.ai and ChatGPT

Download Skill