Skills
.Work. You
Rest

rails-query-analyzer

Community

Optimize your ActiveRecord queries

Software Engineering#code review#rails#query analysis#database performance#sql optimization#activerecord
Authorlekemula
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill helps developers identify and fix performance bottlenecks in their ActiveRecord database queries, leading to faster and more efficient applications.

Core Features & Use Cases

  • Performance Analysis: Reviews ActiveRecord queries for common performance anti-patterns.
  • Index Suggestions: Recommends and generates SQL for missing database indexes.
  • Query Rewrites: Provides optimized alternatives to inefficient query structures.
  • Use Case: A developer suspects a slow page load is due to inefficient database queries. They use this Skill to analyze the relevant code, get specific suggestions for optimization, and even generate the necessary migration files for new indexes.

Quick Start

Analyze the ActiveRecord queries in the file app/models/user.rb for performance issues.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: rails-query-analyzer
Download link: https://github.com/lekemula/dotfiles/archive/main.zip#rails-query-analyzer

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.