SqlQueryAnalyzer

Analyze your ActiveRecord queries easily with EXPLAIN and smart optimization suggestions. 🚀

✅ Supports Rails 6.0+ through Rails 7.1+

Add this line to your Gemfile:

gem 'sql_query_analyzer'

And then execute:

bundle install

Or install it manually:

gem install sql_query_analyzer

Need to create a new file in the config/initializers/sql_query_analyzer.rb

In your Rails console or app:

User.where(active: true).explain_with_suggestions

✅ You will get:

• Full EXPLAIN ANALYZE plan

• Smart suggestions like:

  • Missing JOIN conditions
  • Sorting without indexes
  • High row scan warnings

• Save time analyzing slow queries
• Instant smart hints
• Improve database performance faster
• Beginner-friendly explanations

=== EXPLAIN ANALYZE OUTPUT ===
Seq Scan on users ...

=== SUGGESTIONS ===
[CRITICAL] ⚡ Sequential Scan detected. Consider adding indexes.
[WARNING] 🚨 Query uses SELECT *. Select only needed columns.

Here is an example of the output response from the Gem:

The project maintains high test coverage to ensure reliability:

• Line Coverage: 99.4% (167/168 lines)
• Branch Coverage: 80.7% (46/57 branches)

Coverage is measured using SimpleCov and is checked on every pull request.

For a detailed roadmap, visit our GitHub Pages roadmap.