oracle-dba

Streamline Oracle Autonomous Database administration tasks for OCI deployments.

4|Updated Dec 22, 2025

Search Tags:#automation #security #sql #oracle #oci #adb #dr

Ready to run

npx skills add https://github.com/acedergren/oracle-dba-skill --skill oracle-dba

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: oracle-dba
Source: https://github.com/acedergren/oracle-dba-skill/tree/main
Command: npx skills add https://github.com/acedergren/oracle-dba-skill --skill oracle-dba

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Oracle DBAs and DevOps teams struggle to manage Oracle Autonomous Database (ADB) on OCI, including performance tuning, security hardening, HA/DR planning, and automation via OCI CLI and MCP servers.

Core Features & Use Cases

Guidance for production DBA tasks: performance tuning (AWR/ADDM), backup/recovery, patching, monitoring
Security hardening: TDE, Database Vault, Data Safe, unified auditing, SQL Firewall
HA/DR enablement: Autonomous Data Guard, PITR, DR runbooks, refreshable clones
OCI CLI automation and MCP server integration for AI-assisted database operations
Use Case: streamline provisioning, security policy application, and cross-region DR testing across multiple ADBs

Quick Start

Load this skill into Claude Code and start asking for Oracle Autonomous Database guidance.

Frequently Asked Questions about oracle-dba

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

FAQPage Schema

How do I automate Oracle Autonomous Database administration tasks on OCI?▼

Oracle Autonomous Database administration on OCI can be automated using OCI CLI and MCP server integration. This skill provides deterministic, context-aware guidance for provisioning, security policy application, and AI-assisted database operations.

What is the best way to plan HA/DR for Oracle Autonomous Database across multiple regions?▼

HA/DR planning for Oracle Autonomous Database involves configuring Autonomous Data Guard, Point-in-Time Recovery (PITR), and refreshable clones. This skill delivers DR runbooks and cross-region testing guidance for multi-ADB environments.

How do I harden security on an Oracle Autonomous Database using Data Safe and Database Vault?▼

Security hardening on Oracle Autonomous Database utilizes Transparent Data Encryption (TDE), Database Vault, Data Safe, unified auditing, and SQL Firewall. This skill provides guidance for applying these security policies safely.

Can I use OCI CLI for performance tuning and patching Oracle ADB instances?▼

OCI CLI supports Oracle Autonomous Database performance tuning via AWR/ADDM analysis, alongside backup, recovery, patching, and monitoring workflows. This skill offers deterministic guidance for these production DBA tasks.

Does this Oracle DBA guidance work with MCP server integration for AI-assisted operations?▼

Yes, this Oracle DBA guidance supports MCP server integration for AI-assisted database operations. It delivers auditable operations using YAML frontmatter metadata and linked references for safe execution within real-world DBA workflows.