SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Ruby Database Tool Projects
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
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.
-
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.
-
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.
-
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.
-
Database Cleaner
Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.
-
-
-
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.
-
-
-
-
Seed Fu
Advanced seed data handling for Rails, combining the best practices of several methods together.
-
DatabaseConsistency
The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.
-
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.
-
-
Polo
Polo travels through your database and creates sample snapshots so you can work with real world data in development.
-
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).
-
Upsert
Upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates functions (UDF) for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE.
-
-
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).
-
-
Ruby Database Tools discussion
Ruby Database Tools related posts
-
🇧🇷 Glancer — Converse com seu banco de dados Rails em linguagem natural
-
The 5 PostgreSQL Migration Mistakes That Cause Production Outages
-
Catch unsafe Rails migrations in development
-
Show HN: AI Code Review Rules Directory
-
Production tests: a guidebook for better systems and more sleep
-
Deep Dive: Boosting Rails Performance with EXPLAIN ANALYZE in PostgreSQL
-
PgHero: A Performance Dashboard for Postgres
-
A note from our sponsor - SaaSHub
www.saashub.com | 13 Jun 2026
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 |