NocoDB MCP Server

Instructions

Implementation Reference

• src/tools/table.ts:144-169 (handler)

  The handler function that implements the core logic of the 'create_table' tool. It uses the NocoDBClient to create a table with the given base_id, table_name, and columns, then returns the created table details.
  handler: async ( client: NocoDBClient, args: { base_id: string; table_name: string; columns: any[]; }, ) => { const table = await client.createTable( args.base_id, args.table_name, args.columns, ); return { table: { id: table.id, table_name: table.table_name, title: table.title, type: table.type, enabled: table.enabled, created_at: table.created_at, updated_at: table.updated_at, }, message: `Table '${table.title}' created successfully`, }; },
• src/tools/table.ts:82-143 (schema)

  The input schema for the 'create_table' tool, specifying required parameters base_id, table_name, and an array of columns with properties like title, uidt, dt, pk, etc., supporting various column types.
  inputSchema: { type: "object", properties: { base_id: { type: "string", description: "The ID of the base/project", }, table_name: { type: "string", description: "Name of the new table", }, columns: { type: "array", description: "Array of column definitions", items: { type: "object", properties: { title: { type: "string", description: "Column display name", }, column_name: { type: "string", description: "Column name in database", }, uidt: { type: "string", description: "UI Data Type - Basic: SingleLineText, LongText, Number, Decimal, Currency, Percent | Date/Time: Date, DateTime, Duration | Boolean: Checkbox | Select: SingleSelect, MultiSelect | Advanced: Attachment, JSON, Email, PhoneNumber, URL, Rating | Virtual/Computed: Formula, Rollup, Lookup, QrCode, Barcode | Relational: Link, Links", }, dt: { type: "string", description: "Database data type", }, pk: { type: "boolean", description: "Is primary key", }, rqd: { type: "boolean", description: "Is required field", }, unique: { type: "boolean", description: "Is unique constraint", }, ai: { type: "boolean", description: "Is auto increment", }, meta: { type: "object", description: "Additional metadata for specific column types (e.g., options for SingleSelect/MultiSelect, reference columns for QrCode/Barcode)", }, }, required: ["title", "uidt"], }, }, }, required: ["base_id", "table_name", "columns"], },
• src/tools/table.ts:78-170 (registration)

  The complete tool definition object for 'create_table' as part of the exported tableTools array, which defines name, description, inputSchema, and handler.
  { name: "create_table", description: "Create a new table in a base with specified columns. Supports various column types including SingleSelect (with options), PhoneNumber, QrCode, and Barcode.", inputSchema: { type: "object", properties: { base_id: { type: "string", description: "The ID of the base/project", }, table_name: { type: "string", description: "Name of the new table", }, columns: { type: "array", description: "Array of column definitions", items: { type: "object", properties: { title: { type: "string", description: "Column display name", }, column_name: { type: "string", description: "Column name in database", }, uidt: { type: "string", description: "UI Data Type - Basic: SingleLineText, LongText, Number, Decimal, Currency, Percent | Date/Time: Date, DateTime, Duration | Boolean: Checkbox | Select: SingleSelect, MultiSelect | Advanced: Attachment, JSON, Email, PhoneNumber, URL, Rating | Virtual/Computed: Formula, Rollup, Lookup, QrCode, Barcode | Relational: Link, Links", }, dt: { type: "string", description: "Database data type", }, pk: { type: "boolean", description: "Is primary key", }, rqd: { type: "boolean", description: "Is required field", }, unique: { type: "boolean", description: "Is unique constraint", }, ai: { type: "boolean", description: "Is auto increment", }, meta: { type: "object", description: "Additional metadata for specific column types (e.g., options for SingleSelect/MultiSelect, reference columns for QrCode/Barcode)", }, }, required: ["title", "uidt"], }, }, }, required: ["base_id", "table_name", "columns"], }, handler: async ( client: NocoDBClient, args: { base_id: string; table_name: string; columns: any[]; }, ) => { const table = await client.createTable( args.base_id, args.table_name, args.columns, ); return { table: { id: table.id, table_name: table.table_name, title: table.title, type: table.type, enabled: table.enabled, created_at: table.created_at, updated_at: table.updated_at, }, message: `Table '${table.title}' created successfully`, }; }, },
• src/index.ts:55-73 (registration)

  In the main MCP server file, tableTools (including create_table) is imported and spread into allTools, which is then used to register the tools list handler for the MCP protocol.
  const allTools = [ ...databaseTools, ...tableTools, ...recordTools, ...viewTools, ...queryTools, ...attachmentTools, ]; // Register handlers server.setRequestHandler(ListToolsRequestSchema, async () => { return { tools: allTools.map((tool) => ({ name: tool.name, description: tool.description, inputSchema: tool.inputSchema, })), }; });
• src/index.ts:75-103 (registration)

  The MCP call tool handler that dispatches to the specific tool handler (like create_table's) based on name from allTools.
  server.setRequestHandler(CallToolRequestSchema, async (request) => { const { name, arguments: args } = request.params; const tool = allTools.find((t) => t.name === name); if (!tool) { throw new McpError(ErrorCode.MethodNotFound, `Tool ${name} not found`); } try { const result = await tool.handler(nocodb, args); return { content: [ { type: "text", text: JSON.stringify(result, null, 2), }, ], }; } catch (error) { if (error instanceof NocoDBError) { throw new McpError( ErrorCode.InternalError, `NocoDB error: ${error.message}`, error.details, ); } throw error; } });