Execute SELECT Query
mysql_queryExecute read-only SELECT queries against MySQL databases using parameter binding and output as JSON or markdown.
Instructions
Execute a read-only SELECT query against MySQL.
Only SELECT and SHOW/EXPLAIN statements are permitted. Use mysql_execute for write operations.
Args:
sql (string, required): SQL SELECT statement. Use ? placeholders for params.
params (array, optional): Bind parameters corresponding to ? placeholders.
database (string, optional): Database name. Uses MYSQL_DATABASE if omitted.
limit (number, optional): Max rows to return (default: 100, max: 1000).
response_format ('markdown' | 'json'): Output format (default: 'json')
Returns:
json: { rows: object[], count: number, has_more: boolean }
markdown: formatted table
Examples:
sql: "SELECT * FROM biz_exhaust_yg WHERE jcrq = ? LIMIT 10", params: ["2026-03"]
sql: "SELECT COUNT(*) as cnt FROM biz_exhaust_hy"
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | SELECT SQL statement. Use ? for bind parameters. | |
| params | No | Bind parameters for ? placeholders | |
| database | No | Database name (uses MYSQL_DATABASE env var if omitted) | |
| limit | No | Maximum rows to return (default 100) | |
| response_format | No | Output format: 'markdown' or 'json' | json |