Ruby Database Tools

Open-source Ruby projects categorized as Database Tools

Top 23 Ruby Database Tool Projects

  • GitHub repo Blazer

    Business intelligence made simple

    Project mention: The Ruby Unbundled Series: Track How Customers Use New Features | dev.to | 2021-03-24

    Ahoy is used to track visits to your site and specific user events that you define. Blazer allows you to easily query and view the metrics data. In fact, blazer can be used to query any data in your database, and it has some nice built-in visualization capabilities for metrics as well.

  • GitHub repo Database Cleaner

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

  • GitHub repo Scenic

    Versioned database views for Rails

    Project mention: Logidze 1.0, postgres-specific alternative to eg paper_trail for recording ActiveRecord change history | reddit.com/r/ruby | 2021-01-27

    TIL about fx gem for storing triggers in schema.rb. That makes me so happy because scenic gem for creating database views is one of my favorites. Postgres is very powerful and it's great to see tools for exposing that through Rails.

  • GitHub repo Large Hadron Migrator

    Online MySQL schema migrations

    Project mention: Do you use migrations for data manipulations? What are the pro's and con's ? | reddit.com/r/rails | 2021-02-17

    I may do it from the console or a task if I wanted to modify a large number of records, e.g. something in my Users table. I think you need a sense of how long the update will take - I'm not sure if there's any issue with migrations timing out or such like. If I modify my Users schema it takes 5 minutes or so as it has to make a copy of the table and swap it in and that works fine - https://github.com/soundcloud/lhm

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

  • GitHub repo Foreigner

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

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

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

  • GitHub repo Shiba

    Catch bad SQL queries before they cause problems in production

  • GitHub repo DatabaseValidations

    Database validations for ActiveRecord

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

  • GitHub repo Nullalign

    Finds missing non-null constraints

  • GitHub repo PgDriveBackup

    Simple solution to make encrypted with ccrypt PostgreSQL backups and storing on Google Drive API

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-03-24.

Index

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

Project Stars
1 Blazer 2,908
2 Database Cleaner 2,694
3 Scenic 2,669
4 Large Hadron Migrator 1,704
5 Lol DBA 1,364
6 Foreigner 1,348
7 Seed dump 1,343
8 Squasher 1,264
9 Seed Fu 1,166
10 Seedbank 1,080
11 BatchLoader 818
12 Polo 699
13 SchemaPlus 691
14 Upsert 649
15 DatabaseConsistency 422
16 Shiba 278
17 DatabaseValidations 275
18 QueryTrack 257
19 SecondBase 216
20 Redis Dashboard 141
21 Ruby PG Extras 74
22 Nullalign 52
23 PgDriveBackup 28