Awesome Ruby Database Tools

  • updated 3 months ago MIT License

    Keep consistent DB schema across branches in your Rails project

  • updated 2 months ago MIT License

    Use ActiveRecord transactional callbacks outside of models, literally everywhere in your application.

  • updated 3 months ago MIT License

    Generic connection pooling for Ruby

  • updated about 1 month ago MIT License

    Want to use production data for testing, data-anonymization can help you.

  • updated 9 months ago MIT License

    Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.

  • updated 4 months ago MIT License

    The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.

  • dexter dexter 1,491
    star
    updated 11 months ago MIT License

    The automatic indexer for Postgres

  • foreigner foreigner 1,335
    star
    updated about 5 years ago MIT License

    Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb

  • fx fx 674
    star
    updated 19 days ago MIT License

    Versioned database functions and triggers for Rails

  • updated 2 months ago MIT License

    Happy database triggers for ActiveRecord

  • updated 2 months ago MIT License

    Detect non-atomic interactions within DB transactions

  • lhm lhm 1,808
    star
    updated 8 months ago BSD 3-Clause "New...

    Online MySQL schema migrations

  • lol_dba lol_dba 1,569
    star
    updated about 2 months ago

    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.

  • updated 12 months ago MIT License

    Multiple databases for Rails 🎉

  • pghero pghero 7,123
    star
    updated 8 months ago MIT License

    A performance dashboard for Postgres

  • updated 25 days ago MIT License

    ActiveRecord PostgreSQL Partitioning

  • updated 11 months ago MIT License

    Postgres partitioning as easy as pie

  • pgsync pgsync 2,787
    star
    updated 6 months ago MIT License

    Sync data from one Postgres database to another

  • polo polo 758
    star
    updated 7 months ago MIT License

    Polo travels through your database and creates sample snapshots so you can work with real world data in development.

  • updated about 1 year ago MIT License

    Simple PostgreSQL's COPY command support in ActiveRecord models

  • rails_db rails_db 1,447
    star
    updated 7 months ago MIT License

    Rails Database Viewer and SQL Query Runner

  • rein rein 670
    star
    updated over 3 years ago MIT License

    Database constraints made easy for ActiveRecord.

  • updated 17 days ago MIT License

    Make your PostgreSQL migrations safe

  • scenic scenic 3,333
    star
    updated about 1 month ago MIT License

    Versioned database views for Rails

  • updated almost 2 years ago Other

    SchemaPlus provides a collection of enhancements and extensions to ActiveRecord

  • updated over 2 years ago MIT License

    Seamless second database integration for Rails.

  • seedbank seedbank 1,133
    star
    updated 5 months ago MIT License

    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.

  • seed_dump seed_dump 1,392
    star
    updated 7 months ago MIT License

    Rails 4/5 task to dump your data to db/seeds.rb

  • seed-fu seed-fu 1,217
    star
    updated over 1 year ago MIT License

    Advanced seed data handling for Rails, combining the best practices of several methods together.

  • updated 11 months ago

    Rails SQL Views made easy ;)

  • updated about 1 year ago MIT License

    Read from standby databases for ActiveRecord

  • updated 6 months ago MIT License

    Catch unsafe migrations in development

  • taps taps 1,198
    star
    updated about 6 years ago MIT License

    simple database import/export app

  • upsert upsert 655
    star
    updated about 3 years ago MIT License

    Upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates functions (UDF) for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE.

  • updated about 2 months ago MIT License

    Advisory locking for ActiveRecord