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

Rake migration tasks which utilities pure SQL files

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 modern Ruby gem that provides PostgreSQL schema-based multitenancy with automatic tenant resolution and schema switching. Compatible with Rails 7+ and Ruby 3.0+, focusing on security, performance, and developer experience. Perfect for modern SaaS applications requiring secure tenant isolation.

Process notifies about postgresql notifications.

PostgreSQL partitioning assistant for Rails

ActiveRecord::Migration utility for creating partitions in PostgreSQL.

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.

Postgres replication protocol

REST API for remote PostgreSQL database migrations.

Simple schema migrations for PostgreSQL, which runs pure SQL.

serializes rails models from postgres (9.5+)