SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Ruby Database Projects
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
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.
-
Project mention: Ruby on Rails Performance: 7 Lessons from Scaling FirstPromoter | dev.to | 2026-04-09
Rails' built-in counter_cache got us started, but we graduated to counter_culture for conditional counts and multi-level caching.
-
-
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.
-
-
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.
-
ronin
Ronin is a Free and Open Source Ruby Toolkit for Security Research and Development. Ronin also allows for the rapid development and distribution of code, exploits, payloads, etc, via 3rd-party git repositories. (by ronin-rb)
-
-
-
-
evil-seed
A Gem for creating partial anonymized dumps of your database using your app model relations.
-
shapado
Free and open source Q&A software, open source stackoverflow style app written in ruby, rails, mongomapper and mongodb.
-
-
-
-
As an alternative to leaving this to an LLM I came across:
https://github.com/infused/dbf/
I'm not sure what the article suggests - create a custom rust program that reads and writes to a given dbf file? Create a rust program that mirrors the PRG code, writing/reading data in a custom format?
-
-
Ruby PG Extras
Ruby PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.
-
rails_lens
Comprehensive Rails application visualization and annotation tool - precision optics for the Rails universe
Project mention: Rails application visualization and annotation tool | news.ycombinator.com | 2025-10-05 -
Ruby Database discussion
Ruby Database related posts
-
Ruby on Rails Performance: 7 Lessons from Scaling FirstPromoter
-
Why TigerBeetle is the most interesting database in the world
-
A visual demo of Ruby's lazy enumerator
-
liquibase alternatives - Logidze and dolt
3 projects | 19 Nov 2024 -
SQLite on Rails: The how and why of optimal performance
-
Finding and optimizing N+1 queries on a relational database
-
A simple tool to observe PostgreSQL database locks in Rails apps
-
A note from our sponsor - SaaSHub
www.saashub.com | 12 Jul 2026
Index
What are some of the best open-source Database projects in Ruby? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | Backup | 4,867 |
| 2 | Scenic | 3,623 |
| 3 | counter_culture | 2,117 |
| 4 | active_record_doctor | 1,917 |
| 5 | Lol DBA | 1,594 |
| 6 | Squasher | 1,537 |
| 7 | DatabaseConsistency | 1,193 |
| 8 | SQL Server | 982 |
| 9 | Polo | 789 |
| 10 | ronin | 751 |
| 11 | pg-osc | 616 |
| 12 | TinyTDS | 614 |
| 13 | DatabaseValidations | 568 |
| 14 | evil-seed | 565 |
| 15 | shapado | 527 |
| 16 | postal-codes-json-xml-csv | 410 |
| 17 | airrecord | 320 |
| 18 | QueryTrack | 304 |
| 19 | dbf | 281 |
| 20 | relaxo | 180 |
| 21 | Ruby PG Extras | 171 |
| 22 | rails_lens | 105 |
| 23 | deviser-club | 97 |