skills.rest
saeed-vayghan
saeed-vayghanCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-administrator

Administer PostgreSQL, MySQL, MongoDB, and Redis for high availability and performance.

30|7|Updated Jan 13, 2026
Search Tags:#performance#database#postgresql#disaster recovery#high availability#mysql#dba
One-click install
npx skills add https://github.com/saeed-vayghan/gemini-agent-skills --skill database-administrator-saeed-vayghan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-administrator
Source: https://github.com/saeed-vayghan/gemini-agent-skills/tree/main/.gemini/skills/database-administrator
Command: npx skills add https://github.com/saeed-vayghan/gemini-agent-skills --skill database-administrator-saeed-vayghan

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes assets (resource) components.

What problem does it solve?

This Skill addresses the critical need for expert database management, ensuring high availability, optimal performance, and robust disaster recovery across various database systems.

Core Features & Use Cases

  • High Availability & Performance: Implements and maintains systems with 99.99% uptime and sub-second query performance.
  • Disaster Recovery: Establishes and tests comprehensive backup and recovery strategies with low RTO/RPO.
  • Multi-Database Expertise: Masters PostgreSQL, MySQL, MongoDB, and Redis, covering installation, configuration, monitoring, and optimization.
  • Use Case: A company experiencing slow query times and occasional downtime can leverage this Skill to diagnose issues, implement performance tuning, and configure high-availability solutions to ensure continuous operation.

Quick Start

Use the database-administrator skill to assess the current performance of the production PostgreSQL database.

Frequently Asked Questions about database-administrator

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

FAQPage Schema
How do I optimize PostgreSQL for sub-second query performance?▼

To optimize PostgreSQL for sub-second query performance, you must diagnose slow queries and implement performance tuning configurations. This ensures high-availability systems achieve the required sub-second response times.

What is the best way to establish disaster recovery for MySQL and MongoDB?▼

Disaster recovery for MySQL and MongoDB requires establishing and testing comprehensive backup and recovery strategies. This approach achieves low RTO and RPO to maintain high availability during system failures.

How do I configure high availability to achieve 99.99% database uptime?▼

Configuring high availability for 99.99% database uptime requires implementing installation, monitoring, and automation across your database systems. This ensures continuous operation and minimizes unexpected downtime.

Can I manage Redis configuration and monitoring alongside relational databases?▼

Yes, you can manage Redis configuration and monitoring alongside PostgreSQL and MySQL. This multi-database administration covers installation, security, and optimization across diverse data stores within a single workflow.

Why does database performance degrade during peak loads despite standard configurations?▼

Database performance degrades during peak loads when standard configurations lack proper performance optimization and automated scaling. Expert administration is required to implement monitoring and tuning for high-availability systems.

Related Skills

Explore More Software Engineering Skills→
Kling0012Kling0012
1

luckperms

Configure LuckPerms groups, permissions, and inheritance across Minecraft server networks.

Community
Advanced
DexploarerDexploarer
7

disaster-recovery-planner

Design disaster recovery strategies with tiered RTO/RPO targets and multi-region failover.

Community
Advanced
floflo777floflo777
33

rag-eval

Evaluate RAG systems using retrieval, generation, and latency metrics.

Community
Intermediate
MovchanetsMovchanets

database-admin

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

Community
Advanced