insert_record
Add a new record to a NocoDB table by specifying the base ID, table name, and data to insert.
Instructions
Insert a single record into a table
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| base_id | Yes | The ID of the base/project | |
| table_name | Yes | The name of the table | |
| data | Yes | The record data to insert |
Implementation Reference
- src/tools/record.ts:27-44 (handler)Handler function for the 'insert_record' MCP tool. Receives NocoDBClient and input arguments, calls client.createRecord to insert the record into the specified table, and returns the created record with a success message.
handler: async ( client: NocoDBClient, args: { base_id: string; table_name: string; data: any; }, ) => { const record = await client.createRecord( args.base_id, args.table_name, args.data, ); return { record, message: "Record inserted successfully", }; }, - src/tools/record.ts:8-26 (schema)Input schema for the 'insert_record' tool, defining properties for base_id (string), table_name (string), and data (object), all required.
inputSchema: { type: "object", properties: { base_id: { type: "string", description: "The ID of the base/project", }, table_name: { type: "string", description: "The name of the table", }, data: { type: "object", description: "The record data to insert", additionalProperties: true, }, }, required: ["base_id", "table_name", "data"], }, - src/index.ts:55-62 (registration)Registration of recordTools (containing 'insert_record') by spreading into the allTools array, which is used in ListToolsRequestSchema and CallToolRequestSchema handlers for listing and executing MCP tools.
const allTools = [ ...databaseTools, ...tableTools, ...recordTools, ...viewTools, ...queryTools, ...attachmentTools, ];