Easily use randomized keys instead of sequential values for your record surrogate ids.

Console utility for gracefully rebuild indexes/pkeys for PostgreSQL, with minimal locking in semi-auto mode.

Safe, cross platform, shell calls

serializes rails models from postgres (9.5+)

pg_shrink makes it simple to shrink and sanitize a PosrgreSQL database

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 space cadet's id is derived from its uuid - UUID's are by design universally distributable.

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.

Test postgresql scripts and run queries against a temporary postgresql instance

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

Create PostgreSQL trigger with ActiveRecord Migration

Handy helpers to create PostgreSQL Triggers

Creates unlogged tables for testing.

Postgres connection string builder gem with construction through a prompt or Ruby method.

PG_Utils is a simple PostgreSQL utility gem. It provides a command line interface to backup the datavase from a remote server, restore a backup locally and kill existing sessions.

Easy Postgres version utilities

PostgreSQL notifications with persistence.

A beautiful way to write PHP