pg_shrink makes it simple to shrink and sanitize a PosrgreSQL database

Construct composable, structured, PostgreSQL queries in plain Ruby.

A collection of Postgres data definition SQL builders

pg_space_cadet is a simple hack for postgreSQL and ActiveRecord which provides a uuids table of distributable identities of space cadets -- ActiveRecord::Base instances which use the SpaceCadetWrapper. Each space cadet has a default ActiveRecord id unique in the set of all local space cadets; a s...

Helper class for setting up and easily tearing down PostgreSQL database objects within a testing environment

Production-grade PostgreSQL trigger management for Rails with lifecycle management, safe deploys, versioning, drift detection, and a mountable UI.

Stream data from postgres or Redshift

A gem that makes working with tags stored in a Postgresql column easy. Support for array of string, integer and jsonb values.

PostgreSQL Tasks and Functions for Ruby on Rails

Test postgresql scripts and run queries against a temporary postgresql instance

Store translations in your PG database as HSTORE, JSON or JSONB.

Trigram similarity, guaranteed equivalent to postgres's. Oh yeah.

Handy helpers to create PostgreSQL Triggers

Extensions to pg gem supporting typecasting.

Manage PostgreSQL custom types (composite types, enums, domains) in your Rails application with versioned migrations and schema handling. This cuts the need for keeping a structure.sql while still maintaining proper type definitions in your Rails application.

PostgreSQL notifications with persistence.

A pure ruby "thin" extension of pg that provides logging, transaction retrying, and database reconnecting functionality.

postgresql xml datatype support for activerecord -- heavily based on pg-hstore and activerecord-postgres-hstore

a plugin for tssearch support from postgresql

Provide an health check API