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. 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
  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: Show HN: AI Code Review Rules Directory | news.ycombinator.com | 2025-06-09

    Hey HN!

    We've been helping other companies build their AI code reviewers, and noticed that people ended up writing similar rules.

    So we built a directory for them! We've also compiled instructions for all the major code reviewers out there (Github Copilot, Coderabbit, Greptile, Diamond).

    The biggest thing we've done is port strong migrations (https://github.com/ankane/strong_migrations) to other languages and ORMs. If you've ever used ruby and miss strong migrations - well, you can have them now.

    We plan on keeping this up to date over time with more helpful rules.

    If you have any that you added to your code review process, please feel free to share and we can add it to the directory.

  5. Mongoid

    The Official Ruby Object Mapper for MongoDB

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

    Deploy and host your apps and databases, now with $50 credit! Sevalla is the PaaS you have been looking for! Advanced deployment pipelines, usage-based pricing, preview apps, templates, human support by developers, and much more!

    Sevalla 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. 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. DatabaseConsistency

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

  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

Log in or Post with

Ruby Database Tools related posts

  • 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
  • PgAssistant: OSS tool to help devs understand and optimize PG performance

    4 projects | news.ycombinator.com | 12 Feb 2025
  • PgHero: A Performance Dashboard for Postgres

    1 project | news.ycombinator.com | 25 Sep 2024
  • Kamal Proxy – A minimal HTTP proxy for zero-downtime deployments

    8 projects | news.ycombinator.com | 21 Sep 2024
  • A simple tool to observe PostgreSQL database locks in Rails apps

    1 project | news.ycombinator.com | 5 Sep 2024
  • A note from our sponsor - InfluxDB
    www.influxdata.com | 1 Sep 2025
    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. 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,572
2 Blazer 4,712
3 strong_migrations 4,257
4 Mongoid 3,919
5 Scenic 3,567
6 Database Cleaner 2,954
7 active_record_doctor 1,879
8 Large Hadron Migrator 1,852
9 Lol DBA 1,587
10 Squasher 1,524
11 Seed dump 1,391
12 Foreigner 1,322
13 Seed Fu 1,236
14 Seedbank 1,143
15 DatabaseConsistency 1,131
16 BatchLoader 1,077
17 Polo 771
18 online_migrations 699
19 Upsert 649
20 DatabaseValidations 546
21 auto_strip_attributes 363
22 fast_page 325
23 QueryTrack 302

Sponsored
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.
www.influxdata.com

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