execute_query
Run SQL queries like SELECT, SHOW, DESCRIBE, and EXPLAIN on MariaDB/MySQL databases with secure, read-only access through MariaDB MCP Server.
Instructions
Execute a 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"
}