Skip to content

PostgreSQL Tools

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

  • dbeaver -

  • Valentina Studio -

  • pgAdmin4

  • Dbeaver

  • Beekeeper Studio

  • Valentina Studio

  • DBTarzan

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

postgrest/postgrest (docker.com) postgrestoauth/api (docker.com) PostgREST Documentation — PostgREST 7.0.1 documentation

Extensions

Links: Source: