Spine is a specialized backend engineering skill designed to audit and optimize application performance within the Claude Code environment. It automates the detection of common architectural issues like N+1 ORM queries, unindexed database columns, and synchronous blocking calls by combining static analysis with live endpoint profiling. Whether troubleshooting a slow API or proactively hardening a production service, Spine provides actionable code fixes and detailed impact reports to ensure high-performance, scalable backend systems.
主な機能
01Live endpoint profiling with p50, p95, and p99 latency reporting
0247 GitHub stars
03Automated N+1 query detection through static analysis of ORM patterns
04Database schema audit for missing WHERE, JOIN, and composite indexes
05Strategic caching recommendations for high-traffic data and expensive computations
06Identification of synchronous bottlenecks and parallelization opportunities
ユースケース
01Refactoring legacy ORM code to eliminate redundant database queries
02Diagnosing why a specific API endpoint is experiencing high latency or timeouts
03Performing a comprehensive performance audit before a major product launch