How does this skill handle project-specific technical constraints?

The skill is integrated with a 'Project Memory' steering system that forces it to read English architecture and technology stack files before proposing any changes.

Which database systems are supported by this skill?

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

Can it assist with security compliance?

Yes, it includes expertise in access control, vulnerability management, and ensuring alignment with standards like GDPR, PCI-DSS, and HIPAA.

Can it help with urgent performance issues?

Yes, it provides specialized flows for slow log analysis, bottleneck identification, and parameter tuning to resolve immediate performance degradation.

Does it support automated documentation in multiple languages?

Absolutely. It follows a strict policy of creating and referencing both English and Japanese versions of all operational documents and reports.

Database Administrator

Name: Database Administrator
Author: ref-docs

byref-docs

数据库管理

Manages database operations, performance tuning, and high availability configurations through expert guidance and structured analysis.

关于

The Database Administrator skill transforms Claude into a specialized DBA agent capable of handling the entire database lifecycle. It provides expert assistance with complex tasks such as SQL query optimization, backup/recovery strategy design, security auditing, and cross-platform migrations. Supporting both RDBMS and NoSQL systems across on-premise and cloud environments, it follows a structured 5-phase dialogue flow to ensure technical accuracy and project consistency while maintaining mandatory bilingual documentation standards.

主要功能

High availability architecture design for replication, clustering, and failover
Expert performance tuning including execution plan analysis and index optimization
Mandatory bilingual documentation generation in English and Japanese
0 GitHub stars
Security management involving RBAC, encryption, and compliance auditing
Comprehensive disaster recovery planning with RTO/RPO validation

使用场景

Planning and executing zero-downtime migrations from on-premise to cloud-managed services
Optimizing slow production queries and resolving I/O bottlenecks or lock contention
Establishing automated monitoring and alerting thresholds based on database best practices

关于

主要功能

High availability architecture design for replication, clustering, and failover
Expert performance tuning including execution plan analysis and index optimization
Mandatory bilingual documentation generation in English and Japanese
0 GitHub stars
Security management involving RBAC, encryption, and compliance auditing
Comprehensive disaster recovery planning with RTO/RPO validation

使用场景

Planning and executing zero-downtime migrations from on-premise to cloud-managed services
Optimizing slow production queries and resolving I/O bottlenecks or lock contention
Establishing automated monitoring and alerting thresholds based on database best practices