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 | reddit.com/r/javahelp | 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: Rails application boilerplate for fast MVP development | dev.to | 2021-08-06

    ahoy, ahoy_email and blazer for business intelligence

  • 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 Scenic

    Versioned database views for Rails

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

    add scenic

  • GitHub repo Database Cleaner

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

    Project mention: Como configurar ambiente de testes em Ruby on Rails com RSpec | dev.to | 2021-04-21
  • GitHub repo strong_migrations

    Catch unsafe migrations in development

    Project mention: Database... or Goose? | reddit.com/r/ruby | 2021-06-28

    Nice one! Personally, I've been using https://github.com/ankane/strong_migrations to cover this case.

  • GitHub repo Large Hadron Migrator

    Online MySQL schema migrations

    Project mention: Database... or Goose? | reddit.com/r/ruby | 2021-06-28

    Is there anything similar for MySQL? There is https://github.com/soundcloud/lhm but it's pretty much outdated nowadays

  • 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 | dev.to | 2021-08-06

    lol_dba for indexing

  • Nanos

    Run Linux Software Faster and Safer than Linux with Unikernels.

  • 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. | reddit.com/r/rails | 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 | reddit.com/r/rails | 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 | dev.to | 2021-08-06

    add database_consistency

  • GitHub repo DatabaseValidations

    Database validations for ActiveRecord

    Project mention: Rails application boilerplate for fast MVP development | dev.to | 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 | dev.to | 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 Redis Dashboard

    Sinatra app to monitor Redis servers.

  • GitHub repo Ruby PG Extras

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

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-08-06.

Index

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

Project Stars
1 PgHero 6,063
2 Blazer 3,048
3 Scenic 2,794
4 Database Cleaner 2,730
5 strong_migrations 2,612
6 Large Hadron Migrator 1,719
7 Lol DBA 1,398
8 Seed dump 1,354
9 Foreigner 1,351
10 Squasher 1,274
11 Seed Fu 1,176
12 Seedbank 1,093
13 BatchLoader 874
14 Polo 703
15 SchemaPlus 691
16 Upsert 654
17 DatabaseConsistency 444
18 DatabaseValidations 328
19 Shiba 282
20 QueryTrack 261
21 SecondBase 216
22 Redis Dashboard 146
23 Ruby PG Extras 91
Find remote jobs at our new job board 99remotejobs.com. There are 25 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
www.saashub.com