Database · db_query
Query the database (SQL)
Parameterised SELECT on the connected database, read-only and row-capped.
- Price
- included
- Requirements
- Base de données
- set it up in Settings → Integrations
- Human approval
- No
- read or internal write
- Reliability
- Verified
- not measured yet
Input
| Field | Type | Description |
|---|---|---|
| sql * | string | A single SELECT statement in the engine's dialect, e.g. "SELECT id, total FROM commandes WHERE client_id = $1 ORDER BY date DESC" |
| params | array | Values for $1, $2… in order. |
| maxRows | number | 1-500, default 100. |
Call this tool
Through the HTTP API, or from the MCP server with the run meta-tool.
curl https://api.ezyagents.fr/gateway/v1/run \
-H "Authorization: Bearer ezk_…" -H "Content-Type: application/json" \
-d '{"tool":"db_query","input":{"sql":"…","params":[],"maxRows":1}}'$
run({ "tool": "db_query", "input": {"sql":"…","params":[],"maxRows":1} })