Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR. Learn more →
Top 23 Ruby Database Tool Projects
-
Project mention: PgAssistant: OSS tool to help devs understand and optimize PG performance | news.ycombinator.com | 2025-02-12
-
CodeRabbit
CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
-
-
Project mention: Kamal Proxy – A minimal HTTP proxy for zero-downtime deployments | news.ycombinator.com | 2024-09-21
Strong migrations helps writing migrations that are safe for ZDD deploys. We use it in our rails app, catches quite a few potential footguns. https://github.com/ankane/strong_migrations
-
-
1) First, let's install the Scenic gem. It's not required, but it gives us nice ways to create and manage views.
-
Database Cleaner
Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
-
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.
-
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.
-
DatabaseConsistency
The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.
-
-
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).
I ran across the excellent "auto_strip_attributes" gem years ago, and it's been a staple gem that gets added to my Gemfile right off the bat when making a new project. I even have a standard initializer that adds some extra functionality to it:
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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
-
PgAssistant: OSS tool to help devs understand and optimize PG performance
-
PgHero: A Performance Dashboard for Postgres
-
Kamal Proxy – A minimal HTTP proxy for zero-downtime deployments
-
A simple tool to observe PostgreSQL database locks in Rails apps
-
Query multiple tables easily with Rails and Postgres Views
-
How to Get the Most Out of Postgres Memory Settings
-
Strong_migrations: Catch Unsafe Migrations in Development
-
A note from our sponsor - CodeRabbit
coderabbit.ai | 19 Mar 2025
Index
What are some of the best open-source Database Tool projects in Ruby? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | PgHero | 8,368 |
| 2 | Blazer | 4,631 |
| 3 | strong_migrations | 4,163 |
| 4 | Mongoid | 3,913 |
| 5 | Scenic | 3,492 |
| 6 | Database Cleaner | 2,942 |
| 7 | Large Hadron Migrator | 1,840 |
| 8 | active_record_doctor | 1,824 |
| 9 | Lol DBA | 1,584 |
| 10 | Squasher | 1,511 |
| 11 | Seed dump | 1,385 |
| 12 | Foreigner | 1,323 |
| 13 | Seed Fu | 1,233 |
| 14 | Seedbank | 1,144 |
| 15 | DatabaseConsistency | 1,099 |
| 16 | BatchLoader | 1,064 |
| 17 | Polo | 777 |
| 18 | online_migrations | 663 |
| 19 | Upsert | 650 |
| 20 | DatabaseValidations | 544 |
| 21 | auto_strip_attributes | 362 |
| 22 | fast_page | 311 |
| 23 | QueryTrack | 301 |
Sponsored
CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai