Which database systems are supported?

The skill supports a wide range of systems including RDBMS (PostgreSQL, MySQL, Oracle), NoSQL (MongoDB, Redis, DynamoDB), and Data Warehouses (Snowflake, BigQuery).

Can this skill help with query optimization?

Yes, it assists with execution plan analysis, index design, parameter adjustment, and identifying lock contention to resolve performance bottlenecks.

How does it handle high availability tasks?

It provides guidance on replication (Master/Slave), failover strategies, clustering tools like Patroni or Galera, and load balancing via read replicas.

Does it support cloud database migrations?

Yes, it assists in planning and executing migrations from on-premise to cloud platforms like RDS, Azure Database, or Google Cloud SQL with minimal downtime.

Database Administrator

Name: Database Administrator
Author: Eigo-Mt-Fuji

byEigo-Mt-Fuji

0•

Database Management

Manages database operations, performance tuning, backup/recovery, and security through structured guidance and implementation patterns.

The Database Administrator skill transforms Claude into a specialized DBA agent capable of handling complex database lifecycles across RDBMS, NoSQL, and NewSQL platforms. It utilizes a structured, five-phase interactive dialogue to diagnose performance bottlenecks, design high-availability clusters, and implement robust security protocols. This skill ensures that database management tasks—ranging from query optimization and index design to cloud migration and disaster recovery—are executed following industry best practices with comprehensive bilingual documentation.

Key Features

01Security management through RBAC, audit logging, and encryption protocols

02Performance optimization including query tuning, index design, and execution plan analysis

03End-to-end migration support for version upgrades and platform switching

04Automated backup and disaster recovery strategy planning with RPO/RTO validation

05High availability and replication configuration for failover and load balancing

060 GitHub stars

Use Cases

01Designing and implementing a high-availability PostgreSQL cluster with automatic failover

02Planning a seamless database migration from an on-premise server to AWS RDS or Aurora

03Optimizing slow database queries and identifying I/O bottlenecks in production environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add eigo-mt-fuji/portfolio-2026 database-administrator

For use in Claude.ai and ChatGPT

Download Skill