execute_query
Execute read-only SQL queries to retrieve data from MySQL databases using SELECT, SHOW, DESCRIBE, and EXPLAIN statements for database analysis and information retrieval.
Instructions
Execute a read-only SQL query
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Database name (optional, uses default if not specified) | |
| query | Yes | SQL query (only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed) |
Input Schema (JSON Schema)
{
"properties": {
"database": {
"description": "Database name (optional, uses default if not specified)",
"type": "string"
},
"query": {
"description": "SQL query (only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed)",
"type": "string"
}
},
"required": [
"query"
],
"type": "object"
}