skills.rest
nahisaho
nahisahoCOMMUNITY
Explore all skills by this author →
GitHub

database-administrator

Automate database administration tasks across multiple database platforms.

12|2|Updated Nov 26, 2025
Search Tags:#database#backup#recovery#tuning#high-availability
One-click install
npx skills add https://github.com/nahisaho/CodeGraphMCPServer --skill database-administrator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-administrator
Source: https://github.com/nahisaho/CodeGraphMCPServer/tree/main/.claude/skills/database-administrator
Command: npx skills add https://github.com/nahisaho/CodeGraphMCPServer --skill database-administrator

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill handles database operations, performance tuning, backup/recovery, and high-availability configurations.

Core Features & Use Cases

  • Database Operations: Installation, configuration, upgrades, capacity planning.
  • Performance Optimization: Query tuning, index design, and bottleneck resolution.
  • Backup & Recovery: Backup strategies, PITR, testing restores.
  • HA & Security: Replication, encryption, access control, and auditing.

Quick Start

Propose a baseline backup plan and a simple query optimization for a slow endpoint.

Frequently Asked Questions about database-administrator

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

FAQPage Schema
How do I create an effective backup and recovery plan for my database?▼

Backup and recovery planning involves defining retention policies, backup frequency, and testing restore procedures across your database system. This Skill automates backup strategies, point-in-time recovery (PITR), and restore validation to ensure data recoverability.

Can I optimize slow database queries and improve performance?▼

Query optimization addresses slow endpoints through index design, execution plan analysis, and bottleneck identification. This Skill tunes query performance, designs indexes, and resolves performance constraints across PostgreSQL, MySQL, Oracle, SQL Server, MongoDB, and cloud databases.

How do I set up high availability and replication for my database?▼

High availability configuration establishes redundancy through replication and failover mechanisms. This Skill automates HA setup, replication configuration, and failover orchestration across distributed and cloud-native database platforms.

Does this work with cloud databases like DynamoDB, Redshift, or BigQuery?▼

Yes. This Skill covers cloud-native databases including DynamoDB, Redshift, BigQuery, Snowflake, and Spanner alongside traditional systems like PostgreSQL, MySQL, Oracle, and SQL Server for unified database administration.

What database security and auditing controls are included?▼

Security management covers encryption, access control configuration, and audit logging setup. This Skill automates security controls and auditing across all supported databases to enforce compliance and data protection.

How do I handle database upgrades and capacity planning?▼

Database maintenance includes installation, configuration, upgrades, and capacity planning to prepare systems for growth. This Skill orchestrates upgrade workflows and capacity assessments across heterogeneous database environments.

Related Skills

Explore More Data & Analytics Skills→
christopherlouetchristopherlouet
5

ops-proxmox

Automates Proxmox VE server deployment and management via Terraform scripts.

Community
Advanced
Datus-aiDatus-ai
1.5k

report-generator

Generate JSON, CSV, or markdown reports from SQL query results.

Official
Basic
manu14357manu14357
16

azure-kusto

Write and optimize KQL queries for Azure Monitor and Data Explorer.

Community
Advanced
yusufcmgyusufcmg
1

multi-cloud-architecture

Design multi-cloud architectures with service selection patterns across AWS, Azure, and GCP.

Community
Advanced