Creates a Histogram fron an ActiveRecord query

pg_index_where will provide unique index with WHERE statement on PostgreSQL with migrate the database on Rails.

pg_jbuilder is a tool to dump database queries directly to a JSON object or array. It uses PostgreSQL's JSON functions ([array_to_json and row_to_json](http://www.postgresql.org/docs/9.3/static/functions-json.html)) to serialize the JSON completely bypassing ActiveRecord/Arel. This gives a large speed boost compared to serializing the JSON inside of Ruby/Rails. It is perfect for creating JSON APIs with very low response times.

A gem to facilitate the use of LIKE ANY and LIKE ALL PostgreSQL operators with Rails ActiveRecord

A production-ready Ruby gem providing PostgreSQL schema-based multitenancy with automatic tenant resolution, secure isolation, and high performance. Built for Rails 8+ and Ruby 4.0+, tested with latest stable versions. Features comprehensive test coverage (217 tests, 100% passing), complete YARD documentation, and interactive HTML documentation site. Perfect for modern SaaS applications with database-level isolation.

Simple manager for PostgreSQL objects like triggers and functions

ActiveRecord::Migration utility for creating partitions in PostgreSQL.

Disable load balancing by Pgpool-II for Rails apps.

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

ActiveRecord PostgreSQL auto-reconnection, works with 2.3 and 3.2 rails.

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

Simple ActiveRecord PostgreSQL full text backed by Arel

serializes rails models from postgres (9.5+)

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.

PgSqlCaller is a small, focused wrapper for running raw SQL against PostgreSQL through ActiveRecord. It exposes a stable, documented API on an ActiveRecord-backed class you name, covering the queries the query builder makes awkward: single-scalar and single-column SELECTs, raw rows, ActiveRecord::Result reads, and type-cast (serialized) variants that decode PostgreSQL arrays and custom column types into Ruby objects. Every ? placeholder is bound and escaped through the ActiveRecord sanitizer, so statements stay injection-safe with no manual quoting. On top of that it adds PostgreSQL-specific helpers — non-consuming sequence peeking, table and relation sizes, EXPLAIN ANALYZE, NOTICE capture, and quoting/sanitizing utilities — plus a fast, injection-safe bulk update that partially updates many existing rows in a single UPDATE ... FROM unnest(...) statement and round-trip. The reader API is extensible via define_sql_method, and the gem runs on Ruby 3.2+ with Rails 7.1 through 8.1.

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

Retries database transaction on deadlock and transaction serialization errors.

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

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.