OCI MCP Server

Instructions

List all Autonomous Databases in a compartment.

Args:
    compartment_id: OCID of the compartment to list Autonomous Databases from

Returns:
    List of Autonomous Databases with their configuration, workload type, and connection info

Implementation Reference

• mcp_server_oci/tools/database.py:196-248 (handler)

  Core implementation of the list_autonomous_databases tool handler. Uses OCI DatabaseClient to fetch and paginate autonomous databases, extracts relevant fields into structured dicts, and handles errors.

  def list_autonomous_databases(database_client: oci.database.DatabaseClient, compartment_id: str) -> List[Dict[str, Any]]:
      """
      List all autonomous databases in a compartment.
      
      Args:
          database_client: OCI Database client
          compartment_id: OCID of the compartment
          
      Returns:
          List of autonomous databases with their details
      """
      try:
          autonomous_databases_response = oci.pagination.list_call_get_all_results(
              database_client.list_autonomous_databases,
              compartment_id
          )
          
          autonomous_databases = []
          for adb in autonomous_databases_response.data:
              autonomous_databases.append({
                  "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,
              })
          
          logger.info(f"Found {len(autonomous_databases)} autonomous databases in compartment {compartment_id}")
          return autonomous_databases
          
      except Exception as e:
          logger.exception(f"Error listing autonomous databases: {e}")
          raise

• mcp_server_oci/mcp_server.py:1018-1033 (registration)

  MCP tool registration and wrapper handler for 'list_autonomous_databases'. Registers the tool with FastMCP, applies common error handling wrapper, and delegates to the core handler function with the OCI database client.

  @mcp.tool(name="list_autonomous_databases")
  @mcp_tool_wrapper(
      start_msg="Listing Autonomous Databases in compartment {compartment_id}...",
      error_prefix="Error listing Autonomous Databases"
  )
  async def mcp_list_autonomous_databases(ctx: Context, compartment_id: str) -> List[Dict[str, Any]]:
      """
      List all Autonomous Databases in a compartment.
  
      Args:
          compartment_id: OCID of the compartment to list Autonomous Databases from
  
      Returns:
          List of Autonomous Databases with their configuration, workload type, and connection info
      """
      return list_autonomous_databases(oci_clients["database"], compartment_id)

• mcp_server_oci/mcp_server.py:63-70 (helper)

  Import of the list_autonomous_databases helper function from tools/database.py into the main server module.

  from mcp_server_oci.tools.database import (
      list_db_systems as list_db_systems_dbpkg,  # alias to avoid name clash
      get_db_system as get_db_system_dbpkg,
      list_databases,
      get_database,
      list_autonomous_databases,
      get_autonomous_database,
  )