active_record_doctor helps you to identify database issues before they hit production. Version 1.2.0 can index foreign keys lacking an index and detect extraneous indexes (e.g. ones that can be replaced by a multi-column index) and take unique constraints into account.