postgresql-rails-analyzer

N+1 queries occur when your Rails code executes one query to fetch records, then additional queries for each record's associations. Use eager loading with `includes`, `preload`, or `joins` in your queries, and run the N+1 analysis script to identify patterns in controllers, views, and models that trigger this anti-pattern.

PostgreSQL performance audits in Rails applications reveal slow queries, N+1 patterns, missing indexes, suboptimal connection pooling, and configuration gaps in database.yml. This Skill analyzes migrations and schema to recommend concrete indexing improvements and configuration tuning to reduce connection overhead.

Missing indexes slow down queries by forcing full table scans. Inspect your schema and migration files to find columns frequently used in WHERE clauses, JOINs, or foreign keys that lack indexes. This Skill generates ready-to-use Rails migration code to add recommended indexes.

Yes. Review connection pooling, timeout settings, prepared statements, and SSL configuration in database.yml to reduce connection overhead and prevent runaway queries. The Skill evaluates these settings and recommends adjustments for your Rails environment.

Run a full audit from your Rails project root using the analysis scripts to detect N+1 queries, find missing indexes, and review database configuration. The Skill delivers actionable recommendations and generates migration code for schema improvements based on PostgreSQL best practices.

Yes. This Skill applies to Rails applications of any size that need performance audits, database tuning, and codebase reviews. It surfaces anti-patterns and provides concrete recommendations to optimize PostgreSQL queries and schema design.