skills.rest
aarushlohit
aarushlohitCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

db-admin

Automates PostgreSQL backup, restore, monitoring, replication and administrative tasks via pg_dump, WAL archiving, pgbouncer.

Updated Apr 1, 2026
Search Tags:#monitoring#postgresql#restore#backup#replication#dba
One-click install
npx skills add https://github.com/aarushlohit/TheRocketProject --skill db-admin-aarushlohit
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-admin
Source: https://github.com/aarushlohit/TheRocketProject/tree/main/rocket/external/shokunin/.pack/skills/db-admin
Command: npx skills add https://github.com/aarushlohit/TheRocketProject --skill db-admin-aarushlohit

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires postgresql, pg_dump, pgbouncer, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill streamlines complex PostgreSQL database administration tasks such as backup, restore, monitoring, replication, and maintenance, making database management more efficient.

Core Features & Use Cases

  • Backup & Restore: Perform full and custom database backups, and recover data with various options like pg_dump and PITR.
  • Monitoring: Health check and monitoring of database performance, including connections, bloat, cache hit ratio, and dead tuples.
  • Replication: Configure and manage PostgreSQL replication for high availability and read scaling.
  • Use Case: When you need to ensure your database is backed up securely, monitor its health, or set up replication for disaster recovery.

Quick Start

To backup your PostgreSQL database, run the 'backup-db' script with the appropriate database name and parameters.

Frequently Asked Questions about db-admin

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

FAQPage Schema
How do I automate PostgreSQL backup and restore tasks?▼

Automate PostgreSQL backup and restore by executing specific scripts that leverage pg_dump for full or custom database backups and Point-in-Time Recovery (PITR) to restore databases to a specific state. This ensures secure data recovery and operational efficiency.

What is PostgreSQL Point-in-Time Recovery and when do I need it?▼

PostgreSQL Point-in-Time Recovery (PITR) uses WAL archiving to restore a database to a specific moment before an error or data loss occurred. You need PITR when a standard backup is insufficient to recover recent transactions or correct accidental deletions.

Do I need pgbouncer to monitor PostgreSQL health and connections?▼

Yes, pgbouncer is a required dependency for this PostgreSQL monitoring approach, which checks database health by analyzing connections, cache hit ratio, bloat, and dead tuples to ensure optimal performance and resource utilization.

What's the best way to configure PostgreSQL replication for high availability?▼

The best way to configure PostgreSQL replication for high availability and read scaling is to use automated operational scripts that set up and manage replication, ensuring your database system can handle disaster recovery and distribute read traffic effectively.

How does WAL archiving work with pg_dump for database backups?▼

WAL archiving works alongside pg_dump by continuously logging database changes, allowing Point-in-Time Recovery from the base backup created by pg_dump. This combination ensures you can restore the database to any specific point after the backup.

Related Skills

Explore More Software Engineering Skills→
EliasOulkadiEliasOulkadi
110

db-admin

Diagnose PostgreSQL production health, create verified backups, and configure replication.

Community
Advanced
interflownexinterflownex
2

cloud-sql-postgres-lifecycle

Manage Google Cloud SQL for PostgreSQL backups, restores, and upgrade pre-checks.

Community
Advanced
rnavarychrnavarych
14

role-database:connection-management

Configure database connection pooling across PostgreSQL and MySQL engines.

Community
Advanced
MovchanetsMovchanets

database-admin

Plan and validate database administration workflows for cloud and self-managed environments.

Community
Advanced