Ruby Database Tools

30 Database Tools gems and projects

• PgHero

  9.3 6.1 L4 Ruby

  A performance dashboard for Postgres

• Blazer

  8.5 7.7 Ruby

  Business intelligence made simple

Run Linux Software Faster and Safer than Linux with Unikernels

Promo github.com/nanovms



• Database Cleaner

  8.4 4.8 L5 Ruby

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

• Scenic

  8.1 0.8 L5 Ruby

  Versioned database views for Rails
  

• Large Hadron Migrator

  7.7 0.0 L5 Ruby

  Online MySQL schema migrations
  

• Seed dump

  6.9 0.0 L5 Ruby

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

• Rails DB

  6.6 5.6 L5 JavaScript

  Rails Database Viewer and SQL Query Runner

• Foreigner

  6.5 0.0 L5 Ruby

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

• Lol DBA

  6.4 0.8 L5 Ruby

  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.

• Seed Fu

  6.3 0.0 L5 Ruby

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

• Squasher

  6.2 0.0 Ruby

  Squasher - squash your old migrations in a single command

• Seedbank

  6.1 0.0 L5 Ruby

  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.

• BatchLoader

  5.5 2.7 Ruby

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

• SchemaPlus

  5.4 0.0 L4 Ruby

  SchemaPlus provides a collection of enhancements and extensions to ActiveRecord
  

• Polo

  5.2 1.7 L5 Ruby

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

• Upsert

  5.1 4.2 L5 Ruby

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

• DatabaseValidations

  4.5 4.1 Ruby

  Database validations for ActiveRecord
  

• SecondBase

  4.0 2.2 L5 Ruby

  Seamless second database integration for Rails.
  

• DatabaseConsistency

  3.9 4.4 Ruby

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

• QueryTrack

  2.9 0.0 Ruby

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

• Shiba

  2.9 0.0 Ruby

  Catch bad SQL queries before they cause problems in production
  

• Redis Dashboard

  2.2 1.9 Ruby

  Sinatra app to monitor Redis servers.
  

• Ruby PG Extras

  1.7 5.4 Ruby

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

• Nullalign

  1.4 0.0 Ruby

  Finds missing non-null constraints

• PgDriveBackup

  1.1 0.0 Ruby

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

• ActiveRecord Setops

  0.8 2.2 Ruby

  Union, Intersect, and Difference set operations for ActiveRecord (also, SQL's UnionAll).

• PgDice

  0.8 0.0 Ruby

  Postgres partitioning built on top of https://github.com/ankane/pgslice
  

• ActiveRecord::DataIntegrity

  0.5 0.0 Ruby

  Check data integrity for your ActiveRecord models

• SlackHook

  0.4 0.0 Ruby

  A Simple Interface to Slack Incoming Webhooks Integrations

• bundler-download

  0.2 0.0 Ruby

  Bundler plugin for auto-downloading specified extra files after gem install

* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest.

Scout APM: A developer's best friend. Try free for 14-days sponsored scoutapm.com

Popular Comparisons

• Seedbank
  vs
  Seed Fu
• Seed dump
  vs
  Seed Fu
• PgHero
  vs
  Database Cleaner
• Rails DB
  vs
  SecondBase
• Blazer
  vs
  Rails DB

SaaSHub - Software Alternatives and Reviews sponsored www.saashub.com