skills.rest
claudchereji
claudcherejiCOMMUNITY
Explore all skills by this author →
GitHub

database-administrator

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

Updated Jan 19, 2023
Search Tags:#performance#database#postgresql#redis#mysql#mongodb#dba#ha#dr
One-click install
npx skills add https://github.com/claudchereji/VisualVerses --skill database-administrator-claudchereji
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-administrator
Source: https://github.com/claudchereji/VisualVerses/tree/main/.opencode/skills/database-administrator
Command: npx skills add https://github.com/claudchereji/VisualVerses --skill database-administrator-claudchereji

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (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 for various database systems.

Core Features & Use Cases

  • Database Health & Performance: Monitors and optimizes database performance, ensuring sub-second query times and 99.99% uptime.
  • High Availability & Disaster Recovery: Implements and manages replication, failover, and backup strategies to guarantee data integrity and business continuity.
  • Cross-Platform Expertise: Masters PostgreSQL, MySQL, MongoDB, and Redis, providing comprehensive administration across diverse database technologies.
  • Use Case: A company experiencing slow application response times due to database bottlenecks can leverage this Skill to identify and resolve performance issues, significantly improving user experience and operational efficiency.

Quick Start

Use the database-administrator skill to assess the current performance and backup status of our PostgreSQL production 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 database performance and reduce query latency in PostgreSQL and MySQL?▼

Database performance optimization for PostgreSQL and MySQL involves monitoring queries, tuning configurations, and analyzing bottlenecks. This Skill assesses your systems to resolve slow response times, targeting sub-second query performance and ensuring 99.99% uptime.

What is the best way to set up high availability and disaster recovery for MongoDB and Redis?▼

High availability and disaster recovery for MongoDB and Redis require configuring replication, automated failover, and robust backup strategies. This Skill implements these mechanisms to guarantee data integrity and business continuity during system failures.

How do I configure cross-platform database administration for PostgreSQL, MySQL, MongoDB, and Redis?▼

Cross-platform database administration across PostgreSQL, MySQL, MongoDB, and Redis is configured through unified installation, monitoring, and security hardening. This Skill provides expert management across these diverse technologies to maintain reliable operations.

Can I use this database administration approach to resolve application bottlenecks and improve uptime?▼

Yes, this database administration approach resolves application bottlenecks by identifying and fixing database performance issues. It leverages monitoring and automation to significantly improve user experience and operational efficiency while maintaining 99.99% uptime.

Why does database replication failover not work as expected during high availability configuration?▼

Database replication failover issues during high availability configuration often stem from misconfigured backup strategies or unmonitored replication lags. This Skill manages failover mechanisms and monitors health to prevent data integrity loss and ensure business continuity.

Related Skills

Explore More Software Engineering Skills→
Snowflake-LabsSnowflake-Labs
1

oracle-connection

Configure and verify Oracle database connections for schema extraction.

Official
Intermediate
HainrixzHainrixz
18

db-antipatterns

Detect anti-patterns in relational and NoSQL database schemas.

Community
Advanced
mf-dynatracemf-dynatrace

dt-obs-hosts

Monitor and analyze host and process metrics using DQL.

Community
Advanced
MovchanetsMovchanets

database-admin

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

Community
Advanced