skills.rest
pierreribeiro
pierreribeiroCOMMUNITY
Explore all skills by this author →
GitHub

database-expert

Guide DBA tasks across Oracle, PostgreSQL, MySQL, SQL Server, and BigQuery.

Updated Oct 13, 2025
Search Tags:#monitoring#database#migration#PostgreSQL#MySQL#Oracle#DBA
One-click install
npx skills add https://github.com/pierreribeiro/myclaudemd --skill database-expert-pierreribeiro
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-expert
Source: https://github.com/pierreribeiro/myclaudemd/tree/main/skills/personas/database-expert
Command: npx skills add https://github.com/pierreribeiro/myclaudemd --skill database-expert-pierreribeiro

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a Database Reliability Engineer persona to guide DBA tasks with risk-aware automation, ensuring consistent planning, monitoring, and rollback readiness across Oracle, PostgreSQL, SQL Server, MySQL, and BigQuery.

Core Features & Use Cases

  • Activation & Persona: Activate via @Database expert@ or @DBA mode@ to adopt a production-grade DB operations mindset.
  • Automation & Recovery: Deliver automation-friendly guidance with rollback procedures and downtime estimates for maintenance windows.
  • Use Case: Tuning configurations, performing migrations, and ensuring high availability for mission-critical databases.

Quick Start

Activate the Database Reliability Engineer persona by using the TAGs or keywords, and request monitoring and rollback-ready guidance.

Frequently Asked Questions about database-expert

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

FAQPage Schema
How do I automate PostgreSQL and MySQL database migrations with rollback procedures?▼

Automate database migrations by activating a Database Reliability Engineer persona that delivers automation-first guidance with rollback procedures and downtime estimates for PostgreSQL, MySQL, Oracle, SQL Server, and BigQuery maintenance windows.

What is the best approach for performance tuning and high availability across multiple database systems?▼

Performance tuning and high availability across Oracle, PostgreSQL, MySQL, SQL Server, and BigQuery are best approached through a risk-aware automation mindset that ensures consistent planning and monitoring-ready responses.

Can I use a single DBA persona for Oracle, BigQuery, and SQL Server reliability tasks?▼

Yes, you can use a single Database Reliability Engineer persona for Oracle, BigQuery, and SQL Server to guide DBA tasks including configuration tuning, migrations, and high availability setup.

How do I ensure monitoring and rollback readiness during database maintenance windows?▼

Ensure monitoring and rollback readiness during database maintenance by applying production-grade operations guidance that requires monitoring-ready responses and downtime estimates for every automated task.

Related Skills

Explore More Data & Analytics Skills→
clinecline
19

oracledb

Automate Oracle database administration and monitoring with parameterized SQL queries.

Official
Intermediate
skinred78skinred78
1

databases

Design schemas, write queries, and administer MongoDB and PostgreSQL databases.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

monitoring-database-health

Monitor PostgreSQL and MySQL database health with real-time metrics and alerts.

Community
Advanced
semicolon-devteamsemicolon-devteam

supabase

Create and validate Supabase database schemas, RLS policies, and migrations.

Official
Advanced