postgres-admin

What problem does it solve?

Centralizes and secures PostgreSQL server administration via an SSH tunnel, enabling consistent management of databases, roles, health, backups, extensions, and connection pooling across production environments.

Core Features & Use Cases

• SSH-tunneled admin access to multiple PostgreSQL databases
• Health monitoring, metrics exposure, and connection management via PgBouncer and exporters
• Role/user management, database lifecycle (create/drop), and permission configuration
• Backup and restore workflows, extension management, and maintenance tasks
• CLI tooling integration (kctl-pg) for automation and scripted workflows in production

Quick Start

SSH into the admin host and run kctl-pg to perform common PostgreSQL administration tasks, such as listing databases and managing users.