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

Add another 'Database Tools' Gem