Database Tools gems

Showing projects tagged as Database Tools

  • PgHero

    9.4 3.7 L4 Ruby
    A performance dashboard for Postgres
  • Blazer

    8.7 7.4 Ruby
    Business intelligence made simple
  • 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.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.5 3.1 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.
  • Avo

    6.2 9.2 Ruby
    Build Ruby on Rails apps 10x faster
  • ActiveRecordExtended

    6.0 7.8 Ruby
    Adds additional postgres functionality to an ActiveRecord / Rails application
  • BatchLoader

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

    5.3 0.0 L4 Ruby
    SchemaPlus provides a collection of enhancements and extensions to ActiveRecord
  • DatabaseConsistency

    5.1 0.0 Ruby
    The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.
  • 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

    5.1 0.0 Ruby
    Database validations for ActiveRecord
  • SecondBase

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

    4.1 6.2 Ruby
    💎 Ruby on Rails agent for Forest Admin to integrate directly to your existing Ruby on Rails backend application.
  • Hightop

    3.9 2.5 Ruby
    A nice shortcut for group count queries
  • OnlineMigrations

    3.8 6.6 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
  • Shiba

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

    3.0 8.1 Ruby
    Blazing fast pagination for ActiveRecord with deferred joins ⚡️
  • 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.