NocoDB MCP Server

Instructions

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,
  ];