40 Database Tools gems and projects

  • PgHero

    9.5 7.2 L4 Ruby
    A performance dashboard for Postgres
  • Blazer

    8.9 7.2 Ruby
    Business intelligence made simple
  • Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
    Promo www.influxdata.com
    InfluxDB Logo
  • Scenic

    8.5 5.8 L5 Ruby
    Versioned database views for Rails
  • Database Cleaner

    8.5 0.0 L5 Ruby
    Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.
  • 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
  • Active Record Doctor

    6.7 6.6 Ruby
    Identify database issues before they hit production.
  • Lol DBA

    6.7 0.0 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.
  • Rails DB

    6.7 2.8 L5 JavaScript
    Rails Database Viewer and SQL Query Runner
  • Squasher

    6.5 4.9 Ruby
    Squasher - squash your old migrations in a single command
  • Seed Fu

    6.5 0.0 L5 Ruby
    Advanced seed data handling for Rails, combining the best practices of several methods together.
  • Foreigner

    6.5 0.0 L5 Ruby
    Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb
  • Seedbank

    6.2 3.2 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.9 5.7 Ruby
    :zap: Powerful tool for avoiding N+1 DB or HTTP queries
  • DatabaseConsistency

    5.7 7.5 Ruby
    The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.
  • Polo

    5.4 0.0 L5 Ruby
    Polo travels through your database and creates sample snapshots so you can work with real world data in development.
  • SchemaPlus

    5.3 0.0 L4 Ruby
    DISCONTINUED. SchemaPlus provides a collection of enhancements and extensions to ActiveRecord
  • DatabaseValidations

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

    4.5 9.1 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).
  • SecondBase

    4.2 0.0 L5 Ruby
    Seamless second database integration for Rails.
  • FastPage

    3.4 2.9 Ruby
    Blazing fast pagination for ActiveRecord with deferred joins ⚡️
  • QueryTrack

    3.3 4.4 Ruby
    Find time-consuming database queries for ActiveRecord-based Rails Apps
  • Shiba

    3.1 0.0 Ruby
    Catch bad SQL queries before they cause problems in production
  • Ruby Whatsapp SDK

    2.7 8.2 Ruby
    A lightweight, efficient Ruby gem for interacting with Whatsapp Cloud API.
  • Redis Dashboard

    2.5 3.6 CSS
    Sinatra app to monitor Redis servers.
  • Ruby PG Extras

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

    1.7 9.4 C
    Turn ruby files into .exe files on windows (supported safe fork of ocran)
  • Nullalign

    1.6 0.0 Ruby
    Finds missing non-null constraints
  • PgDriveBackup

    1.3 0.0 Ruby
    Simple solution to make encrypted with ccrypt PostgreSQL backups and storing on Google Drive API
  • Slack Smart Bot

    1.2 6.9 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.
  • Perfect Shape

    1.2 3.9 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.
  • ActiveRecord Setops

    1.0 0.0 Ruby
    Union, Intersect, and Difference set operations for ActiveRecord (also, SQL's UnionAll).
  • ActiveRecord::DataIntegrity

    0.8 0.0 Ruby
    Check data integrity for your ActiveRecord models
  • PgDice

    0.8 0.0 Ruby
    Postgres partitioning built on top of https://github.com/ankane/pgslice
  • Rapidity

    0.7 0.0 Ruby
    Simple but fast Redis-backed distributed rate limiter. Allows you to specify time interval and count within to limit distributed operations.
  • SlackHook

    0.6 0.0 Ruby
    A Simple Interface to Slack Incoming Webhooks Integrations
  • bundler-download

    0.6 3.2 Ruby
    Bundler plugin for auto-downloading specified extra files after gem install
  • Vimamsa

    0.3 8.8 Ruby
    Vimamsa - Vi/Vim -inspired experimental GUI-oriented text editor written with Ruby and GTK.

    0.3 8.8 Ruby
    A Pry plugin that captures exceptions that may arise from typos and deduces the correct command.

Add another 'Database Tools' Gem