postgresql hstore parser/deparser - provides PgHstore.dump and PgHstore.load (aka parse)

Organize ActiveRecord model into a tree structure using PostgreSQL LTree

RailsDbInfo is a Rails engine that quickly shows the database info

A Rails engine that adds a piece of middleware to the top of your middleware stack that looks for redirect rules stored in your database and redirects you accordingly.

It makes working with pure SQL easier with syntax highlighting. Let's you clean your Ruby code from SQL strings.

Functions from timescaledb available in the ActiveRecord models.

Add support to complex resources of PostgreSQL, like data types, array associations, auxiliary statements (CTE), and full-text search (FTS)

Manage delta indexes via Delayed Job for Thinking Sphinx

Simple gem that allows you to run multiple ActiveRecord::Relation using hash. Perfect for APIs.

Amazon Redshift adapter for ActiveRecord 7.x.

Yet Another N+1 COUNT Query Killer for ActiveRecord

Add relational OLAP-like functionality for ActiveRecord

Redshift-oriented Data Warehouse Batch Framework

Lazily loads large columns on demand. By default, does this for all TEXT (:text) and BLOB (:binary) columns, but a list of specific columns to load on demand can be given. This is useful to reduce the memory taken by Rails when loading a number of records that have large columns if those particular columns are actually not required most of the time. In this situation it can also greatly reduce the database query time because loading large BLOB/TEXT columns generally means seeking to other database pages since they are not stored wholly in the record's page itself. Although this plugin is mainly used for BLOB and TEXT columns, it will actually work on all types - and is just as useful for large string fields etc.

A gem to help with hooking Contentful into your Rails application

Allows you to define a phase on Active Record migrations and provides rake tasks for running only migrations tagged with a certain phase

The new de-facto for API testing your Rails application

Open-source gems maintenance & maturity tracking

Petri Net Workflow Engine for Ruby.

PG::AWS_RDS_IAM is a plugin for the pg gem that adds support for IAM authentication when connecting to PostgreSQL databases hosted in Amazon RDS.