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

Database Management

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

About

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

Security management through RBAC, audit logging, and encryption protocols
Performance optimization including query tuning, index design, and execution plan analysis
End-to-end migration support for version upgrades and platform switching
Automated backup and disaster recovery strategy planning with RPO/RTO validation
High availability and replication configuration for failover and load balancing
0 GitHub stars

Use Cases

Designing and implementing a high-availability PostgreSQL cluster with automatic failover
Planning a seamless database migration from an on-premise server to AWS RDS or Aurora
Optimizing slow database queries and identifying I/O bottlenecks in production environments

About

Key Features

Security management through RBAC, audit logging, and encryption protocols
Performance optimization including query tuning, index design, and execution plan analysis
End-to-end migration support for version upgrades and platform switching
Automated backup and disaster recovery strategy planning with RPO/RTO validation
High availability and replication configuration for failover and load balancing
0 GitHub stars

Use Cases

Designing and implementing a high-availability PostgreSQL cluster with automatic failover
Planning a seamless database migration from an on-premise server to AWS RDS or Aurora
Optimizing slow database queries and identifying I/O bottlenecks in production environments