# 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.

Repository: https://github.com/plentz/lol_dba
Canonical: https://ross.abutalabs.com/products/lol_dba
Language: Ruby
License Family: other
Topics: rails, database, migrations, sql, ruby, ruby-on-rails, gem, database-migrations
Last push: 2026-03-23T18:59:18+00:00

## Health v2 (maintenance only)
Score: 65/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 73, release rhythm 35, longevity 100
- inputs: {"age_days": 5300, "days_push": 163, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1594, forks 70 (observed 2026-08-28T04:05:08.985952+00:00)

## What it is
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
- artifact type: library
- maturity: active
- function: database, developer-tools
- domain: databases, web-development, developer-tools
- platform: ruby, cli
- tags: rails, database-indexes, migrations, sql-generation, rake-tasks, gem

## Member repositories
- plentz/lol_dba (main) score 65

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:08.985952+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:54:13.014758+00:00, confidence not recorded.
  - readme: https://github.com/plentz/lol_dba (fetched 2026-08-28T04:05:08.985952+00:00, sha e8aae6798908)
- Data as of 2026-08-30T08:39:29.467469+00:00.