execute
Run INSERT, UPDATE, or DELETE queries on MySQL databases. Provide SQL statements and optional parameters for precise database modifications using a secure connection.
Instructions
Execute an INSERT, UPDATE, or DELETE query
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | No | An optional array of parameters (as strings) to bind to the SQL query placeholders (e.g., ?). | |
| sql | Yes | The SQL query string (INSERT, UPDATE, DELETE) to execute. |
Input Schema (JSON Schema)
{
"properties": {
"params": {
"description": "An optional array of parameters (as strings) to bind to the SQL query placeholders (e.g., ?).",
"items": {
"description": "A parameter value (as string) to bind to the query.",
"type": "string"
},
"optional": true,
"type": "array"
},
"sql": {
"description": "The SQL query string (INSERT, UPDATE, DELETE) to execute.",
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
}