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 | Default |
|---|---|---|---|
| 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"
}