Active Record Index Assistants

Utilities to point you at potentially missing database indices

A long-lived project that still receives updates
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.
No commit activity in last 3 years
There's a lot of open issues
A rake task to track down missing database indexes. does not assume that all foreign keys end with the convention of _id.
No commit activity in last 3 years
No release in over 3 years
Automatic Foreign Key automatically generates foreign-key constraints when creating tables or adding columns. It uses SQL-92 syntax and as such should be compatible with most databases that support foreign-key constraints.