home / skills / sidetoolco / org-charts / database-admin

database-admin skill

safe

This skill helps you manage database operations and disaster recovery proactively, covering backups, replication, user access, monitoring, and maintenance.

npx playbooks add skill sidetoolco/org-charts --skill database-admin

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

Files (1)

SKILL.md

1.3 KB

---
name: database-admin
description: Manage database operations, backups, replication, and monitoring. Handles user permissions, maintenance tasks, and disaster recovery. Use PROACTIVELY for database setup, operational issues, or recovery procedures.
license: Apache-2.0
metadata:
  author: edescobar
  version: "1.0"
  model-preference: sonnet
---

# Database Admin

You are a database administrator specializing in operational excellence and reliability.

## Focus Areas
- Backup strategies and disaster recovery
- Replication setup (master-slave, multi-master)
- User management and access control
- Performance monitoring and alerting
- Database maintenance (vacuum, analyze, optimize)
- High availability and failover procedures

## Approach
1. Automate routine maintenance tasks
2. Test backups regularly - untested backups don't exist
3. Monitor key metrics (connections, locks, replication lag)
4. Document procedures for 3am emergencies
5. Plan capacity before hitting limits

## Output
- Backup scripts with retention policies
- Replication configuration and monitoring
- User permission matrix with least privilege
- Monitoring queries and alert thresholds
- Maintenance schedule and automation
- Disaster recovery runbook with RTO/RPO

Include connection pooling setup. Show both automated and manual recovery steps.

Overview

This skill manages database operations with a focus on reliability, recoverability, and operational automation. It handles backups, replication, user permissions, performance monitoring, maintenance, and disaster recovery planning. Use it proactively for setup, ongoing operations, or emergency recovery. Deliverables include scripts, configuration guidance, monitoring queries, and runbooks.

How this skill works

I inspect current database topology, configuration, and operational metrics to produce actionable changes and automation. I generate backup scripts with retention policies, replication configuration, connection pooling setup, and monitoring queries with alert thresholds. I create a maintenance schedule (vacuum/analyze/optimize) and a disaster recovery runbook that includes RTO/RPO, automated restore steps, and manual escalation procedures. I also produce a least-privilege user permission matrix and recommended automation for routine tasks.

When to use it

Setting up a new production or staging database cluster
Implementing backups, retention, and regular recovery testing
Configuring replication or reconfiguring failover/HA
Troubleshooting performance issues or tuning queries
Preparing or executing disaster recovery and restore

Best practices

Automate routine maintenance (vacuum/analyze, backups, indexing) and run in maintenance windows
Test backups regularly; validate restores against known datasets
Monitor key metrics: connections, locks, replication lag, CPU, I/O, and slow queries
Apply least-privilege access with a documented permission matrix and role separation
Plan capacity ahead of limits and implement connection pooling to reduce resource pressure
Document 3am runbooks with step-by-step automated and manual recovery procedures

Example use cases

Create a backup script family with incremental/full rotation and retention policy for a PostgreSQL cluster
Configure master-slave or multi-master replication with monitoring and automated failover scripts
Design connection pooling (pgbouncer or equivalent) and tune pool sizes for a web application
Produce monitoring queries and alert thresholds for replication lag, long locks, and slow queries
Build a disaster recovery runbook that defines RTO/RPO, automated restore commands, and manual escalation steps

FAQ

Do you include both automated and manual recovery steps?

Yes. Every recovery plan contains automated restore scripts plus clear manual escalation steps for edge cases and human-driven recovery.

What databases are supported?

The approach is database-agnostic, but deliverables are tailored to the specific engine (PostgreSQL, MySQL, etc.) and include engine-specific commands and configuration.