skills.rest
tgunawandev
tgunawandevCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/tgunawandev/kodemeio-claude --skill postgres-admin
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
zangjeicyzangjeicy

pinggy-tunnel

Expose local network services via SSH-based reverse tunneling.

Community
Intermediate
LerianStudioLerianStudio
205

project-health-check

Assess project health across six dimensions and generate recovery recommendations.

Official
Advanced
djankiesdjankies

configuring-connection-pools

Configure Prisma Client connection pools for PostgreSQL deployments.

Community
Advanced
zangxin75zangxin75

db-query

Execute SQL queries against project databases with automatic SSH tunnel management.

Community
Intermediate