plentz/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. observed · 2026-08-28
Health v2 · maintenance only
65/100
- Activity 73
- Release rhythm 35
- Longevity 100
Flags: no_releases no_license
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 5300
- days_rel: n/a
- days_push: 163
- n_releases_24m: 0
Adoption not part of the score
1594 stars · 70 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
lol_dba is a Ruby gem providing rake tasks that scan Rails application models and report columns that probably should be indexed. It can also generate .sql migration scripts for applying those indexes.
Use cases
- find missing database indexes in a rails app
- generate sql migration scripts for indexes
- audit foreign key columns for indexing
- optimize slow queries caused by missing indexes
- review model associations for index coverage
When to choose
- you maintain a Ruby on Rails application and want to find missing indexes
- you need SQL migration files for index changes
- you want a lightweight rake-task-based database audit tool
When to avoid
- you are not using Ruby on Rails or ActiveRecord
- you need runtime query performance monitoring rather than static analysis
- you need automatic index creation without review
Facets
library · maturity active
database developer-tools databases web-development developer-tools ruby cli rails database-indexes migrations sql-generation rake-tasks gem
1 source
- readme: https://github.com/plentz/lol_dba · fetched 2026-08-28 · e8aae6798908
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| plentz/lol_dba | main | 65 |
For agents
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem