execute
Run INSERT, UPDATE, or DELETE queries on MySQL databases using SQL strings and optional parameters. Designed for AI agents to interact with MySQL via MCP Server.
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"
}