executeScript

Run SQL scripts on a database in Alibaba Cloud DMS and retrieve structured results. Use getDatabase or searchDatabase to obtain the databaseId if unknown. Supports logical execution mode for advanced query handling.

Instructions

Execute SQL script against a database in DMS and return structured results.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": "execute_script_full_wrapperArguments",
  "type": "object"
}

Alibaba Cloud DMS MCP Server

executeScript

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Alibaba Cloud DMS MCP Server

Related Tools

MCP directory API