CLI for exporting/importing PostgreSQL dumps via FTP/SSH. Can be used for backups or synchronizing databases between production and development environments.

This gem allows you to rapidly generate large amount of json in an activerecord application. By relying on postgres' native functionality, we can skip object instantiation and turn active record queries directly into json.

Relation-aware synchronous full text search index for PostgreSQL using PL/pgSQL triggers described in and generated via ORM-agnostic Ruby.

Utility class for calling functions defined in a PostgreSQL database.

Makes even easier to use postgresql without activerecord

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 ...

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

pg_meta gem

PostgreSQL Metrics

Simple migration tool focused on Postgresql

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

Process notifies about postgresql notifications.