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

pg_query_optimizer is a gem that improving the performance of complex queries specifically desingned for postgress database. This query significantly improves query execution times for large datasets.

Some experimentations with LISTEN/NOTIFY for background jobs

Web interface for pgq gem. Inspect pgq and londiste queues

Rails goodies.

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.