query
Execute read-only SELECT queries on local MySQL databases to retrieve data for development. Specify database schema and use parameters for secure querying with results limited to 1000 rows.
Instructions
Run a read-only SELECT query against the local FO MySQL database. Only single SELECT statements are allowed; INSERT, UPDATE, DELETE, and DDL are rejected. Use the schema parameter to choose which database to run against (fo, oa, bo, cm, nepro), or use fully-qualified table names like oa.some_table. Results are capped at 1000 rows. Pass parameters via the params array using ? placeholders. CTEs (WITH ... SELECT) are not supported in v1.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | A single SELECT statement using ? placeholders for parameters. | |
| params | No | Positional parameters bound to ? placeholders. | |
| schema | No | Optional default schema for unqualified table names. |