Which database systems does this skill support?

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

How does it handle complex tasks like cloud migrations?

It uses a structured 5-phase dialogue to gather environment details, scale, and downtime requirements before generating a step-by-step migration and validation plan.

Can it help with production performance bottlenecks?

Yes, it specializes in slow log analysis, execution plan review, index optimization, and parameter tuning to resolve I/O and locking issues.

Does this skill provide documentation in multiple languages?

Yes, it has a mandatory policy to generate all technical documentation in both English and Japanese to ensure team-wide accessibility.

Database Administrator

Name: Database Administrator
Author: nahisaho

bynahisaho

•

Gestión de Bases de Datos

Manages database operations, performance tuning, and high availability configurations across multiple DBMS platforms through a structured workflow.

Acerca de

The Database Administrator skill transforms Claude into a specialized DBA agent capable of handling the entire lifecycle of database management. It provides expert guidance on performance optimization, query and index tuning, disaster recovery planning, and security hardening. By following a rigorous five-phase interactive dialogue, it ensures that all environmental constraints and business requirements—such as RTO/RPO and compliance standards—are fully understood before providing implementation plans and mandatory bilingual documentation (English and Japanese).

Características Principales

13 GitHub stars
High availability architecture for replication, failover, and clustering
Security auditing, access control (RBAC), and encryption management
Performance tuning including execution plan analysis and index design
Comprehensive backup and disaster recovery strategy development
End-to-end migration planning for version upgrades and cloud transitions

Casos de Uso

Planning a seamless database migration from on-premise servers to AWS RDS or Google Cloud SQL
Designing a multi-node high availability configuration for mission-critical applications
Analyzing and resolving slow-running queries in production PostgreSQL or MySQL environments

Acerca de

Características Principales

13 GitHub stars
High availability architecture for replication, failover, and clustering
Security auditing, access control (RBAC), and encryption management
Performance tuning including execution plan analysis and index design
Comprehensive backup and disaster recovery strategy development
End-to-end migration planning for version upgrades and cloud transitions

Casos de Uso

Planning a seamless database migration from on-premise servers to AWS RDS or Google Cloud SQL
Designing a multi-node high availability configuration for mission-critical applications
Analyzing and resolving slow-running queries in production PostgreSQL or MySQL environments