Skip to content

PostgreSQL Tools

Contents

PostgreSQL Engine

CLI

  • pgcli - Postgres CLI with autocompletion and syntax highlighting
  • pgsh - Branch your PostgreSQL Database like Git
  • psql - The built-in PostgreSQL CLI client
  • psql2csv - Run a query in psql and output the result as CSV
  • nancy - The Nancy CLI is a unified way to manage automated database experiments either in clouds or on-premise
  • schemaspy - SchemaSpy is a JAVA JDBC-compliant tool for generating your database to HTML documentation, including Entity Relationship diagrams

Monitoring

  • check_pgactivity - check_pgactivity is designed to monitor PostgreSQL clusters from Nagios. It offers many options to measure and monitor useful performance metrics.
  • Check_postgres - Nagios check_postgres plugin for checking status of PostgreSQL databases.
  • Instrumental - Real-time performance monitoring, including pre-made graphs for ease of setup (Commercial Software)
  • libzbxpgsql - Comprehensive PostgreSQL monitoring module for Zabbix.
  • PMM - Percona Monitoring and Management (PMM) is a Free and Open Source platform for monitoring and managing PostgreSQL, MySQL, and MongoDB.
  • Pome - Pome stands for PostgreSQL Metrics. Pome is a PostgreSQL Metrics Dashboard to keep track of the health of your database.
  • pgmetrics - pgmetrics is an open-source, zero-dependency, single-binary tool that can collect a lot of information and statistics from a running PostgreSQL server and display it in easy-to-read text format or export it as JSON and CSV for scripting.
  • pg_view - Open-source command-line tool that shows global system stats, per-partition information, memory stats and other information.
  • pgwatch2 - Flexible and easy to get started PostgreSQL metrics monitor focusing on Grafana dashboards.
  • pgbench - Run a benchmark test on PostgreSQL.
  • opm.io - Open PostgreSQL Monitoring is a free software suite designed to help you manage your PostgreSQL servers. It can gather stats, display dashboards and send warnings when something goes wrong.
  • okmeter.io - Commercial SaaS agent-based monitoring with a very detailed PostgreSQL plugin. It automatically gathers 100s of stats, displays dashboards on every aspect and sends alerts when something goes wrong (Commercial Software).

GUI

PostgreSQL Specific

⭐ = Recommended

  • Adminer - Full-featured database management tool written in PHP.
  • Beekeeper Studio - Free and open source SQL client with a modern UI and great Postgres support. Cross platform. ⭐
  • DataGrip - IDE with advanced tool sets and good cross-platform experience (Commercial Software).⭐
  • Datazenit - Web-based PostgreSQL GUI (Commercial Software).
  • DataRow - Cross-platform SQL Client for Amazon Redshift: Simple, Effortless, Extensible.
  • DBeaver - Universal Database Manager with excellent support for PostgreSQL.⭐
  • dbglass - Cross-platform desktop client for PostgreSQL, built with Electron.
  • Holistics - Online cross platform database management tool and SQL query reporting GUI with strong PostgreSQL support (Commercial Software).
  • JackDB - Web-based SQL query interface (Commercial Software).
  • Metabase - Simple dashboards, charts and query tool for PostgreSQL.
  • Numeracy - Fast SQL editor with charts and dashboards for PostgreSQL (Commercial Software).
  • OmniDB - Open Source Collaborative Environment For Database Management
  • pgAdmin - PostgreSQL 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 PostgreSQL.
  • Postbird - PostgreSQL Client for macOS.
  • PostgresCompare - Cross-platform database comparison and deployment tool (Commercial Software).
  • Postico - Modern PostgreSQL Client for macOS (Commercial Software).
  • PSequel - Clean and simple interface to perform common PostgreSQL tasks quickly (Commercial Software).
  • SQL Tabs - Cross Platform Desktop Client for PostgreSQL written in JS.
  • SQLPro for Postgres - Simple, powerful PostgreSQL manager for macOS (Commercial Software).
  • temBoard - Web-based PostgreSQL GUI and monitoring.
  • TablePlus - Native App which let you edit database and structure. High-end security ensured (Commercial Software).
  • Valentina Studio - Cross-platform database administration tool (Free/Commercial)⭐

Backlinks:

list from [[Database GUIs]] AND -"Changelog"

Developer Tools

Docker

docker pull postgresai/extended-postgres

docker pull postgresai/sync-instances

docker run \
   --name sync_instance \
   --env PGDATA=/var/lib/postgresql/pgdata \
   --env WALG_GS_PREFIX="gs://{BUCKET}/{SCOPE}" \
   --env GOOGLE_APPLICATION_CREDENTIALS="/etc/sa/credentials.json" \
   --volume {PATH_TO_CREDENTIALS}:/etc/sa/credentials.json \
   --volume /var/lib/dblab/data:/var/lib/postgresql/pgdata:rshared \
   --detach \
   postgresai/sync-instance:13

Extensions

Backlinks:

list from [[PostgreSQL Tools]] AND -"Changelog"