Ruby Database Tools

Open-source Ruby projects categorized as Database Tools

Top 23 Ruby Database Tool Projects

Database Tools
  1. PgHero

    A performance dashboard for Postgres

    Project mention: Deep Dive: Boosting Rails Performance with EXPLAIN ANALYZE in PostgreSQL | dev.to | 2025-05-11

    Use PgHero or Rails Mini Profiler for real-time SQL analysis

  2. Stream

    Stream - Scalable APIs for Chat, Feeds, Moderation, & Video. Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.

    Stream logo
  3. Blazer

    Business intelligence made simple

    Project mention: Production tests: a guidebook for better systems and more sleep | news.ycombinator.com | 2025-05-20

    The fabulous blazer gem includes a feature for #2: https://github.com/ankane/blazer?tab=readme-ov-file#checks - it’s limited to checks that can be expressed as SQL queries, but that can get you quite a way

  4. strong_migrations

    Catch unsafe migrations in development

    Project mention: Catch unsafe Rails migrations in development | news.ycombinator.com | 2025-10-07
  5. Mongoid

    The Official Ruby Object Mapper for MongoDB

    Project mention: Guide to Seamless Data Security in Rails With Mongoid’s Automatic Encryption | dev.to | 2025-11-05

    One of Rails' doctrinal pillars puts programmer happiness on a pedestal. Convention over configuration, human-readable code, and smart defaults make the Rails Way feel almost intuitive. With the release of Mongoid 9.0, that same philosophy now extends to data encryption. Tasks that once required multi-step configurations can now be completed through a single model declaration. MongoDB’s Client-Side Field-Level Encryption (CSFLE) can now be seamlessly integrated into your applications, enhancing your data security with the ease and simplicity developers expect from Rails.

  6. Scenic

    Versioned database views for Rails

  7. Database Cleaner

    Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.

  8. active_record_doctor

    Identify database issues before they hit production.

  9. InfluxDB

    InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

    InfluxDB logo
  10. Large Hadron Migrator

    Online MySQL schema migrations

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

  12. Squasher

    Squasher - squash your old migrations in a single command

  13. Seed dump

    Rails task to dump your data to db/seeds.rb

  14. Foreigner

    Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb

  15. Seed Fu

    Advanced seed data handling for Rails, combining the best practices of several methods together.

  16. DatabaseConsistency

    The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.

  17. Seedbank

    Seedbank gives your seed data a little structure. Create seeds for each environment, share seeds between environments and specify dependencies to load your seeds in order. All nicely integrated with simple rake tasks.

  18. BatchLoader

    :zap: Powerful tool for avoiding N+1 DB or HTTP queries

  19. Polo

    Polo travels through your database and creates sample snapshots so you can work with real world data in development.

  20. online_migrations

    Catch unsafe PostgreSQL migrations in development and run them easier in production (code helpers for table/column renaming, changing column type, adding columns with default, background migrations, etc).

  21. Upsert

    Upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates functions (UDF) for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE.

  22. DatabaseValidations

    Database validations for ActiveRecord

  23. auto_strip_attributes

    AutoStripAttributes gem for Rails helps to remove unnecessary whitespaces from ActiveRecord or ActiveModel attributes. It's good for removing accidental spaces from user inputs (e.g. when user copy/pastes some value to a form and the value has extra spaces at the end).

  24. fast_page

    Blazing fast pagination for ActiveRecord with deferred joins ⚡️

  25. QueryTrack

    Find time-consuming database queries for ActiveRecord-based Rails Apps

  26. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Ruby Database Tools discussion

Ruby Database Tools related posts

Index

What are some of the best open-source Database Tool projects in Ruby? This list will help you:

# Project Stars
1 PgHero 8,732
2 Blazer 4,757
3 strong_migrations 4,328
4 Mongoid 3,926
5 Scenic 3,595
6 Database Cleaner 2,961
7 active_record_doctor 1,901
8 Large Hadron Migrator 1,855
9 Lol DBA 1,599
10 Squasher 1,532
11 Seed dump 1,405
12 Foreigner 1,321
13 Seed Fu 1,236
14 DatabaseConsistency 1,153
15 Seedbank 1,143
16 BatchLoader 1,098
17 Polo 778
18 online_migrations 708
19 Upsert 649
20 DatabaseValidations 561
21 auto_strip_attributes 365
22 fast_page 328
23 QueryTrack 304

Sponsored
Stream - Scalable APIs for Chat, Feeds, Moderation, & Video.
Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.
getstream.io

Did you know that Ruby is
the 12th most popular programming language
based on number of references?