Discover awesome Database Tools Ruby

298

| updated 3 months ago | MIT License

Wipe out inconsistent DB and schema.rb when switching branches. To do that, install this gem and use the standard rake db:migrate command.

after_commit_everywhere

694

| updated 3 months ago | MIT License

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

connection_pool

1,627

| updated 3 months ago | MIT License

Generic connection pooling for Ruby

data-anonymization

456

| updated 8 months ago | MIT License

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

database_cleaner

2,881

| updated over 1 year ago | MIT License

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

database_consistency

1,051

| updated about 1 month ago | MIT License

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

dexter

1,491

| updated over 1 year ago | MIT License

The automatic indexer for Postgres

foreigner

1,335

| updated almost 6 years ago | MIT License

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

fx

747

| updated about 1 month ago | MIT License

Versioned database functions and triggers for Rails

hair_trigger

751

| updated 3 months ago | MIT License

Happy database triggers for ActiveRecord

isolator

850

| updated 7 months ago | MIT License

Detect non-atomic interactions within DB transactions

lhm

1,808

| updated about 1 year ago | BSD 3-Clause "New...

Online MySQL schema migrations

lol_dba

1,584

| updated 9 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.

multiverse

463

| updated over 1 year ago | MIT License

Multiple databases for Rails 🎉

pghero

7,123

| updated about 1 year ago | MIT License

A performance dashboard for Postgres

pg_party

477

| updated 3 months ago | MIT License

ActiveRecord PostgreSQL Partitioning

pgslice

953

| updated over 1 year ago | MIT License

Postgres partitioning as easy as pie

pgsync

2,787

| updated about 1 year ago | MIT License

Sync data from one Postgres database to another

polo

758

| updated about 1 year ago | MIT License

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

postgres-copy

429

| updated 3 months ago | MIT License

Simple PostgreSQL's COPY command support in ActiveRecord models

rails_db

1,447

| updated about 1 year ago | MIT License

Rails Database Viewer and SQL Query Runner

rein

670

| updated about 4 years ago | MIT License

Database constraints made easy for ActiveRecord.

safe-pg-migrations

495

| updated 2 months ago | MIT License

Make your PostgreSQL migrations safe

scenic

3,410

| updated 5 months ago | MIT License

Versioned database views for Rails

schema_plus

689

| updated over 2 years ago | Other

SchemaPlus provides a collection of enhancements and extensions to ActiveRecord

secondbase

219

| updated 3 months ago | MIT License

Seamless second database integration for Rails.

seedbank

1,142

| updated 12 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

1,390

| updated about 1 year ago | MIT License

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

seed-fu

1,221

| updated over 2 years ago | MIT License

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

sql_view

49

| updated over 1 year ago

Rails SQL Views made easy ;)