Active Record Doctor

Scans for over 15 specific problems like extraneous indexes, missing foreign keys, and schema-validation mismatches, covering a wide range of database health concerns as detailed in the README.

Installs easily via Gemfile and uses familiar Rake tasks, fitting naturally into Rails development workflows without disrupting existing processes.

Allows ignoring specific tables, models, or indexes using strings or regexps, enabling teams to tailor checks to their project's needs, as shown in the configuration examples.

Returns a non-zero exit status when issues are detected, making it straightforward to integrate into continuous integration systems for automated checks.