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

  2. SaaSHub

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

    SaaSHub logo
  3. Blazer

    Business intelligence made simple

    Project mention: 🇺🇸 Glancer — Ask your Rails database questions in plain language | dev.to | 2026-05-27

    It is inspired by Blazer, but instead of writing SQL yourself, you just ask.

  4. strong_migrations

    Catch unsafe migrations in development

    Project mention: Ruby on Rails Performance: 7 Lessons from Scaling FirstPromoter | dev.to | 2026-04-09

    Each integration has its own payload format, retry behavior, and edge cases. We keep an eye on all of it through AppSignal for performance monitoring, Better Stack for logs, Bullet/Prosopite for N+1 detection, and strong_migrations to keep deploys safe.

  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

    Project mention: Ruby on Rails Performance: 7 Lessons from Scaling FirstPromoter | dev.to | 2026-04-09

    We started with the Scenic gem to create PostgreSQL views for reporting queries that would otherwise require joining five or six tables every time. That worked until it didn't — the views got too complex and too slow as the data grew. We ended up moving the heavy ones to BigQuery, where the same join logic runs over millions of rows without breaking a sweat. The simpler views still live in PostgreSQL where they belong.

  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. Large Hadron Migrator

    Online MySQL schema migrations

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

  11. Squasher

    Squasher - squash your old migrations in a single command

  12. Seed dump

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

  13. Foreigner

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

  14. Seed Fu

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

  15. DatabaseConsistency

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

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

  17. BatchLoader

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

  18. Polo

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

  19. 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).

  20. Upsert

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

  21. DatabaseValidations

    Database validations for ActiveRecord

  22. 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).

  23. fast_page

    Blazing fast pagination for ActiveRecord with deferred joins ⚡️

  24. QueryTrack

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

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

Log in or Post with

Ruby Database Tools related posts

  • 🇧🇷 Glancer — Converse com seu banco de dados Rails em linguagem natural

    3 projects | dev.to | 27 May 2026
  • The 5 PostgreSQL Migration Mistakes That Cause Production Outages

    3 projects | dev.to | 2 Mar 2026
  • Catch unsafe Rails migrations in development

    1 project | news.ycombinator.com | 7 Oct 2025
  • Show HN: AI Code Review Rules Directory

    1 project | news.ycombinator.com | 9 Jun 2025
  • Production tests: a guidebook for better systems and more sleep

    1 project | news.ycombinator.com | 20 May 2025
  • Deep Dive: Boosting Rails Performance with EXPLAIN ANALYZE in PostgreSQL

    3 projects | dev.to | 11 May 2025
  • PgHero: A Performance Dashboard for Postgres

    1 project | news.ycombinator.com | 25 Sep 2024
  • A note from our sponsor - SaaSHub
    www.saashub.com | 13 Jun 2026
    SaaSHub helps you find the best software and product alternatives Learn more →

Index

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

# Project Stars
1 PgHero 8,878
2 Blazer 4,789
3 strong_migrations 4,408
4 Mongoid 3,917
5 Scenic 3,622
6 Database Cleaner 2,963
7 active_record_doctor 1,915
8 Large Hadron Migrator 1,851
9 Lol DBA 1,594
10 Squasher 1,537
11 Seed dump 1,414
12 Foreigner 1,316
13 Seed Fu 1,234
14 DatabaseConsistency 1,189
15 Seedbank 1,143
16 BatchLoader 1,120
17 Polo 789
18 online_migrations 738
19 Upsert 647
20 DatabaseValidations 563
21 auto_strip_attributes 363
22 fast_page 328
23 QueryTrack 304

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com

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