faucet_insert
Insert one or more JSON records into a database table and return the inserted rows, including auto-generated IDs when supported. Requires POST permission on the target table.
Instructions
Insert one or more records into a database table. Each record is a JSON object mapping column names to values. Returns the inserted records (with auto-generated fields like IDs) if the database supports RETURNING. Requires POST permission on the table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Name of the table to insert into | |
| records | Yes | Array of record objects to insert (e.g. [{"name": "Alice", "age": 30}]) | |
| service | Yes | Name of the database service |