skills.rest
acedergren
acedergrenCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/acedergren/oracle-dba-skill --skill oracle-dba
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
Snowflake-LabsSnowflake-Labs
1

oracle-connection

Configure and verify Oracle database connections for schema extraction.

Official
Intermediate
ryan-nguyen-01ryan-nguyen-01
4

skill-arch-disaster-recovery

Standardize disaster recovery planning with RTO/RPO tiers and runbooks.

Community
Advanced
fabiolpgomesfabiolpgomes

aiox-data-engineer

Architect PostgreSQL and Supabase schemas with migrations, RLS policies, and query tuning workflows.

Community
Advanced
CoreStack-EnggCoreStack-Engg

cloud-oci

Design Oracle Cloud Infrastructure tenancy, compartments, and IAM policies with Terraform.

Official
Intermediate