insert_record
Insert a record into a SQL Server table by specifying the table name, optional schema, and a dictionary of column names and values. Simplifies data creation with direct, table-specific input.
Instructions
Insert a single record into a database table (Create).
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | Dictionary mapping column names to values (e.g., {"first_name": "John", "age": 30}). | |
| table_name | Yes | Target table name. | |
| schema_name | No | Target schema name (default: 'dbo'). | dbo |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||