33 Database Tools gems and projects

  • PgHero

    9.4 6.4 L4 Ruby
    A performance dashboard for Postgres
  • Blazer

    8.6 9.1 Ruby
    Business intelligence made simple
  • Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
  • Database Cleaner

    8.4 3.2 L5 Ruby
    Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.
  • DatabaseConsistency

    4.4 6.6 Ruby
    The tool to find inconsistency between models schema and database constraints.
  • bundler-download

    0.2 0.0 Ruby
    Bundler plugin for auto-downloading specified extra files after gem install
  • Ruby PG Extras

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

    8.2 5.4 L5 Ruby
    Versioned database views for Rails
  • DatabaseValidations

    4.9 3.7 Ruby
    Database validations for ActiveRecord
  • QueryTrack

    3.0 3.8 Ruby
    Find time-consuming database queries for ActiveRecord-based Rails Apps
  • Lol DBA

    6.4 4.6 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.
  • BatchLoader

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

    0.8 5.1 Ruby
    Postgres partitioning built on top of https://github.com/ankane/pgslice
  • Rails DB

    6.6 2.9 L5 JavaScript
    Rails Database Viewer and SQL Query Runner
  • Redis Dashboard

    2.3 5.7 CSS
    Sinatra app to monitor Redis servers.
  • Polo

    5.3 3.8 L5 Ruby
    Polo travels through your database and creates sample snapshots so you can work with real world data in development.
  • SlackHook

    0.4 0.0 Ruby
    A Simple Interface to Slack Incoming Webhooks Integrations
  • 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.
  • Nullalign

    1.5 0.0 Ruby
    Finds missing non-null constraints
  • ActiveRecord::DataIntegrity

    0.6 0.0 Ruby
    Check data integrity for your ActiveRecord models
  • 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.
  • SchemaPlus

    5.4 0.0 L4 Ruby
    SchemaPlus provides a collection of enhancements and extensions to ActiveRecord
  • Large Hadron Migrator

    7.7 0.0 L5 Ruby
    Online MySQL schema migrations
  • Foreigner

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

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

    4.1 1.6 L5 Ruby
    Seamless second database integration for Rails.
  • 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
  • Seed dump

    6.9 0.0 L5 Ruby
    Rails 4/5 task to dump your data to db/seeds.rb
  • PgDriveBackup

    1.1 0.0 Ruby
    Simple solution to make encrypted with ccrypt PostgreSQL backups and storing on Google Drive API
  • ActiveRecord Setops

    0.9 0.0 Ruby
    Union, Intersect, and Difference set operations for ActiveRecord (also, SQL's UnionAll).
  • Perfect Shape

    0.5 9.2 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.
  • OnlineMigrations

    3.2 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).
  • Active Record Doctor

    6.0 6.7 Ruby
    Identify database issues before they hit production.

Add another 'Database Tools' Gem