database-administrator

Assess operational risks to database availability, backups, recovery, and permissions.

22|2|Updated Mar 24, 2026
One-click install
npx skills add https://github.com/jshsakura/awesome-opencode-skills --skill database-administrator-jshsakura
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-administrator
Source: https://github.com/jshsakura/awesome-opencode-skills/tree/main/skills/database-administrator
Command: npx skills add https://github.com/jshsakura/awesome-opencode-skills --skill database-administrator-jshsakura

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Use when a production database task requires safety-first operational review for availability, backups, recovery, permissions, or runtime health.

Core Features & Use Cases

  • Operational boundary mapping: identify control plane, data plane, and dependency edges to isolate risks.
  • Risk-focused recommendations: smallest safe changes that restore reliability while preserving security boundaries.
  • Maintenance & health guidance: advise on backups, replication, and performance with rollback options.

Quick Start

Describe your production database environment and I will assess safety and operability gaps.

Frequently Asked Questions about database-administrator

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

FAQPage Schema
How do I assess operational risks for production database maintenance?

Database recovery and backup validation involves checking backup integrity and testing restoration procedures against failure scenarios. The Skill provides explicit validation steps and safety guardrails to verify that recovery procedures restore reliability without compromising security boundaries.

What is the best way to configure high-availability for a production database?

Configuring high-availability requires identifying dependency edges and applying the smallest safe changes that preserve security boundaries. The Skill advises on replication and runtime health configurations while supplying rollback options to maintain production safety during failure scenarios.

How do I implement least-privilege access permissions for a database?

Implementing least-privilege access permissions involves evaluating the control plane and data plane to restrict permissions to the minimum necessary level. The Skill assesses permission models and provides explicit safety guardrails aligned with production security requirements.

Can I use this for planning a maintenance window with rollback options?

You can use this for planning maintenance windows as it evaluates runtime health and operational risks specific to the scheduled event. It delivers risk-focused recommendations with explicit validation steps and rollback options to ensure the database remains available and secure.

When do I need to isolate control plane and data plane risks in a database?

You need to isolate control plane and data plane risks when operational changes threaten database availability or security boundaries. The Skill maps these operational boundaries to identify dependency edges and assess failure scenarios, ensuring recommendations maintain production safety.