skills.rest
doanchienthangdev
doanchienthangdevCOMMUNITY
Explore all skills by this author →
GitHub

managing-databases

Manage PostgreSQL production database backup, restore, monitoring, replication, and security operations.

4|1|Updated Dec 30, 2025
Search Tags:#performance#monitoring#database#postgresql#backup#replication#dba
One-click install
npx skills add https://github.com/doanchienthangdev/omgkit --skill managing-databases-doanchienthangdev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: managing-databases
Source: https://github.com/doanchienthangdev/omgkit/tree/main/plugin/skills/databases/database-management
Command: npx skills add https://github.com/doanchienthangdev/omgkit --skill managing-databases-doanchienthangdev

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the complex and critical tasks of managing production databases, ensuring their reliability, performance, and security.

Core Features & Use Cases

  • Backup & Restore: Implement robust strategies for data protection and disaster recovery.
  • Monitoring & Alerting: Keep a close eye on database health, performance metrics, and potential issues.
  • Replication & HA: Configure and manage database replication for high availability and scalability.
  • Security Hardening: Secure your databases against unauthorized access and threats.
  • Maintenance Operations: Perform routine tasks like vacuuming and reindexing to maintain optimal performance.
  • Use Case: Troubleshoot a slow-running database by analyzing active queries, identifying locks, and optimizing indexes.

Quick Start

Use the managing-databases skill to perform a full PostgreSQL backup of the 'production' database to a compressed file named backup_YYYYMMDD_HHMMSS.dump.

Frequently Asked Questions about managing-databases

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

FAQPage Schema
How do I perform a full PostgreSQL backup and restore for production databases?▼

To perform a PostgreSQL backup and restore, use utilities like pg_dump and pg_restore to implement robust data protection strategies. You can generate compressed dump files for disaster recovery and restore them to maintain database reliability.

What is the best way to troubleshoot slow PostgreSQL performance and identify database locks?▼

Troubleshooting slow PostgreSQL performance involves analyzing active queries, identifying database locks, and optimizing indexes. Monitoring database health and performance metrics helps pinpoint potential issues to maintain optimal operational speed.

How do I configure PostgreSQL replication for high availability?▼

Configuring PostgreSQL replication requires modifying configuration files like postgresql.conf and pg_hba.conf. Managing replication enables high availability and scalability by distributing database workloads across multiple nodes.

What routine maintenance operations do I need to keep PostgreSQL running optimally?▼

Routine PostgreSQL maintenance operations include performing tasks like vacuuming and reindexing. These operations clean up dead tuples and rebuild fragmented indexes to maintain optimal database performance and reliability.

Do I need advanced SQL knowledge to secure and harden my production database?▼

Securing and hardening production databases requires expertise in SQL and PostgreSQL utilities. You must configure pg_hba.conf to restrict unauthorized access and protect against threats, ensuring robust database security.

Related Skills

Explore More Software Engineering Skills→
zangxin75zangxin75

postgres

Execute SQL queries and manage PostgreSQL database schemas.

Community
Intermediate
briannadoubtbriannadoubt

observability

Configure structured logs, metrics, and traces for Trebuchet actors with CloudWatch export.

Community
Intermediate
personamanagmentlayerpersonamanagmentlayer
41

postgresql-expert

Provide PostgreSQL administration, query writing, performance tuning, and production operations guidance.

Official
Advanced
MovchanetsMovchanets

database-admin

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

Community
Advanced