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

Database Management

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

About

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

Automated N+1 query detection across controllers and views
Identification of missing foreign key and partial indexes
Database configuration audits for connection pools and timeouts
Generation of production-ready concurrent ActiveRecord migrations
Categorized performance reporting based on issue severity
0 GitHub stars

Use Cases

Performing a comprehensive database performance audit on an existing Rails app
Optimizing slow database queries by identifying missing indexes or anti-patterns
Reviewing database.yml configurations for security and scaling best practices

About

Key Features

Automated N+1 query detection across controllers and views
Identification of missing foreign key and partial indexes
Database configuration audits for connection pools and timeouts
Generation of production-ready concurrent ActiveRecord migrations
Categorized performance reporting based on issue severity
0 GitHub stars

Use Cases

Performing a comprehensive database performance audit on an existing Rails app
Optimizing slow database queries by identifying missing indexes or anti-patterns
Reviewing database.yml configurations for security and scaling best practices