What is the DBA skill and how does it operate?

It is a role that guides database management work and relies on associated skills to perform concrete tasks. It cannot perform tasks directly; the capability resides in the linked skills.

Which databases are covered?

Relational databases like PostgreSQL and MySQL, and NoSQL databases like MongoDB.

What are common responsibilities?

Performance tuning, backups and disaster recovery, replication and high availability, monitoring, maintenance, and migration related tasks.

Dba

Scanned

npx machina-cli add skill javalenciacai/develop-skills/dba --openclaw

Files (1)

SKILL.md

2.7 KB

DBA - Database Administrator

Role

Manages and optimizes databases. Reports to InfraLead.

Responsibilities

Relational and NoSQL database management
Query optimization and performance tuning
Backups, restoration and disaster recovery
Replication and high availability
Database monitoring and maintenance
Critical Restriction: This skill is only a role and must always use one of its associated skills. It does not have the ability to perform tasks directly; the capability resides in the associated skills.

Base Skills

# Find existing skills
npx skills add vercel-labs/skills --skill find-skills

# Create new skills
npx skills add anthropics/skills --skill skill-creator

Current Skills

Base Skills (All DBAs)

Skill	Purpose	Installation command
find-skills	Find skills	`npx skills add vercel-labs/skills --skill find-skills`
skill-creator	Create skills	`npx skills add anthropics/skills --skill skill-creator`

Database Management Skills 🔴 High Priority

Skill	Purpose	Installation command
doc-coauthoring	Database documentation, schema docs, backup procedures, disaster recovery plans	`npx skills add anthropics/skills --skill doc-coauthoring`
xlsx	Database inventory, performance metrics, backup schedules, query optimization logs	`npx skills add anthropics/skills --skill xlsx`

Analysis and Communication Skills 🟡 Medium Priority

Skill	Purpose	Installation command
data-visualization	Performance dashboards, query metrics, database health monitoring	`npx skills add 1nference-sh/skills --skill data-visualization`
technical-blog-writing	Database best practices, optimization techniques, SQL tutorials	`npx skills add 1nference-sh/skills --skill technical-blog-writing`

Rule: Add Used Skills

Every time you use a new skill, add it to the "Current Skills" table.

Examples of skills to search for:

npx skills find database
npx skills find sql
npx skills find mongodb

Source

git clone https://github.com/javalenciacai/develop-skills/blob/main/.agents/skills/dba/SKILL.mdView on GitHub

Overview

DBA manages and optimizes databases across relational and NoSQL systems, including performance tuning, backups, replication, and maintenance. It is a role that delegates concrete tasks to associated skills rather than acting directly.

How This Skill Works

As a role, DBA coordinates tasks through its associated skills (for example doc-coauthoring for documentation, data-visualization for dashboards, and technical-blog-writing for best practices). It does not perform tasks by itself; it orchestrates database administration, backups, replication, and monitoring via those skills.

When to Use It

Database administration for PostgreSQL, MySQL, or MongoDB
Query optimization or performance tuning to reduce latency
Backup strategies or disaster recovery planning and tests
Replication or high availability setup and failover testing
Schema design or migration scripting to evolve your data model

Quick Start

Step 1: Identify the target databases and select an associated skill to execute core tasks (eg doc-coauthoring, data-visualization).
Step 2: Establish a baseline of performance and backups by running appropriate checks and collecting metrics.
Step 3: Implement monitoring and backup routines and schedule regular restore tests

Best Practices

Define recovery objectives and maintain tested backup and restore procedures
Regularly analyze slow queries and implement indexing or schema changes with proper testing
Document schema changes and migrations using the doc-coauthoring approach
Implement replication with monitoring dashboards and alerting
Establish continuous health checks and secure access controls and auditing

Example Use Cases

Upgrade a PostgreSQL cluster with a controlled migration script
Configure a MongoDB replica set with automatic failover and monitoring
Run backups with point-in-time recovery tests and verify restorations
Analyze a slow query and create composite indexes to improve latency
Create a database health dashboard using data-visualization metrics

Frequently Asked Questions

Add this skill to your agents