Detect and eliminate N+1 queries in Ruby on Rails applications.
npx skills add https://github.com/sandeepmvl/rails-skills --skill n-plus-one-killer
Please help me install this Agent Skill. Skill: n-plus-one-killer Source: https://github.com/sandeepmvl/rails-skills/tree/main/skills/02-n-plus-one-killer Command: npx skills add https://github.com/sandeepmvl/rails-skills --skill n-plus-one-killer
This Skill solves the pervasive Rails performance issue of undetected N+1 queries, which AI coding agents frequently introduce when generating controller and view code, leading to excessive database load and slow endpoint response times.
includes/preload/eager_load, counter cache implementation for count N+1s, and denormalization guidance for complex query scenarios.pg_stat_statements, plus an EXPLAIN ANALYZE reference for deep SQL analysis./posts index that loads post authors and comment counts per row, the skill identifies both N+1s, adds the correct eager loading, recommends a counter cache for comment counts, and wires up Bullet to catch future regressions in test suites.Use the n-plus-one-killer skill to diagnose and fix the slow /posts endpoint that loads post authors and comment counts per row.
High-intent search queries and answers about installing and using this skill.
To fix Rails N+1 queries, this skill uses Bullet and Prosopite to detect unnecessary database loads, then applies eager loading with includes or preload to optimize slow endpoints.
Bullet provides association-aware N+1 detection in development and test environments, while Prosopite catches raw query pattern N+1s that Bullet misses. Combining both ensures comprehensive detection of slow query patterns in Rails applications.
Finding production-only N+1 queries requires analyzing query log tags, APM tools, and pg_stat_statements. This skill includes workflows for identifying these slow query patterns and using EXPLAIN ANALYZE for deep SQL analysis in production environments.
A counter cache should be used for count N+1s when you are repeatedly counting associations per row, such as comment counts on posts. This skill provides counter cache implementation patterns to replace inefficient count queries with cached columns.
Yes, this N+1 detection skill depends on the Bullet gem for association-aware detection in development and test environments, while also integrating Prosopite to catch raw query pattern N+1s that Bullet might miss.
The best way to eager load associations in Rails is using includes, preload, or eager_load depending on the query structure. This skill provides guidance on selecting the correct method and wiring up Bullet to catch future regressions.
ShoebtamboliReview ActiveRecord models and migrations for Rails conventions and best practices.
bobmatnycAnalyze PostgreSQL 15+ queries, indexes, and configuration using EXPLAIN ANALYZE.
fabnDiagnose Ruby on Rails performance bottlenecks via code, log, and schema analysis.
LaunchPadLabDetect and fix Rails runtime performance issues like N+1 queries and slow SQL.