insert_row
Insert structured data into a PostgreSQL table with optional column return. Specify table name, column-value pairs, and choose which columns to retrieve after insertion.
Instructions
Insert a single row into a PostgreSQL table.
Use this tool when you need one explicit insert with structured values.
table_name: table target, optionally schema-qualifiedrow: object mapping column names to valuesreturning_columns: optional list of columns to return viaRETURNING
Example:
table_name:sales.ordersrow:{ "customer_id": 10, "status": "new" }returning_columns:["order_id"]
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table_name | Yes | ||
| row | Yes | ||
| returning_columns | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||