arch-performance-optimization
Use when analyzing and improving performance for database queries, API endpoints, or frontend rendering.
Security Assessment
About arch-performance-optimization
The 'arch-performance-optimization' skill is designed to assist in the analysis and optimization of performance bottlenecks across various layers of an application, including database queries, API endpoints, and frontend rendering. It aims to help identify slow response times, high resource usage, or any scalability concerns in an application’s architecture, providing targeted solutions to resolve these issues effectively. By following a structured, evidence-based approach, this skill allows users to apply performance optimizations systematically and with high confidence, avoiding speculative recommendations.
This skill provides a comprehensive workflow for performance optimization, beginning with identifying the type of bottleneck (e.g., database, API, network, or frontend) and progressing through stages such as measuring baseline performance, applying specific optimizations (like caching or lazy loading), and verifying the results. Key features include rules for database query optimization, API response time improvements, and frontend performance enhancements. It includes detailed guidance on issues such as avoiding N+1 queries, using async I/O, and applying bounded parallelism for background jobs, among other best practices.
Ideal for developers, DevOps engineers, and system architects, this skill is targeted at anyone working on optimizing the performance of APIs, databases, or frontend applications. It is especially useful for those facing challenges like slow API response times, inefficient database queries, large frontend bundles, or scalability issues that require critical performance improvements.
FAQ
How do I identify which layer is causing the performance issue?
The workflow begins by identifying the bottleneck type: database, API, network, or frontend. Each layer has specific steps to measure and pinpoint the issue, such as using curl for API response times, SET STATISTICS TIME for database query performance, or analyzing frontend bundle sizes.
Are there any requirements for using this skill?
Yes, you must ensure that you gather baseline performance metrics, such as response times, query times, and bundle sizes, before implementing optimizations. It's also important to follow the evidence-based reasoning protocol to ensure changes are backed by measurable data.
Can this skill optimize both frontend and backend performance?
Yes, this skill is designed to optimize performance across both frontend and backend layers. It includes detailed steps for database query optimization, API performance tuning, and frontend rendering improvements.
What should I do if I suspect a performance issue but can't identify the root cause?
Follow the performance analysis framework to systematically classify the bottleneck type. This will help you narrow down the problem to either the database, API, network, or frontend. From there, you can apply the appropriate optimizations.
Is this skill compatible with all development environments?
The skill can be used in most development environments that involve database queries, API calls, or frontend rendering. However, it may require certain tools like curl, npm, or database access for measuring performance.
Install arch-performance-optimization
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill
Repository
duc01226/EasyPlatform