query
Run SELECT queries on MySQL databases using SQL commands and optional parameters, enabling efficient data retrieval through the MCP-MySQL Server interface.
Instructions
Execute a SELECT 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 SELECT query string 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 SELECT query string to execute.",
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
}