home / skills / shaul1991 / shaul-agents-plugin / dba-admin

dba-admin skill

safe

This skill helps you manage database operations including backup, security, and permissions, with scripts and policies organized for reliable maintenance.

npx playbooks add skill shaul1991/shaul-agents-plugin --skill dba-admin

Review the files below or copy the command above to add this skill to your agents.

Files (1)

SKILL.md

436 B

---
name: dba-admin
description: DBA Admin Agent. 백업, 복구, 보안, 권한 관리를 담당합니다.
allowed-tools: Read, Write, Edit, Bash, Grep, Glob
---

# DBA Admin Agent

## 역할
데이터베이스 운영 및 관리를 담당합니다.

## 담당 업무
- 백업/복구
- 보안 설정
- 권한 관리
- 모니터링

## 산출물 위치
- 백업 스크립트: `scripts/backup/`
- 보안 정책: `docs/database/security/`

Overview

This skill provides a DBA Admin Agent that handles core database operations for production and staging environments. It focuses on reliable backups and recovery, security configuration, access control, and day-to-day monitoring. The agent produces executable backup scripts and concise security policy documents for easy integration.

How this skill works

The agent automates scheduled and on-demand backups, validates backups, and orchestrates recovery procedures. It applies and enforces database security settings, manages user roles and privileges, and continuously monitors health metrics and alerts. Outputs include backup scripts and written security policies placed in accessible locations for operators.

When to use it

When you need automated, consistent backups and tested recovery workflows
When enforcing or auditing database security policies across instances
When managing user roles, permissions, and least-privilege enforcement
When setting up monitoring and alerting for database health and performance
During maintenance windows or incident response for recovery and access tasks

Best practices

Schedule regular full and incremental backups and test restores on a separate system
Maintain clear, versioned security policy documents and apply them via automated configuration tools
Grant roles and privileges using least-privilege principles and review periodically
Monitor key metrics (replication lag, slow queries, disk usage) and configure threshold alerts
Keep backup scripts and policy docs in an access-controlled location and log all admin actions

Example use cases

Run nightly incremental backups and weekly full backups with automated retention policies
Perform a point-in-time recovery after accidental data deletion using validated backup scripts
Apply a hardened security template across development and production databases
Revoke a compromised user’s credentials and rotate affected secrets while maintaining service availability
Set up monitoring dashboards and alerts for slow queries and replication issues

FAQ

Where are the backup scripts and policies located?

Backup scripts are organized under scripts/backup/ and security policies under docs/database/security/ for easy access and review.

Does the agent perform automatic restores or require operator approval?

The agent supports automated restores for predefined scenarios but can be configured to require operator approval for production recoveries to prevent accidental data changes.