PostgreSQL Tools⚑

PostgreSQL Engine⚑

• PostgreSQL: The world's most advanced open source database
  • PostgreSQL: About
  • PostgreSQL: Documentation: 13: PostgreSQL 13.2 Documentation
  • PostgreSQL: Downloads
• PostgreSQL: Software Catalogue - Administration/development tools

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⚑

• pgHero
• pgSync
• postgres-ai/database-lab
• DBML, dbdocs.io, dbdiagram.io
• PostgREST
• postGIS
• WAL-G:
  • wal-g/wal-g: Archival and Restoration for Postgres (github.com)

Docker⚑

• postgres (docker.com)
• postgres/Dockerfile
• postgresai/extended-postgres (docker.com)

docker pull postgresai/extended-postgres

• postgresai/sync-instance (docker.com)

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⚑

- Table of Contents — pgRouting Manual (3.1)⚑

---

Links: Source: