lol_dba

lol_dba is a small package of rake tasks that scan your application models and displays a list of columns that probably should be indexed. Also, it can generate.sql migration scripts. Maintained by plentz on GitHub, where it has earned 1,594 stars from the community.

It's actively developed around database, database-migrations, gem, and is a solid reference for anyone building with these tools.