Simple and convenient interface for PostgreSQL with a few enhancements

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

OpenTracing instrumentation to trace queries made using the Postgres Ruby driver

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.

PgJob

Simple ActiveJob queue for PostgreSQL using LISTEN/NOTIFY

A set of classes and micro-DSLs to generate SQL queries special for PostgreSQL backends.

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

A tool to set up and manage logical replication for PostgreSQL databases

Use LDAP permissions in PostgreSQL

pg_meta gem

PostgreSQL Metrics

Simple migration tool focused on Postgresql

Rake migration tasks which utilities pure SQL files

This tool provides a set of Rake tasks to apply changes on different Postgres environments.

Connects to PostgreSQL and retrieves few statistics such as index stats and table bloats.

A tool to move postgres databases b/w clusters using bucardo

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.

Process notifies about postgresql notifications.

pgoutput-client provides a PostgreSQL logical replication transport for Ruby. It manages replication connections, lifecycle, monitoring, keepalive handling, graceful shutdown, and transport-level acknowledgment boundaries while streaming pgoutput messages to downstream consumers. pgoutput-client owns transport. Parsers, decoders, source adapters, runtimes, and sinks remain separate concerns within the CDC ecosystem.