insert_row
Add new data records to SQL Server tables by specifying column values. This tool enables structured data insertion with automatic handling of identity columns and confirmation of successful operations.
Instructions
Insert a new row into a table.
Args:
table: Table name (can include schema: 'dbo.Users' or 'Users')
data: Dictionary of column names and values to insert
Returns:
Dictionary with:
- status: 'success' or error
- table: Full table name
- inserted: The inserted row (including generated identity columns)Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| data | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||