Database Tools gems

Showing projects tagged as Database Tools

  • PgHero

    9.4 6.2 L4 Ruby
    A performance dashboard for Postgres
  • Blazer

    8.7 8.9 Ruby
    Business intelligence made simple
  • Database Cleaner

    8.5 2.8 L5 Ruby
    Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.
  • Scenic

    8.2 5.6 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 2.0 L5 JavaScript
    Rails Database Viewer and SQL Query Runner
  • Lol DBA

    6.5 4.4 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.
  • Foreigner

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

    6.4 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
  • Active Record Doctor

    6.1 7.4 Ruby
    Identify database issues before they hit production.
  • 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.
  • ActiveRecordExtended

    5.7 3.7 Ruby
    Adds additional postgres functionality to an ActiveRecord / Rails application
  • BatchLoader

    5.6 0.0 Ruby
    :zap: Powerful tool for avoiding N+1 DB or HTTP queries
  • Polo

    5.3 3.7 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
    SchemaPlus provides a collection of enhancements and extensions to ActiveRecord
  • Avo

    5.3 9.4 Ruby
    Configuration-based, no-maintenance, extendable Ruby on Rails admin
  • 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.
  • DatabaseValidations

    4.9 3.0 Ruby
    Database validations for ActiveRecord
  • DatabaseConsistency

    4.5 6.0 Ruby
    The tool to find inconsistency between models schema and database constraints.
  • SecondBase

    4.1 0.7 L5 Ruby
    Seamless second database integration for Rails.
  • Hightop

    3.9 3.3 Ruby
    A nice shortcut for group count queries
  • Forest Admin

    3.9 7.4 Ruby
    💎 Ruby on Rails agent for Forest Admin to integrate directly to your existing Ruby on Rails backend application.
  • OnlineMigrations

    3.4 8.9 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).
  • Shiba

    3.0 0.0 Ruby
    Catch bad SQL queries before they cause problems in production
  • QueryTrack

    3.0 5.0 Ruby
    Find time-consuming database queries for ActiveRecord-based Rails Apps
  • Redis Dashboard

    2.4 4.7 CSS
    Sinatra app to monitor Redis servers.
  • Ruby PG Extras

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

    1.5 0.0 Ruby
    Finds missing non-null constraints