executeScript

Run SQL scripts on databases managed by Alibaba Cloud DMS to retrieve structured query results, including column names, row counts, and data mappings.

Instructions

         Execute SQL script against a database in DMS and return structured results.
      Parameters:
        database_id (int): Required DMS databaseId. Obtained via getDatabase tool.
        script (str): SQL script to execute.
      Returns:
        Dict[str, Any] containing:
            - RequestId (str): Unique request identifier
            - Results (List[Dict]): List of result sets from executed script:
                Each result set contains:
                    - ColumnNames (List[str]): Ordered list of column names
                    - RowCount (int): Number of rows returned
                    - Rows (List[Dict[str, str]]): List of rows with column name -> value mapping
                    - Success (bool): Whether this result set was successfully retrieved
        - Success (bool): Overall operation success status    

      

Input Schema

Name	Required	Description	Default
`database_id`	Yes
`logic`	No
`script`	Yes

Input Schema (JSON Schema)

{
  "properties": {
    "database_id": {
      "title": "Database Id",
      "type": "string"
    },
    "logic": {
      "default": false,
      "title": "Logic",
      "type": "boolean"
    },
    "script": {
      "title": "Script",
      "type": "string"
    }
  },
  "required": [
    "database_id",
    "script"
  ],
  "title": "executeScriptArguments",
  "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