createDataChangeOrder

Execute SQL changes in databases using a structured data change order, returning an order ID for tracking. Use this tool for authorized SQL executions when instructed, ensuring databaseId is retrieved via getDatabase or searchDatabase.

Instructions

Execute SQL changes through a data change order, and a corresponding order ID will be returned. Prefer using the executeScript tool for SQL execution; only use this tool when explicitly instructed to perform the operation via a order.If you don't know the databaseId, first use getDatabase or searchDatabase to retrieve it.(1)If you have the exact host, port, and database name, use getDatabase.(2)If you only know the database name, use searchDatabase.(3)If you don't know any information, ask the user to provide the necessary details.Note: searchDatabase may return multiple databases. In this case, let the user choose which one to use.

Input Schema

Name	Required	Description
`database_id`	Yes	Required DMS databaseId. Obtained via getDatabase tool
`logic`	No	Whether to use logical execution mode
`script`	Yes	SQL script to execute

Input Schema (JSON Schema)

{
  "properties": {
    "database_id": {
      "description": "Required DMS databaseId. Obtained via getDatabase tool",
      "title": "Database Id",
      "type": "string"
    },
    "logic": {
      "default": false,
      "description": "Whether to use logical execution mode",
      "title": "Logic",
      "type": "boolean"
    },
    "script": {
      "description": "SQL script to execute",
      "title": "Script",
      "type": "string"
    }
  },
  "required": [
    "database_id",
    "script"
  ],
  "title": "create_data_change_order_wrapperArguments",
  "type": "object"
}

Alibaba Cloud DMS MCP Server