spine-perf

Detect backend endpoint bottlenecks like N+1 queries and missing indexes.

69|8|Updated Mar 16, 2026
One-click install
npx skills add https://github.com/tonone-ai/tonone --skill spine-perf
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: spine-perf
Source: https://github.com/tonone-ai/tonone/tree/main/team/spine/skills/spine-perf
Command: npx skills add https://github.com/tonone-ai/tonone --skill spine-perf

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Find and fix backend performance bottlenecks such as N+1 queries, missing indexes, sync bottlenecks, and caching gaps, to reduce latency across services.

Core Features & Use Cases

  • Detect and diagnose N+1 queries and missing indexes
  • Identify synchronous bottlenecks and caching gaps
  • Provide actionable fixes and performance improvements
  • Use cases: when asked "why is this slow", "performance issue", "optimize this endpoint"

Quick Start

Run a performance audit on the target endpoint to surface bottlenecks and recommended fixes.

Frequently Asked Questions about spine-perf

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I identify N+1 queries and missing indexes causing backend performance bottlenecks?

To identify N+1 queries and missing indexes causing backend performance bottlenecks, you run an endpoint audit that traces data fetching patterns and surfaces root causes. The analysis pinpoints inefficient query loops and missing database indexes, delivering concrete fixes with measurable latency impact.

Can I optimize a slow FastAPI or Django endpoint that uses SQLAlchemy?

Yes, you can optimize a slow FastAPI or Django endpoint using SQLAlchemy by running a performance audit tailored to typical backend stacks. It detects synchronous bottlenecks and caching gaps, providing actionable fixes and validation steps to reduce service latency.

What is the best way to fix synchronous bottlenecks and caching gaps in an Express backend?

The best way to fix synchronous bottlenecks and caching gaps in an Express backend is to run an end-to-end performance analysis. It identifies blocking operations and missing cache layers, then recommends specific optimizations with example implementations to reduce latency.

Does this performance analysis tool work with Rails and ActiveRecord?

Yes, this performance analysis tool works with Rails and ActiveRecord. It supports typical backend stacks to detect N+1 queries, missing indexes, and caching gaps, producing actionable fixes and validation steps to improve endpoint response times.

Why is my backend endpoint slow and how do I diagnose the root cause?

Your backend endpoint is slow due to root causes like N+1 queries, missing indexes, synchronous bottlenecks, or caching gaps. Diagnose the root cause by running a performance audit that surfaces these issues and provides recommended changes with example optimizations.

How do I validate backend performance improvements after fixing query and caching issues?

You validate backend performance improvements after fixing query and caching issues by following the provided validation steps. The analysis delivers an end-to-end audit that includes recommended changes, validation procedures, and example optimizations to ensure measurable latency reduction.