Ruby Database Tools

36 Database Tools gems and projects

• PgHero

  9.4 3.7 L4 Ruby

  A performance dashboard for Postgres

• Blazer

  8.7 7.0 Ruby

  Business intelligence made simple

Access the most powerful time series database as a service

Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

Promo www.influxdata.com



• Database Cleaner

  8.5 0.0 L5 Ruby

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

• Scenic

  8.3 6.9 L5 Ruby

  Versioned database views for Rails
  

• Large Hadron Migrator

  7.8 0.0 L5 Ruby

  Online MySQL schema migrations
  

• Seed dump

  7.0 0.0 L5 Ruby

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

• Rails DB

  6.6 1.7 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.5 2.2 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.

• Squasher

  6.4 0.0 Ruby

  Squasher - squash your old migrations in a single command

• Seed Fu

  6.4 0.0 L5 Ruby

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

• Active Record Doctor

  6.3 6.1 Ruby

  Identify database issues before they hit production.

• Seedbank

  6.2 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.7 0.0 Ruby

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

• SchemaPlus

  5.3 0.0 L4 Ruby

  SchemaPlus provides a collection of enhancements and extensions to ActiveRecord
  

• Polo

  5.3 0.0 L5 Ruby

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

• DatabaseValidations

  5.1 0.0 Ruby

  Database validations for ActiveRecord
  

• Upsert

  5.1 0.0 L5 Ruby

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

• DatabaseConsistency

  5.1 0.0 Ruby

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

• SecondBase

  4.2 0.0 L5 Ruby

  Seamless second database integration for Rails.
  

• OnlineMigrations

  3.8 5.7 Ruby

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

• QueryTrack

  3.2 4.6 Ruby

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

• FastPage

  3.0 8.2 Ruby

  Blazing fast pagination for ActiveRecord with deferred joins ⚡️
  

• Shiba

  3.0 0.0 Ruby

  Catch bad SQL queries before they cause problems in production
  

• Redis Dashboard

  2.4 0.0 CSS

  Sinatra app to monitor Redis servers.
  

• Ruby PG Extras

  2.2 0.0 Ruby

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

• Ruby Whatsapp SDK

  1.6 8.7 Ruby

  Use the Ruby Whatsapp SDK to communicate with Whatsapp API using the Cloud API. Create bots to send and receive messages using the Whatsapp SDK in a few minutes.

• Nullalign

  1.5 0.0 Ruby

  Finds missing non-null constraints

• PgDriveBackup

  1.2 0.0 Ruby

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

• Slack Smart Bot

  1.0 10.0 Ruby

  Create a Slack bot that is smart and so easy to expand, create new bots on demand, run ruby code on chat, create shortcuts... The main scope of this gem is to be used internally in the company so teams can create team channels with their own bot to help them on their daily work, almost everything is suitable to be automated!! slack-smart-bot can create bots on demand, create shortcuts, run ruby code... just on a chat channel. You can access it just from your mobile phone if you want and run those tests you forgot to run, get the results, restart a server... no limits.

• ActiveRecord Setops

  1.0 0.0 Ruby

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

• Perfect Shape

  1.0 4.0 Ruby

  Perfect Shape is a collection of geometric algorithms that are mostly useful for GUI manipulation like checking containment of a point in popular geometric shapes such as rectangle, square, arc, circle, polygon, and paths containing lines, quadratic bézier curves, and cubic bezier curves. Also, some general math algorithms like IEEE-754 Remainder.

• PgDice

  0.8 0.0 Ruby

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

• ActiveRecord::DataIntegrity

  0.7 0.0 Ruby

  Check data integrity for your ActiveRecord models

• bundler-download

  0.4 0.0 Ruby

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

• SlackHook

  0.4 0.0 Ruby

  A Simple Interface to Slack Incoming Webhooks Integrations

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

Clean code begins in your IDE with SonarLint sponsored www.sonarlint.org

Popular Comparisons

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

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