patchRule
Update an existing database access rule by providing its ID and optionally changing priority, match conditions, or access level.
Instructions
Update existing rule(s).
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": {
"id": "<id>"
},
"name": "patchRule"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| id | Yes | Rule id. If omitted, an id is generated. | |
| priority | No | Rules are evaluated by priority (highest first). First match is applied. | |
| username | No | Match by user name (requesting user). | |
| service | No | Match by service. | |
| request | No | Match by request type. | |
| table | No | Match by table name(s). | |
| iprange | No | Match by source IP range (CIDR). | |
| schema | No | Match by schema name(s). | |
| access | No | Access level the rule grants. | |
| filter | No | Filter for 'limit' access (SQL WHERE clause). |