get_autonomous_database
Retrieve detailed information about an Oracle Cloud Infrastructure Autonomous Database, including connection strings, wallet details, and auto-scaling configuration settings.
Instructions
Get detailed information about a specific Autonomous Database.
Args:
autonomous_database_id: OCID of the Autonomous Database to retrieve
Returns:
Detailed Autonomous Database information including connection strings, wallet info, and auto-scaling settingsInput Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| autonomous_database_id | Yes |
Implementation Reference
- mcp_server_oci/tools/database.py:251-311 (handler)Core handler function that executes the tool logic: fetches the Autonomous Database details using OCI DatabaseClient.get_autonomous_database and formats them into a structured dictionary response.
def get_autonomous_database(database_client: oci.database.DatabaseClient, autonomous_database_id: str) -> Dict[str, Any]: """ Get details of a specific autonomous database. Args: database_client: OCI Database client autonomous_database_id: OCID of the autonomous database Returns: Details of the autonomous database """ try: adb = database_client.get_autonomous_database(autonomous_database_id).data adb_details = { "id": adb.id, "db_name": adb.db_name, "display_name": adb.display_name, "compartment_id": adb.compartment_id, "lifecycle_state": adb.lifecycle_state, "time_created": str(adb.time_created), "cpu_core_count": adb.cpu_core_count, "data_storage_size_in_tbs": adb.data_storage_size_in_tbs, "is_free_tier": adb.is_free_tier, "is_auto_scaling_enabled": adb.is_auto_scaling_enabled, "db_workload": adb.db_workload, "db_version": adb.db_version, "license_model": adb.license_model, "is_dedicated": adb.is_dedicated, "autonomous_container_database_id": adb.autonomous_container_database_id, "is_access_control_enabled": adb.is_access_control_enabled, "whitelisted_ips": adb.whitelisted_ips, "are_primary_whitelisted_ips_used": adb.are_primary_whitelisted_ips_used, "standby_whitelisted_ips": adb.standby_whitelisted_ips, "is_data_guard_enabled": adb.is_data_guard_enabled, "is_local_data_guard_enabled": adb.is_local_data_guard_enabled, "subnet_id": adb.subnet_id, "nsg_ids": adb.nsg_ids, "private_endpoint": adb.private_endpoint, "private_endpoint_label": adb.private_endpoint_label, "connection_strings": { "high": adb.connection_strings.high if adb.connection_strings else None, "medium": adb.connection_strings.medium if adb.connection_strings else None, "low": adb.connection_strings.low if adb.connection_strings else None, "dedicated": adb.connection_strings.dedicated if adb.connection_strings else None, } if adb.connection_strings else None, "connection_urls": { "sql_dev_web_url": adb.connection_urls.sql_dev_web_url if adb.connection_urls else None, "apex_url": adb.connection_urls.apex_url if adb.connection_urls else None, "machine_learning_user_management_url": adb.connection_urls.machine_learning_user_management_url if adb.connection_urls else None, "graph_studio_url": adb.connection_urls.graph_studio_url if adb.connection_urls else None, "mongo_db_url": adb.connection_urls.mongo_db_url if adb.connection_urls else None, } if adb.connection_urls else None, } logger.info(f"Retrieved details for autonomous database {autonomous_database_id}") return adb_details except Exception as e: logger.exception(f"Error getting autonomous database details: {e}") raise - mcp_server_oci/mcp_server.py:1036-1053 (registration)MCP tool registration via @mcp.tool decorator on the wrapper function mcp_get_autonomous_database, which delegates to the core handler after adding logging, profile checks, and error handling.
@mcp.tool(name="get_autonomous_database") @mcp_tool_wrapper( start_msg="Getting Autonomous Database details for {autonomous_database_id}...", success_msg="Retrieved Autonomous Database details successfully", error_prefix="Error getting Autonomous Database details" ) async def mcp_get_autonomous_database(ctx: Context, autonomous_database_id: str) -> Dict[str, Any]: """ Get detailed information about a specific Autonomous Database. Args: autonomous_database_id: OCID of the Autonomous Database to retrieve Returns: Detailed Autonomous Database information including connection strings, wallet info, and auto-scaling settings """ return get_autonomous_database(oci_clients["database"], autonomous_database_id)