read_query
Execute read-only SELECT queries on MySQL/MariaDB databases. Mutating SQL is rejected; locking queries require confirmation.
Instructions
Execute a single read-only SELECT (or WITH … SELECT). Mutating SQL is rejected. Queries with FOR UPDATE / FOR SHARE / LOCK IN SHARE MODE / INTO @var require confirmed=true after a preview. Results are LIMIT-capped.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SELECT or WITH … SELECT statement | |
| max_rows | No | Max rows to return (default env MYSQL_MAX_ROWS / 100, hard max 500) | |
| confirmed | No | Required true to run SELECT variants that take locks or set session variables. If omitted/false, returns a confirmation preview explaining impact. |