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.

PostgreSQL partitioning assistant for Rails

ActiveRecord::Migration utility for creating partitions in PostgreSQL.

A driver-adjacent Ruby control-plane over ruby-pg/libpq. It multiplexes independent, session-neutral extended-protocol operations from many fibers onto a small number of PostgreSQL connections while keeping explicit transactions and session-changing work on exclusive pinned connections. Requires any Fiber::Scheduler host (Async::Scheduler, Itsi::Scheduler, …); the gem does not depend on a particular reactor. Control-plane only: all wire work stays in libpq.

ActiveRecord extensions for PostgreSQL. Provides useful tools for schema, foreign_key, index, comment and extensios manipulations in migrations.

Shows the top queries running on your server using pg_stat_statements