Database · db_execute
Write or run a process (SQL)
INSERT, UPDATE, DELETE or stored-procedure call on the connected database, in a capped transaction under human approval.
- Price
- included
- Requirements
- Base de données
- set it up in Settings → Integrations
- Human approval
- Yes, by default
- outside-facing write: a human validates
- Reliability
- Verified
- not measured yet
Input
| Field | Type | Description |
|---|---|---|
| sql * | string | One INSERT / UPDATE (with WHERE) / DELETE (with WHERE) / MERGE statement, or "CALL procedure($1)" / "EXEC dbo.Procedure @p1 = $1". |
| params | array | Values for $1, $2… in order. |
| maxAffectedRows | number | Rollback if more rows are affected. Default 100, max 5000. |
| reason | string | Why this change, shown to the human approver. |
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_execute","input":{"sql":"…","params":[],"maxAffectedRows":1,"reason":"…"}}'$
run({ "tool": "db_execute", "input": {"sql":"…","params":[],"maxAffectedRows":1,"reason":"…"} })