Can it detect N+1 query problems?

Yes, it analyzes the total number of SQL queries executed for specific operations and highlights increases that suggest the introduction of N+1 issues.

How does it compare performance between branches?

The skill checks out the specified branches (e.g., main vs feature), runs your project's performance tests, and compares the output metrics for response times and resource usage.

Does it provide optimization suggestions?

Yes, beyond just reporting regressions, it suggests improvements like adding database indexes, implementing caching, or optimizing SELECT clauses.

What metrics does it evaluate for regression?

It tracks average response times, P95/P99 latency percentiles, total query volume per request, and memory heap usage changes.

Performance Diff & Regression Detector

Name: Performance Diff & Regression Detector
Author: Hopin-inc

byHopin-inc

•

分析と監視

Analyzes code changes to detect performance regressions by comparing response times, query counts, and memory usage between branches.

The performance-diff skill automates the critical task of performance benchmarking during the development lifecycle. By comparing 'before' and 'after' states of a codebase, it identifies latency increases, SQL query regressions such as new N+1 problems, and memory footprint changes. It provides structured reports with executive summaries, scoring, and actionable optimization suggestions, ensuring that every pull request maintains or improves the application's speed and efficiency.

主な機能

01Database index impact evaluation and memory usage tracking

02SQL query count analysis and N+1 problem detection

034 GitHub stars

04Response time benchmarking (Avg, P50, P95, P99) with threshold alerts

05Detailed reporting with optimization recommendations

06Automated PR performance comparison and regression scoring

ユースケース

01Verifying that a new feature doesn't introduce latency in high-traffic GraphQL endpoints

02Benchmarking the performance gain of a new database index or caching strategy

03Identifying N+1 query issues before they reach production during a code refactor

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hopin-inc/civicship-api performance-diff

For use in Claude.ai and ChatGPT

Download Skill