skills.rest
mtsatryan
mtsatryanCOMMUNITY
Explore all skills by this author →
GitHub

database-administrator

Automate PostgreSQL, MySQL, MongoDB, and Redis administration for high availability and performance.

1|Updated Apr 23, 2026
Search Tags:#automation#performance#monitoring#database#replication#backups#high-availability
One-click install
npx skills add https://github.com/mtsatryan/openclaw-ai-agents --skill database-administrator-mtsatryan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-administrator
Source: https://github.com/mtsatryan/openclaw-ai-agents/tree/main/database-administrator
Command: npx skills add https://github.com/mtsatryan/openclaw-ai-agents --skill database-administrator-mtsatryan

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Maintaining production-grade databases across PostgreSQL, MySQL, MongoDB, and Redis requires continuous tuning, HA configurations, robust backups, and reliable disaster recovery to prevent downtime and data loss.

Core Features & Use Cases

  • High availability configuration (99.99%) with automated failover, replication, and read replicas.
  • Performance tuning, query optimization, indexing strategies, and capacity planning across multiple engines.
  • Disaster recovery planning, automated backup testing, point-in-time recovery, and runbooks for incident response.

Quick Start

Configure a production-grade, highly available database cluster with automated backups and monitoring.

Frequently Asked Questions about database-administrator

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

FAQPage Schema
How do I automate high availability configuration and failover for production databases?▼

Maintain high availability by automating database cluster configuration with automated failover, replication, and read replicas across PostgreSQL, MySQL, MongoDB, and Redis to achieve 99.99% uptime.

What is the best way to verify automated database backups and plan for disaster recovery?▼

Plan disaster recovery by implementing automated backup testing, point-in-time recovery, and documented incident response runbooks to prevent data loss across production database environments.

How do I approach performance tuning and query optimization for multiple database engines?▼

Tune database performance by applying query optimization, indexing strategies, and capacity planning tailored to PostgreSQL, MySQL, MongoDB, and Redis to keep databases fast.

Does this database administration automation support security hardening and access control?▼

Database administration automation supports security hardening and access control, applying configurations across PostgreSQL, MySQL, MongoDB, and Redis to protect production environments.

Can I use this to set up monitoring and alerting for database replication and capacity?▼

Automate database monitoring by configuring continuous tracking for replication, capacity planning, and failover readiness to maintain high availability and performance across multiple DB engines.

Related Skills

Explore More Software Engineering Skills→
rnavarychrnavarych
14

role-database:replication-ha

Design high availability and replication topologies for database engines.

Community
Advanced
nahisahonahisaho
69

slo-sli-guide

Define SLIs and SLOs with monitoring, alerting, and incident-response runbooks.

Community
Advanced
masermediagroup-stackmasermediagroup-stack
1

security-hardening

Automate security hardening across OS, container, cloud, network, and database layers.

Community
Advanced
belokonmbelokonm
8

database-administrator

Optimize production database operations for PostgreSQL, MySQL, and MongoDB deployments.

Community
Advanced