schema_reaper scans a Rails + PostgreSQL app for schema debt that's easy to accumulate and hard to find by hand. It checks your live database against your codebase and flags three kinds of problems: things nothing references anymore (dead columns and dead tables), index trouble (indexes nobody queries, indexes made redundant by a wider index that already covers them, and foreign-key columns with no index at all), and degenerate data (columns that are always NULL, or hold the exact same value in every row). Every finding comes with a confidence score, an estimate of the disk space removing it would reclaim, and a concrete fix. For a column, that's a two-step migration: stop reading it first, then drop it once you've confirmed nothing broke. An optional runtime tracker can sample real production traffic to raise confidence further, for cases a static code scan alone can't settle. Reports come as a colored terminal summary, JSON, Markdown for a PR comment, or SARIF for GitHub code scanning -- plus a CI baseline gate and a trend log to track progress release over release. PostgreSQL only for now. Requires Ruby 2.7 or later. Full usage is in the README.
Required Ruby Version
>= 2.7.0
Authors
aksshatt, mitkush
Versions
-
2.1.0
-
source
- 2.1.0 source October 14, 2026 (93.5 KB)
-
-
2.0.1
-
source
- 2.0.1 source September 23, 2026 (68 KB)
-
-
2.0.0
-
source
- 2.0.0 source September 23, 2026 (60.5 KB)
-
-
1.0.16
-
source
- 1.0.16 source September 22, 2026 (52.5 KB)
-
-
1.0.15
-
source
- 1.0.15 source September 18, 2026 (51 KB)
-
Pushed by
