insert_query
Adds a single new record to a table. Commits automatically and requires a writable connection.
Instructions
Insert a single row into a table. Commits automatically. Only available on writable connections (readonly=false in list_schemas). Returns the number of rows inserted.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name, e.g. 'AD_TABELA' or 'SCHEMA.TABELA'. | |
| values | Yes | Column-value pairs, e.g. {"NOME": "João", "CODIGO": 10}. | |
| connection | No | Connection name from list_schemas. Must have readonly=false. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |