mysql_query
Execute read-only SQL queries with positional parameters to retrieve data from MySQL databases. Supports SELECT, JOINs, aggregations, and EXPLAIN plans.
Instructions
Run a read-only SQL query with optional positional parameters. For complex queries or when you need JOINs, aggregations, or filtering. Results are limited to 10,000 rows; use LIMIT for large tables.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | A read-only SQL statement starting with SELECT, SHOW, DESCRIBE/DESC, EXPLAIN or WITH (select). Include LIMIT clause for large tables. | |
| params | No | Positional parameters for the query (use ? placeholders in SQL) |