execute_sql
Execute non-SELECT SQL statements like ALTER TABLE, INSERT, UPDATE, or DELETE directly on a MySQL database using the MySQL MCP Server for database management tasks.
Instructions
Executes any non-SELECT SQL statement (e.g., ALTER TABLE, DROP, etc.)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | The SQL statement to execute. |
Input Schema (JSON Schema)
{
"properties": {
"query": {
"description": "The SQL statement to execute.",
"type": "string"
}
},
"required": [
"query"
],
"type": "object"
}