PostgreSQL Rails Analyzer

Analyze Rails applications for PostgreSQL performance issues and provide actionable optimization recommendations based on "High Performance PostgreSQL for Rails" best practices.

Overview

This skill performs comprehensive analysis of Rails applications to identify:

• N+1 query problems and missing eager loading
• Missing or suboptimal indexes
• Database configuration issues
• Common anti-patterns
• Performance optimization opportunities

Analysis Scripts

Run these scripts from the Rails application root directory to analyze different aspects of the codebase:

1. N+1 Query Analysis