Airtable MCP Server

Instructions

Implementation Reference

• src/index.ts:420-443 (handler)

  The main handler for the 'create_table' tool. It extracts arguments, validates fields using validateField, makes a POST request to Airtable's metadata API to create the table, and returns the response as text.

  case "create_table": {
    const { base_id, table_name, description, fields } = request.params.arguments as {
      base_id: string;
      table_name: string;
      description?: string;
      fields?: FieldOption[];
    };
    
    // Validate and prepare fields
    const validatedFields = fields?.map(field => this.validateField(field));
    
    const response = await this.axiosInstance.post(`/meta/bases/${base_id}/tables`, {
      name: table_name,
      description,
      fields: validatedFields,
    });
    
    return {
      content: [{
        type: "text",
        text: JSON.stringify(response.data, null, 2),
      }],
    };
  }

• src/index.ts:100-147 (schema)

  Input schema definition for the 'create_table' tool, including parameters for base_id, table_name, description, and fields array with their types.

  {
    name: "create_table",
    description: "Create a new table in a base",
    inputSchema: {
      type: "object",
      properties: {
        base_id: {
          type: "string",
          description: "ID of the base",
        },
        table_name: {
          type: "string",
          description: "Name of the new table",
        },
        description: {
          type: "string",
          description: "Description of the table",
        },
        fields: {
          type: "array",
          description: "Initial fields for the table",
          items: {
            type: "object",
            properties: {
              name: {
                type: "string",
                description: "Name of the field",
              },
              type: {
                type: "string",
                description: "Type of the field (e.g., singleLineText, multilineText, number, etc.)",
              },
              description: {
                type: "string",
                description: "Description of the field",
              },
              options: {
                type: "object",
                description: "Field-specific options",
              },
            },
            required: ["name", "type"],
          },
        },
      },
      required: ["base_id", "table_name"],
    },
  },

• src/index.ts:53-71 (helper)

  Helper function used by the create_table handler to validate and normalize field definitions by removing unnecessary options or adding defaults.

  private validateField(field: FieldOption): FieldOption {
    const { type } = field;
  
    // Remove options for fields that don't need them
    if (!fieldRequiresOptions(type as FieldType)) {
      const { options, ...rest } = field;
      return rest;
    }
  
    // Add default options for fields that require them
    if (!field.options) {
      return {
        ...field,
        options: getDefaultOptions(type as FieldType),
      };
    }
  
    return field;
  }

• src/types.ts:15-20 (schema)

  TypeScript interface defining the structure of a FieldOption, used in the input schema for fields in create_table.

  export interface FieldOption {
    name: string;
    type: FieldType;
    description?: string;
    options?: Record<string, any>;
  }

• src/types.ts:22-46 (helper)

  Helper functions to determine if a field type requires options and to provide default options, used by validateField in the create_table handler.

  export const fieldRequiresOptions = (type: FieldType): boolean => {
    switch (type) {
      case 'number':
      case 'singleSelect':
      case 'multiSelect':
      case 'date':
      case 'currency':
        return true;
      default:
        return false;
    }
  };
  
  export const getDefaultOptions = (type: FieldType): Record<string, any> | undefined => {
    switch (type) {
      case 'number':
        return { precision: 0 };
      case 'date':
        return { dateFormat: { name: 'local' } };
      case 'currency':
        return { precision: 2, symbol: '$' };
      default:
        return undefined;
    }
  };