select_records
Retrieves records from a MySQL table using simple filters (equality, IN, IS NULL), ordering, and pagination. For joins or aggregations, use run_query.
Instructions
Consulta registros de una tabla con filtros simples (igualdad / IN / IS NULL), orden y paginación. Para joins o agregaciones usa run_query.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table": "<table>"
},
"name": "select_records"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| table | Yes | ||
| where | No | Condiciones unidas por AND. {"id": 5} => id = 5; {"estado": ["a","b"]} => IN; {"borrado": null} => IS NULL | |
| offset | No | ||
| columns | No | Por defecto todas (*) | |
| orderBy | No | ||
| database | No | Base de datos a usar (por defecto la actual de la conexión activa) |