How does this skill detect N+1 queries?

It uses static analysis to scan controller actions and view files for association access patterns that lack eager loading methods like includes, preload, or eager_load.

Can it help with production-safe index additions?

Yes, it generates migration code using the 'algorithm: :concurrently' option to ensure database tables are not locked during production updates.

Does this require running the Rails application in a live environment?

No, the skill primarily uses static analysis of your source code and configuration files to identify potential issues without needing a running server.

What PostgreSQL configurations does it review?

It specifically audits your config/database.yml for connection pool sizing, statement timeouts, SSL settings, and recommended PostgreSQL extensions.

Is the analysis based on specific industry standards?

Yes, the recommendations are aligned with 'High Performance PostgreSQL for Rails' best practices for optimal query execution and schema design.

PostgreSQL Rails Analyzer

Name: PostgreSQL Rails Analyzer
Author: el-feo

byel-feo

0•

Database Management

Audits Ruby on Rails applications for PostgreSQL performance bottlenecks, N+1 queries, and missing database indexes.

This Claude Code skill provides an automated diagnostic toolset for Ruby on Rails developers using PostgreSQL. It leverages specialized static analysis scripts to detect common performance issues like N+1 queries, identifies missing foreign key or partial indexes, and reviews database configurations for optimal connection pooling and timeouts. By following industry best practices, it generates actionable recommendations and ready-to-run ActiveRecord migration code, making it an essential companion for performance audits and database optimization tasks.

Key Features

01Automated N+1 query detection across controllers and views

02Identification of missing foreign key and partial indexes

03Database configuration audits for connection pools and timeouts

04Generation of production-ready concurrent ActiveRecord migrations

05Categorized performance reporting based on issue severity

060 GitHub stars

Use Cases

01Performing a comprehensive database performance audit on an existing Rails app

02Optimizing slow database queries by identifying missing indexes or anti-patterns

03Reviewing database.yml configurations for security and scaling best practices

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add el-feo/ai-context postgresql-rails-analyzer

For use in Claude.ai and ChatGPT

Download Skill