skills.rest
Eigo-Mt-Fuji
Eigo-Mt-FujiCOMMUNITY
Explore all skills by this author →
Website𝕏@EikichiEngineerGitHub

database-administrator

Coordinates database operations, tuning, backup/recovery, monitoring, and high-availability configuration for major DBMS.

Updated Jan 10, 2026
Search Tags:#monitoring#PostgreSQL#MySQL#performance-tuning#high-availability#backup-recovery#database-administration
One-click install
npx skills add https://github.com/Eigo-Mt-Fuji/portfolio-2026 --skill database-administrator-eigo-mt-fuji
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-administrator
Source: https://github.com/Eigo-Mt-Fuji/portfolio-2026/tree/main/.claude/skills/database-administrator
Command: npx skills add https://github.com/Eigo-Mt-Fuji/portfolio-2026 --skill database-administrator-eigo-mt-fuji

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Copilot assistant that helps with database operations, performance tuning, backup/recovery, monitoring, and high-availability configuration, reducing manual effort and human error.

Core Features & Use Cases

  • Database Operations & Maintenance: installation/configuration, upgrades, capacity planning, and routine health checks.
  • Performance Optimization: query analysis, index recommendations, and parameter tuning to improve responsiveness.
  • Backup & Recovery: backup strategies, PITR procedures, restore workflows, and DR planning.
  • High Availability & Monitoring: replication setup, failover planning, and proactive alerting for outages.
  • Use Case: A DBA asks the agent to audit a production cluster, propose a tuning plan, and verify backup integrity within a week.

Quick Start

Use the database-administrator skill to audit a PostgreSQL cluster and generate a tuning and backup-check plan.

Frequently Asked Questions about database-administrator

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

FAQPage Schema
How do I tune PostgreSQL and MySQL performance for production databases?▼

Performance tuning involves analyzing queries, recommending indexes, and adjusting database parameters like buffer pools and cache settings. This Skill audits your cluster, identifies bottlenecks, and generates a prioritized tuning plan specific to your workload and hardware.

What's the best approach to set up high-availability and replication for databases?▼

High-availability configuration establishes replication streams, automates failover, and ensures data survives node failures. This Skill helps design replication topology, configure failover policies, and validate the setup across PostgreSQL, MySQL, Oracle, SQL Server, and MongoDB.

How do I create a backup and disaster recovery strategy?▼

Backup and recovery planning covers point-in-time recovery (PITR), backup retention policies, restore testing, and DR procedures. This Skill develops strategies tailored to your RTO/RPO requirements and validates backup integrity to prevent data loss.

Can I monitor database health and detect performance issues before outages?▼

Proactive monitoring tracks metrics, sets alerting thresholds, and surfaces anomalies early. This Skill configures monitoring and alerting workflows so you catch degradation, capacity strain, and replication lag before they cause downtime.

Does this support multiple database platforms like Oracle and SQL Server?▼

Yes, this Skill supports PostgreSQL, MySQL/MariaDB, Oracle, SQL Server, and MongoDB, enabling unified administration across heterogeneous environments and reducing context-switching between platform-specific tools.

What database operations and maintenance tasks can be automated?▼

Installation, configuration, upgrades, capacity planning, and routine health checks are operational tasks that this Skill helps automate and document, reducing manual effort and human error in day-to-day DBA work.

Related Skills

Explore More Software Engineering Skills→
PostalocityPostalocity
1

performance-engineer

Profile and optimize software performance across frontend, backend, and database layers.

Official
Advanced
UnicornUnicorn

monitoring-setup-agent

Design and implement monitoring solutions for applications and infrastructure.

Official
Advanced
ancolemanancoleman
503

siem-logging

Configure SIEM systems for threat detection, log aggregation, and compliance.

Community
Advanced
altrupetsaltrupets

Crossplane Multi-Cloud Management

Provision and manage cloud resources via Kubernetes custom resources with Crossplane.

Official
Advanced