PostgreSQL Tools Directory

pgspot: PostgreSQL Extension Vulnerability Checker

pgspot is a powerful tool designed to identify security vulnerabilities in PostgreSQL extension scripts, ensuring adherence to best practices. It evaluates potential threats such as search_path-based attacks and unsafe object creation, making it an essential resource for developers aiming to secure their PostgreSQL applications.

pgsync: Efficient Data Synchronization for Postgres Databases

pgsync is a robust command-line tool designed to synchronize data seamlessly between Postgres databases. It prioritizes speed, security, and flexibility, allowing users to efficiently transfer data while adhering to schema differences and protecting sensitive information.

pgTAP is a powerful suite of database functions designed for writing TAP-emitting unit tests directly in PostgreSQL. It simplifies the testing of database schema, functions, and procedures, enabling seamless integration with agile development practices for PostgreSQL-backed applications.

pgwatch2: PostgreSQL Metrics Monitoring and Dashboarding Tool

pgwatch2 is a versatile, self-contained monitoring solution for PostgreSQL that enables users to visualize and analyze metrics from versions 9.0 to 16. Designed for minimal intrusion, it supports a variety of deployment methods including Docker, Kubernetes, and standalone configurations, making it suitable for both small-scale and enterprise-level environments.

Pgweb - Web-Based PostgreSQL Database Explorer

Pgweb is a powerful web-based tool designed for exploring PostgreSQL databases, built with Go for cross-platform compatibility on Mac, Linux, and Windows. It offers a lightweight solution with no dependencies, allowing users to effortlessly execute SQL queries, manage multiple sessions, and export data in various formats.

PGXN Client: PostgreSQL Extension Management Tool

The PGXN Client is a powerful command line tool designed for seamless interaction with the PostgreSQL Extension Network, facilitating the management of PostgreSQL extensions. It enables users to efficiently search, install, compile, and remove extensions, streamlining the process of enhancing PostgreSQL databases with additional functionalities.

PGXN: PostgreSQL Extension Network

PGXN is a robust distribution system designed for open-source PostgreSQL extension libraries, enabling users to easily find, install, and manage extensions that enhance PostgreSQL functionality. By providing a centralized repository for a wide range of extensions, PGXN supports developers and database administrators in optimizing their PostgreSQL environments for various use cases, from analytics to performance tuning.

phpPgAdmin: A Web-Based PostgreSQL Administration Tool

phpPgAdmin is a powerful web-based administration tool designed for managing PostgreSQL databases. It provides a user-friendly interface that simplifies database management tasks, making it an ideal solution for developers and database administrators seeking to streamline their workflow and enhance productivity.

Pitrery is a robust set of Bash scripts designed to facilitate Point In Time Recovery (PITR) for PostgreSQL databases. As a Long Term Support (LTS) tool, Pitrery automates continuous archiving while ensuring minimal intrusion, making it an essential resource for PostgreSQL database administrators looking to streamline backup and recovery processes.

plpgsql_check: Advanced PL/pgSQL Linter for PostgreSQL

plpgsql_check is a powerful extension that serves as a comprehensive linter for PL/pgSQL in PostgreSQL. By utilizing the internal PostgreSQL parser, it identifies potential runtime errors, semantic issues, and performance concerns in your PL/pgSQL code, ensuring that developers can write more robust and efficient functions with ease.