skills.rest
beelabstudio
beelabstudioOFFICIAL
Explore all skills by this author →
GitHub

dba

Administers database systems covering schema design, query optimization, backups, and high availability.

Updated Mar 14, 2026
Search Tags:#query optimization#database#postgresql#migration#backup#high availability#dba
One-click install
npx skills add https://github.com/beelabstudio/ai --skill dba-beelabstudio
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dba
Source: https://github.com/beelabstudio/ai/tree/main/skills/foundation/dba
Command: npx skills add https://github.com/beelabstudio/ai --skill dba-beelabstudio

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Database systems require continuous administration to stay performant, secure, and recoverable, and teams often lack structured guidance for schema design, query tuning, migrations, and disaster recovery planning. ## Core Features & Use Cases - Schema Design & Query Optimization: Design database schemas and optimize queries and indexes across PostgreSQL, MySQL, Oracle, SQL Server, and NoSQL systems like MongoDB and Redis. - Backup & Disaster Recovery: Implement backup strategies with tools like pg_dump, mysqldump, and Percona XtraBackup, plus replication and clustering for high availability. - Use Case: When planning a database version upgrade, use this Skill to produce a migration plan covering capacity assessment, backup verification, rollback procedures, and post-migration performance monitoring with Prometheus and Grafana. ## Quick Start Ask the AI to act as a DBA and review your PostgreSQL schema for indexing and performance improvements.

Frequently Asked Questions about dba

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow database queries?▼

Query optimization starts with analyzing execution plans and adding appropriate indexes on filtered and joined columns. This Skill covers index tuning and query rewriting across PostgreSQL, MySQL, Oracle, and SQL Server.

How to plan a database backup and recovery strategy?▼

A backup strategy combines scheduled dumps using tools like pg_dump, mysqldump, or Percona XtraBackup with tested restore procedures and disaster recovery plans. Retention policies and recovery time objectives should be documented.

PostgreSQL vs MongoDB for a new application?▼

PostgreSQL suits relational data with complex transactions and integrity constraints, while MongoDB fits flexible document schemas and horizontal scaling. This Skill covers administration of both RDBMS and NoSQL systems.

How do I set up database high availability?▼

High availability is achieved through replication and clustering, such as PostgreSQL streaming replication or MySQL replicas, combined with failover procedures. Monitoring with Prometheus and Grafana detects node failures early.

What tools monitor database performance?▼

Common monitoring tools include Prometheus, Grafana, and Datadog for metrics and alerting, plus pgAdmin, MySQL Workbench, and DataGrip for administration. Automation scripts in Bash or Python handle routine checks.

Related Skills

Explore More Software Engineering Skills→
zizzfizzixzizzfizzix

data-model-design

Design data models, entities, and their relationships for software and database systems.

Community
Advanced
FalkorDBFalkorDB
22

Run server-only for production-style usage

Deploy FalkorDB server-only containers without the browser interface.

Official
Basic
JhabbigJhabbig

grafana-dashboards

Design Grafana dashboards for Prometheus metrics with variables and alerting.

Community
Advanced
cheesejaguarcheesejaguar
7

neon-postgres

Configure and operate Neon Serverless Postgres with pooled or direct connections.

Community
Advanced