postgres-admin

Automate PostgreSQL administration over SSH tunnels with kctl-pg.

Updated Mar 25, 2026

Search Tags:#database #ssh #extensions #backups #admin #postgres #health-monitoring

Ready to run

npx skills add https://github.com/tgunawandev/kodemeio-claude --skill postgres-admin

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: postgres-admin
Source: https://github.com/tgunawandev/kodemeio-claude/tree/main/config/.claude/skills/postgres-admin
Command: npx skills add https://github.com/tgunawandev/kodemeio-claude --skill postgres-admin

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about postgres-admin

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I manage a PostgreSQL production database behind a private network?▼

You can manage a PostgreSQL production database behind a private network by establishing an SSH tunnel. This secures remote administration tasks for databases, roles, and health checks without exposing the database port directly.

What is the best way to automate PostgreSQL backups and health monitoring remotely?▼

Automating PostgreSQL backups and health monitoring remotely is best handled through a dedicated CLI workflow over SSH. This approach exposes metrics via exporters and standardizes maintenance tasks across production environments.

Does this PostgreSQL admin workflow require Docker-based deployment and SSH access?▼

Yes, this PostgreSQL admin workflow requires both SSH access to the admin host and a Docker-based deployment. These prerequisites ensure secure tunneled connectivity and consistent execution of management commands.

Can I manage PostgreSQL connection pooling and extensions via an SSH tunnel?▼

Yes, you can manage PostgreSQL connection pooling and extensions via an SSH tunnel. The workflow integrates PgBouncer for connection management and handles extension installation across your secured production databases.

How do I configure database roles and permissions for a remote PostgreSQL server?▼

To configure database roles and permissions for a remote PostgreSQL server, you use an SSH-tunneled admin connection. This allows you to securely execute role creation, user management, and permission configuration commands.