PostgreSQL Open Source Database

# Toolbox

Here a list of useful PostgreSQL tools.

Note	Name	Description
	age	PostgreSQL graph database extension
	barman	Backup and disaster recovery
★★★	citus	Distributed database extension
	data models examples (opens new window)	A Guide to Structuring Information for Optimal Insights and Decision-Making
★★★	epgsql	Erlang PostgreSQL client
	libpg_query (opens new window)	C PostgreSQL parser
	pg_idkit	Extension to generate UUID
	pg_partman	Partition extension
	pg_task	Job scheduler
★★★	pgbackrest	Backup extension
★★★	pgclimb	Export data from PostgreSQL into different data formats
	pgcmp (opens new window)	Comparing Postgres database schemas
	pgloader	Multi loader and converter tool
★	pgmigrate (opens new window)	Tool to evolve PostgreSQL schema
	pgmodeler (opens new window)	Data modeling tool designed for PostgreSQL
	pgmp	Erlang/OTP 25+ PostgreSQL client
★★★	pgpq	Generic Queue for PostgreSQL
	pgsql	Erlang PostgreSQL driver
	pgsql-listen-exchange (opens new window)	RabbitMQ Exchange that publishes messages received from PostgreSQL Notifications
	pgunit (opens new window)	Unit test framework for Postgresql
★	pgtap	Unit testing framework
	plpgsql_check	plpgsql linter and static analyzer tool
★★★	postgrest	Standalone web server
★★★	sqitch	Agnostic database change management
	sqldef	Agnostic database diffing SQL schema
	sqldesigner (opens new window)	Online SQL diagram tool
★★	temporal_tables	Temporal tables extension and support
★★★	timescaledb	Time-series database extension
	zombodb	Powerful text-search and analytics features to Postgres

\x

CREATE EXTENSION pgcrypto;
SELECT crypt('mypass', gen_salt('bf');

pglister (opens new window): mailing-list powered by postgresql

pigsty (opens new window): PostgreSQL in Great STYle, Battery-Included Free RDS Alternative!