Libraries & frameworks
lol_dba
plentz/lol_dba
lol_dba is a Ruby gem for Rails applications. Its rake tasks scan models and associations, report columns that likely need indexes, and generate SQL migration scripts for the missing indexes.
Topics
Related projects
scenic3.6kScenic adds versioned database-view support to Rails migrations, letting you define SQL views in files and generate reversible, schema-tracked migrations.
counter_culture2.1kCounter_culture is a Rails gem that supercharges counter caches. It keeps denormalized counts accurate across nested associations, supports dynamic columns and running totals, and can repair drifted counters.
upscheme2.7kUpscheme is a PHP package for defining and upgrading database schemas. It provides a concise migration API with dependency ordering and support for MySQL, PostgreSQL, SQLite, and SQL Server.
active_record_doctor1.9kActive Record Doctor is a Rails gem that audits database health. It detects missing indexes, foreign keys and constraints, unused tables and model mismatches, then helps generate corrective migrations.
database_consistency1.2kDatabaseConsistency is a Ruby gem for Rails/ActiveRecord that detects mismatches and inefficiencies between the database schema and model validations, indexes, and foreign keys.
activerecord-sqlserver-adapter980This adapter connects Rails ActiveRecord to Microsoft SQL Server, supporting native types, migrations, stored procedures, bulk upserts, and query plan inspection.