Ruby Database Tools

Open-source Ruby projects categorized as Database Tools | Edit details

Top 23 Ruby Database Tool Projects

  • GitHub repo PgHero

    A performance dashboard for Postgres

    Project mention: PostgreSQL for Java Developer | | 2021-04-01

    I know others can answer this better but we use a combination of PgHero and logging of slow queries trough jOOQ.

  • GitHub repo Blazer

    Business intelligence made simple

    Project mention: Keeping the Stakes Low while Breaking Production | | 2021-11-29

    We then pasted that into Blazer and started looking at the SQL. As we moved around the massive SQL statement, we saw the culprit. A very narrow range for allowed article’s publication dates.

  • Nanos

    Run Linux Software Faster and Safer than Linux with Unikernels.

  • GitHub repo Scenic

    Versioned database views for Rails

    Project mention: Frameworks for SQL Development in Rails? | | 2021-10-05

    I use the scenic gem to manage views which uses raw sql files:

  • GitHub repo Database Cleaner

    Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.

    Project mention: How a big application is usually tested regarding to its database data persistence? Also, tip on starting tests on existing codebase. | | 2021-09-30

    i'll introduce the gem

  • GitHub repo strong_migrations

    Catch unsafe migrations in development

    Project mention: Tutorial/example for zero downtime deploys for rails apps hosted on digital ocean? | | 2021-10-07

    Database migrations: you should use strong_migrations to catch unsafe migrations that will lock your database.

  • GitHub repo Large Hadron Migrator

    Online MySQL schema migrations

    Project mention: GitHub downtime root cause analysis | | 2021-12-03

    No you didn't. They're doing what is often referred as "online schema change" using (but the concept is the same than percona's pt-online-schema-change, or

  • GitHub repo 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.

    Project mention: Rails application boilerplate for fast MVP development | | 2021-08-06

    lol_dba for indexing

  • Scout APM

    Scout APM: A developer's best friend. Try free for 14-days. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.

  • GitHub repo Seed dump

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

    Project mention: Quick question about the local PostgreSQL database when you deploy your app to production. | | 2021-01-06
  • GitHub repo Foreigner

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

  • GitHub repo Squasher

    Squasher - squash your old migrations in a single command

  • GitHub repo Seed Fu

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

  • GitHub repo 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.

  • GitHub repo BatchLoader

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

  • GitHub repo Polo

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

    Project mention: Creating seed data from an existing DB | | 2021-07-14
  • GitHub repo SchemaPlus

    SchemaPlus provides a collection of enhancements and extensions to ActiveRecord

  • GitHub repo Upsert

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

  • GitHub repo DatabaseConsistency

    The tool to find inconsistency between models schema and database constraints.

    Project mention: Rails application boilerplate for fast MVP development | | 2021-08-06

    add database_consistency

  • GitHub repo DatabaseValidations

    Database validations for ActiveRecord

    Project mention: Rails application boilerplate for fast MVP development | | 2021-08-06

    add database_validations

  • GitHub repo Shiba

    Catch bad SQL queries before they cause problems in production

  • GitHub repo QueryTrack

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

    Project mention: Tracking long queries into csv | | 2020-12-27

    I found query_tracker gem which displays all the info I needed. It also allows slack integration. In my case, I wanted it to store query informations into CSV. Fortunately the gem allows custom handlers.

  • GitHub repo SecondBase

    Seamless second database integration for Rails.

  • GitHub repo Ruby PG Extras

    Ruby PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

  • GitHub repo Nullalign

    Finds missing non-null constraints

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). The latest post mention was on 2021-12-03.

Ruby Database Tools related posts


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

Project Stars
1 PgHero 6,148
2 Blazer 3,092
3 Scenic 2,839
4 Database Cleaner 2,744
5 strong_migrations 2,688
6 Large Hadron Migrator 1,729
7 Lol DBA 1,402
8 Seed dump 1,361
9 Foreigner 1,350
10 Squasher 1,282
11 Seed Fu 1,185
12 Seedbank 1,098
13 BatchLoader 889
14 Polo 708
15 SchemaPlus 693
16 Upsert 655
17 DatabaseConsistency 467
18 DatabaseValidations 345
19 Shiba 286
20 QueryTrack 262
21 SecondBase 215
22 Ruby PG Extras 91
23 Nullalign 53
Find remote jobs at our new job board There are 32 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives