awesome-postgres

A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql

3 years after

Awesome Postgres

A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql

High-Availability

  • Patroni - A template for PostgreSQL HA with ZooKeeper or etcd

Backups

  • wal-e - Simple Continuous Archiving for Postgres to S3, Azure, or Swift by Heroku
  • Barman - Backup and Recovery Manager for Postgres by 2ndQuadrant

GUI

  • DataGrip - An IDE with advanced tool sets and good cross-platform experience (Commercial Software)
  • Datazenit - Web-based PostgreSQL GUI (Commercial Software)
  • DBeaver - Universal Database Manager with excellent support for Postgres
  • Metabase - Simple dashboards, charts and query tool for your Postgres DB
  • pgAdmin - Postgres Administration and Management GUI
  • pgModeler - pgModeler is an open-source PostgreSQL Database Modeler
  • pgweb - Web-based PostgreSQL database browser written in Go
  • phpPgAdmin - The Premier Web Based Administration Tool for Postgres
  • Postico - A Modern PostgreSQL Client for OS X (Commercial Software)
  • PSequel - PSequel provides a clean and simple interface for you to perform common PostgreSQL tasks quickly (Commercial Software)
  • SQL Tabs - A Cross Platform Desktop Client for Postgres written in JS
  • SQLPro for Postgres - A simple, powerful Postgres manager for Mac OS X (Commercial Software)
  • Warp - OS X desktop tool for by-example querying and data transfer from/to PostgreSQL

Distributions

  • Postgres.app - The Easiest Way to Get Started with PostgreSQL on the Mac

CLI

  • pgcli - Postgres CLI with autocompletion and syntax highlighting
  • psql2csv - Run a query in psql and output the result as CSV

Server

  • Postgres-XL - Scalable Open Source PostgreSQL-based Database Cluster

Monitoring

  • Check_postgres - Nagios check_postgres plugin for checking status of PostgreSQL databases
  • libzbxpgsql - A comprehensive PostgreSQL monitoring module for Zabbix
  • Pome - Pome stands for Postgres Metrics. Pome is a PostgreSQL Metrics Dashboard to keep track of the health of your database
  • pg_view - An open-source command-line tool that shows global system stats, per-partition information, memory stats and other information

Extensions

  • PGStrom - Postgres extension to offload CPU intensive workloads to GPU
  • pg_shard - PostgreSQL extension to scale out real-time reads and writes
  • PostGIS - Spatial and Geographic objects for PostgreSQL
  • pg_paxos - Basic implementation of Paxos and Paxos-based table replication for a cluster of PostgreSQL nodes
  • zomboDB - Postgres extension that enables efficient full-text searching via the use of indexes backed by Elasticsearch

Optimization

  • PgHero - Postgres insights made easy
  • pgtune - PostgreSQL configuration wizard
  • pgtune - Online version of PostgreSQL configuration wizard

Utilities

  • PostgREST - PostgREST serves a fully RESTful API from any existing PostgreSQL database
  • mysql-postgresql-converter - Lanyrd's MySQL to PostgreSQL conversion script
  • postgresql-metrics - Tool that extracts and provides metrics on your PostgreSQL database
  • pgloader - Pgloader loads data into PostgreSQL using the COPY streaming protocol, and does so with separate threads for reading and writing data
  • pgbadger - a fast PostgreSQL Log Analyzer
  • pg_activity - pg_activity is a top like application for PostgreSQL server activity monitoring
  • pgfutter - Import CSV and JSON into PostgreSQL the easy way
  • pganalyze - PostgreSQL Performance Monitoring (Commercial Software)
  • yoke - Postgres high-availability cluster with auto-failover and automated cluster recovery
  • pgCenter - Provides convenient interface to various statistics, management task, reloading services, viewing log files and canceling or terminating database backends
  • ERAlchemy - ERAlchemy generates Entity Relation (ER) diagram from databases
  • apgdiff - Compares two database dump files and creates output with DDL statements that can be used to update old database schema to new one
  • PgBouncer - Lightweight connection pooler for PostgreSQL

Language bindings

Tutorials

Blogs

Articles

Newsletters

  • Postgres Weekly - A weekly newsletter that contains articles, news, and repos relevant to Postgres

PaaS

(Postgres as a Service)

  • Database Labs - Get a production-ready cloud Postgres server in minutes, from $20 a month. Backups, monitoring, patches, and 24/7 tech support all included.
  • ElephantSQL - Offers databases ranging from shared servers for smaller projects and proof of concepts, up to enterprise grade multi server setups. Has free plan for up to 5 DBs, 20 MB each.
  • Heroku Postgres - Plans from free to huge, operated by Postgres experts. Does not require running your app on Heroku. Free plan includes 10,000 rows, 20 connections, up to two backups, and has PostGIS support.

Related Repositories

awesome

awesome

:sunglasses: Curated list of awesome lists ...

awesome-awesomeness

awesome-awesomeness

A curated list of awesome awesomeness ...

awesome-tryo

awesome-tryo

A curated list of awesome resources we use at Tryolabs ...

awesome-bigdata

awesome-bigdata

A curated list of awesome big data frameworks, ressources and other awesomeness. ...

fantastic-postgres

fantastic-postgres

Documents and tools for open source database - PostgreSQL. ...


Top Contributors

dhamaniasad lfittl craigkerstiens williamn kimrutherford lauris defkode andrepoleza idan LappleApple fphilipe ReadmeCritic aymer Alexis-benoist BDHU camsaul GeertJohan chanmix51 jl2 inthecloud247 kakoni knpwrs kfirshay hanky6 NikolayS pjlegato cavaliercoder Bauerpauer slobo basiszwo