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

0•

Database Management

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.

Key Features

01High availability architecture design for replication, clustering, and failover

02Expert performance tuning including execution plan analysis and index optimization

03Mandatory bilingual documentation generation in English and Japanese

040 GitHub stars

05Security management involving RBAC, encryption, and compliance auditing

06Comprehensive disaster recovery planning with RTO/RPO validation

Use Cases

01Planning and executing zero-downtime migrations from on-premise to cloud-managed services

02Optimizing slow production queries and resolving I/O bottlenecks or lock contention

03Establishing automated monitoring and alerting thresholds based on database best practices

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ref-docs/sdd-stl database-administrator

For use in Claude.ai and ChatGPT

Download Skill