This MCP server, developed by domdomegg, enables AI assistants like Claude to interact with Airtable databases. Built in TypeScript, it provides capabilities for querying and modifying Airtable bases, tables, fields, and records through a standardized interface. The implementation stands out by offering full read/write access to Airtable's rich data model and metadata. By connecting AI capabilities with structured data in Airtable, this server allows AI systems to analyze, manipulate, and act on user-defined datasets. It is particularly useful for automating data entry workflows, building AI-powered data analysis tools, or creating natural language interfaces to Airtable-based applications.
Lists records from a specified Airtable table. Input parameters: baseId (string, required), tableId (string, required), maxRecords (number, optional), filterByFormula (string, optional)
Search for records containing specific text. Input parameters: baseId (string, required), tableId (string, required), searchTerm (string, required), fieldIds (array, optional), maxRecords (number, optional)
Lists all accessible Airtable bases. No input parameters required. Returns base ID, name, and permission level.
Lists all tables in a specific base. Input parameters: baseId (string, required), detailLevel (string, optional). Returns table ID, name, description, fields, and views.
Gets detailed information about a specific table. Input parameters: baseId (string, required), tableId (string, required), detailLevel (string, optional). Returns detailed information for a single table.
Gets a specific record by ID. Input parameters: baseId (string, required), tableId (string, required), recordId (string, required).
Creates a new record in a table. Input parameters: baseId (string, required), tableId (string, required), fields (object, required).
Updates one or more records in a table. Input parameters: baseId (string, required), tableId (string, required), records (array, required).
Deletes one or more records from a table. Input parameters: baseId (string, required), tableId (string, required), recordIds (array, required).
Creates a new table in a base. Input parameters: baseId (string, required), name (string, required), description (string, optional), fields (array, required).
Updates a table's name or description. Input parameters: baseId (string, required), tableId (string, required), name (string, optional), description (string, optional).
Creates a new field in a table. Input parameters: baseId (string, required), tableId (string, required), name (string, required), type (string, required), description (string, optional), options (object, optional).
Updates a field's name or description. Input parameters: baseId (string, required), tableId (string, required), fieldId (string, required), name (string, optional), description (string, optional).
No reviews yet. Be the first to review!
Sign in to join the conversation