Useful DBA tools by Data Egret
ShellOtheractive
Awesome Postgres
Search 139 Postgres projects →139 projects16 categoriesshowing 61–120, page 2 of 3
- 57%active
- 10%steady
- 17%slowing
- 16%dormant
Sourced fromdhamaniasad/awesome-postgres
Projects 61–120 of 139, most starred first
Elixir: postgrex
Elixiractive
PostgreSQL configuration wizard.
PythonBSD 3-Clause "New" or "Revised" Licensedormant
Percona Monitoring and Management (PMM) is a Free and Open Source platform for monitoring and managing PostgreSQL, MySQL, and MongoDB.
GoGNU Affero General Public License v3.0active
Pome stands for PostgreSQL Metrics. Pome is a PostgreSQL Metrics Dashboard to keep track of the health of your database.
GoApache License 2.0dormant
Extension to scale out real-time reads and writes.
CGNU Lesser General Public License v3.0dormant
CLI (and Golang library) for diffing Postgres schemas and generating SQL migrations with minimal locking.
GoMIT Licenseactive
Ruby: pg
COtheractive
The Premier Web Based Administration Tool for PostgreSQL.
PHPOtherslowing
A fork of pg_arman, improved by @PostgresPro, supports incremental backups, backups from replica, multithreaded backup and restore, and anonymous backup without archive command.
PythonOtheractive
Extension that allows to check plpgsql source code.
COtheractive
Web-based PostgreSQL GUI and monitoring.
PythonOtheractive
100% open-source logical multi-master PostgreSQL replication.
COtheractive
Postgres metrics collection and visualization that can be deployed to bare metal, virtual machines, or Kubernetes.
PLpgSQLOthersteady
An extension for automatic bloat cleanup with minimal locking.
COtheractive
CLI tool to evolve schema migrations, developed by Yandex.
PythonPostgreSQL Licenseactive
Branch your PostgreSQL Database like Git
JavaScriptMIT Licensedormant
Nagios check_postgres plugin for checking status of PostgreSQL databases.
PerlOtherslowing
Tool that extracts and provides metrics for your PostgreSQL database.
PythonApache License 2.0dormant
Zig: pg.zig, qail-zig
ZigMIT Licenseactive
Query Performance Monitoring tool for PostgreSQL.
PerlOtheractive
PostgreSQL extension for transparent JSONB compression
CMIT Licensedormant
pg_back is a simple backup script
GoOtheractive
Generate PlantUML ER diagram textual description from PostgreSQL tables
GoMIT Licenseslowing
A collection of sample postgres schemas
PLpgSQLslowing
Open-source command-line tool that shows global system stats, per-partition information, memory stats and other information.
PythonOtherdormant
a program for tuning a TimescaleDB database to perform its best based on the host's resources such as memory and number of CPUs.
GoApache License 2.0active
Adaptive query optimization for PostgreSQL.
CGNU Affero General Public License v3.0active
Real time replica from MySQL to PostgreSQL with optional type override migration and migration capabilities.
PythonBSD 2-Clause "Simplified" Licenseactive
Common Lisp: Postmodern
Common LispOtherslowing
Provides an audit trail for your data inside a PostgreSQL database using triggers and server-side functions written in PL/pgSQL.
PLpgSQLGNU Lesser General Public License v3.0steady
Postgres database schema versioning.
PythonBSD 3-Clause "New" or "Revised" Licenseslowing
Export data from PostgreSQL into different data formats.
GoMIT Licensedormant
Enhanced PostgreSQL logical replication
GoApache License 2.0slowing
Percona Operator for PostgreSQL based on Crunchy Data operator.
GoOtheractive
BiDirectional Replication - a multimaster replication system for PostgreSQL
Cdormant
Tool to build, maintain and execute a regression testing suite for SQL queries.
GoOtheractive
PostgreSQL Automatic Failover: High-Availibility for Postgres, based on Pacemaker and Corosync.
PerlOtherslowing
R: RPostgres, RPostgreSQL
ROtheractive
Convenient SQL for monitoring Postgres database health.
TSQLMIT Licensedormantarchived
Cloud-native database gateway and framework for building data-driven applications. Like API gateways, for databases.
GoGNU Affero General Public License v3.0active
SQL command-line client with query management and interactive results.
GoMIT Licenseactive
A fast, driver-less TUI to browse, query, and edit PostgreSQL databases.
RustMIT Licenseactive
Replication tools, including PgQ, a queuing system, and Londiste, a replication system a bit simpler to manage than Slony.
PythonOtherdormantarchived
Active Session History for PostgreSQL. Samples pg_stat_activity once per second via pg_cron, stores encoded snapshots, and provides 32 SQL functions for wait event analysis. Pure SQL, no extensions, works on managed providers (RDS, Cloud SQL, Supabase, etc.).
PLpgSQLApache License 2.0active
Synchronize roles and privileges from YML and LDAP.
GoPostgreSQL Licenseactive
Run a query in psql and output the result as CSV
ShellMIT Licensedormant
check_pgactivity is designed to monitor PostgreSQL clusters from Nagios. It offers many options to measure and monitor useful performance metrics.
PerlPostgreSQL Licenseactive
Advanced WAL File Management Tools for PostgreSQL.
Perldormant
Clojure: clj-postgresql
ClojureBSD 2-Clause "Simplified" Licenseslowing
Command line tool to interact with the PostgreSQL Extension Network
PythonOtherslowing
Spot vulnerabilities in PostgreSQL extension scripts.
PythonPostgreSQL Licenseactive
Lua: luapgsql
Csteady
Linter for dangerous Postgres migration patterns in Diesel and SQLx.
RustMIT Licenseactive
Web UI to view pg_stat_statements.
Rubydormant
A PostgreSQL SQL syntax beautifier (Node.js).
TypeScriptOthersteady
A microservice that provides HTTP endpoints for instantly retrieving the current master host or a replica that meets various criteria.
CMIT Licenseactive
Pagila, Postgres Sample Database
PLpgSQLsteady
A daemon to run stateful Postgres on cheap AWS Spot VMs
PythonApache License 2.0active
Comprehensive SQL syntax reference covering window functions, CTEs, and PostgreSQL-specific syntax (UPSERT, JSON queries, array operations).
MIT Licensesteady