getDatabase

Retrieve metadata for a specific database instance in Alibaba Cloud DMS by specifying host, port, and schema name. Supports Oracle SID for detailed database insights.

Instructions

      Retrieve detailed information about a specific database from DMS.
      This tool fetches metadata for a database instance in the DMS
based on connection parameters and schema name. Supports Oracle-specific SID specification.
If you don't know host port, please use searchDatabase tool instead.
      Parameters:
        host (str): Hostname or IP address of the database instance.
        port (str): Connection port number (valid range: 1-65535).
        schema_name (str): Name of the database schema.
        sid (Optional[str], optional): Required for Oracle like databases. Defaults to None.
     Returns:
        Dict[str, Any]: A dictionary containing database metadata with the following keys:
            - DatabaseId: Unique database identifier in DMS
            - SchemaName: Name of the database schema
            - DbType: Database Engine type    
            - InstanceAlias: Instance alias in DMS
            - InstanceId: Instance identifier in DMS
            - State: Current operational status
      

Input Schema

Name	Required	Description	Default
`host`	Yes
`port`	Yes
`schema_name`	Yes
`sid`	No

Input Schema (JSON Schema)

{
  "properties": {
    "host": {
      "title": "Host",
      "type": "string"
    },
    "port": {
      "title": "Port",
      "type": "string"
    },
    "schema_name": {
      "title": "Schema Name",
      "type": "string"
    },
    "sid": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Sid"
    }
  },
  "required": [
    "host",
    "port",
    "schema_name"
  ],
  "title": "getDatabaseArguments",
  "type": "object"
}

Alibaba Cloud DMS MCP Server

getDatabase

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Alibaba Cloud DMS MCP Server

Related Tools