MySQL Query
mysql_queryExecute read-only SQL queries on MySQL databases through environment-based routing with security constraints. Configure environments like dev or prod_ro, run single statements, and manage execution limits.
Instructions
Run one read-only SQL statement on a configured MySQL environment.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| env | Yes | Environment alias such as dev, stg, or prod_ro. | |
| database | No | Optional database override allowed by server policy. | |
| sql | Yes | One read-only SQL statement. | |
| limit | No | Requested row limit. The server may clamp it. | |
| timeoutMs | No | Requested execution timeout in milliseconds. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ok | Yes | ||
| env | Yes | ||
| rows | Yes | ||
| columns | Yes | ||
| database | No | ||
| rowCount | Yes | ||
| elapsedMs | Yes | ||
| truncated | Yes | ||
| limitApplied | Yes | ||
| statementType | Yes |