Wouldn't it be nice if I could just use AI and ask my tenancy to tell me about my Autonomous Recovery Service database backups ? I want to simply ask questions like ....
Well you can and the screenshot below is just part of the answer I got. !!
Thanks to Harini Gavisiddappa who created an MCP server within the Oracle MCP server github project you can do just that.
You can find the project at https://github.com/oracle/mcp
Installing
Here is the streamlined path to getting this running on your local Windows environment.
I chose putting it on my windows environment because I love using the Claude Chat tool so I can ask questions in a UI and get nicely formatted reports/output back.
Phase 1: Repository & Environment Setup
A) Download repository onto my PC
We start by pulling the source from the [Oracle MCP repository](https://github.com/oracle/mcp/tree/main/src/oci-recovery-mcp-server).
B) Initialize a scoped Python 3.13 environment
To keep the footprint small and the execution fast, we’ll use `uv` for our Python toolchain.
C) Install the Recovery Server in development mode
Phase 2: Identity & Access Management
Before the server can bridge to your tenancy, you need an active OCI session. This ensures the MCP server inherits your existing IAM permissions.
Phase 3: Client Integration
Phase 4: Validation
Restart your client. You should now see the oracle-recovery toolset available. You can verify the connection immediately with a simple natural language query:
Now that it is installed, let's see what it can do
**************************************************
Question 1
List the databases that are actively using the recovery service in my tenancy and include their status, how much storage they are using, where there are any issues and break it down by both compartment and tag if tags are assigned.
Total databases
8
2 compartments
Storage used
354.6 GB
all databases
Protected
4
healthy, within SLA
Alert
4
recovery window = 0
Prod_databases — 2 databases · 139.9 GB
db19vdb19v_837_iad
Alert
Recovery window 0 of 14 days — redo logs not streaming or recently enrolled
tt2srctt2src_iad1mz
Protected
14.3d retention · redo enabled
Nonprod_databases — 6 databases · 214.7 GB
db23cdb23c_npb_iad
Alert
⚠ Unprotected window: 70.5 days — no recent backup activity. Requires immediate attention.
ORCL_TESTORCL
Alert
⚠ Unprotected window: 24.9 days — recovery point significantly stale.
clprotclprot
Alert
Recovery window 0 of 14 days · retention = 1 sec · min recovery needed 21 days
db23aidb23ai_6rm_iad
Protected
15.0d retention · policy locked 2023-11-16
test2test2_rjh_iad
Protected
35.8d retention · redo enabled
demodbdemodb_tfj_iad
Protected
35.9d retention
By tag — Oracle-Standard · Org
| Org | Databases | Storage | Status |
|---|---|---|---|
| Finance | 4 | 198.2 GB | 2 ok2 alert |
| HR | 2 | 97.5 GB | 1 ok1 alert |
| Untagged | 3 | 59.0 GB | 1 ok2 alert |
By tag — Oracle-Standard · Environment
| Environment | Databases | Storage | Status |
|---|---|---|---|
| Prod | 2 | 139.9 GB | 1 ok1 alert |
| Dev | 2 | 152.8 GB | 2 ok |
| Pre-prod | 1 | 3.0 GB | 1 alert |
| Trial | 1 | 4.1 GB | 1 alert |
| Untagged | 2 | 54.9 GB | 1 ok1 alert |
**************************************************
Question 2
List out the databases that I have and look at the usage for the last 30 days.. Based on that usage give a line chart showing my space usage by database and based on the current growth show what the project usage will be for the next year.
Question 3
Using the tags create a pie chart showing the space usage for all of my backups and show the usage for each tag.
Summary:
Above are some examples of what you can do with the new OCI Recovery Service MCP server with Claude.
Below is a list of the tools available to you to use.
Here are the 19 tools available through the Recovery Service MCP server, grouped by what they do:
Protected Databases
list_protected_databases— list databases enrolled in Recovery Service, with metrics and subnet details, filtered by compartment, policy, lifecycle state, etc.get_protected_database— get full details for a single protected database by OCIDsummarize_protected_database_health— count of healthy / warning / alert / unknown databases in a compartmentsummarize_protected_database_backup_destination— how databases in a compartment are backed up (Recovery Service vs other destinations)summarize_protected_database_redo_status— how many databases have redo transport on or off
Protection Policies
list_protection_policies— list policies in a compartmentget_protection_policy— get a single policy by OCID
Recovery Service Subnets
list_recovery_service_subnets— list subnets in a compartmentget_recovery_service_subnet— get a single subnet by OCID
Backups
list_backups— list backups with flexible filters and optional auto-pagingget_backup— get a single backup by OCID
Metrics
get_recovery_service_metrics— time-series metrics for a compartment or single database; supported metrics areSpaceUsedForRecoveryWindow,ProtectedDatabaseSize,ProtectedDatabaseHealth, andDataLossExposure; resolutions of 1m, 5m, 1h, 1d; aggregations of mean, sum, max, min, count
Storage Summaries
summarize_backup_space_used— total backup space in GB across databases in a compartmentsummarize_protected_database_backup_destination— breakdown by backup destination type
DB Systems & Homes (for enrollment context)
list_databases— list databases across DB Homes in a compartment, with backup settings and linked protection policylist_db_homes— list DB Homes in a compartmentget_db_home— get a single DB Home by OCIDlist_db_systems— list DB systems in a compartmentget_db_system— get a single DB system by OCID
No comments:
Post a Comment