Airtable

Airtable

Read and write access to Airtable databases, with schema inspection.

355
Stars
123
Forks
10
Releases

Overview

This MCP server provides read and write access to Airtable databases with built-in schema inspection capabilities. It enables LLMs to discover accessible Airtable bases and tables, inspect table schemas, and perform standard CRUD operations on records and tables. Core tools include listing bases and tables, describing tables, retrieving specific records, and creating, updating, or deleting records. It also supports creating and updating tables and fields, as well as managing comments on records. In addition, the server exposes table schema information through a dedicated schema endpoint (airtable://<baseId>/<tableId>/schema) that contains base IDs, table IDs, names, descriptions, primary field IDs, field definitions (ID, name, type, description, options), and view definitions discovered via Airtable's metadata API. The MCP server is designed to integrate with LLM-focused clients such as Claude Desktop, Cursor, and Cline using configurable commands, environment variables, and JSON configurations to manage API keys and endpoints. This enables controlled, schema-aware access to Airtable data for read and write operations in a consistent, machine-readable format.

Details

Owner
domdomegg
Language
TypeScript
License
MIT License
Updated
2025-12-07

Features

list_records

Lists records from a specified Airtable table; accepts baseId, tableId, maxRecords (default 100), and optional filterByFormula.

search_records

Searches for records containing specific text; accepts baseId, tableId, searchTerm, optional fieldIds and maxRecords.

list_bases

Lists all accessible Airtable bases; returns base ID, name, and permission level.

list_tables

Lists all tables in a base; accepts baseId and detailLevel; returns table IDs, names, descriptions, fields, and views.

describe_table

Gets detailed information about a specific table; accepts baseId, tableId and detailLevel; returns the same structure as list_tables for the specified table.

get_record

Retrieves a specific record by ID; requires baseId, tableId and recordId.

create_record

Creates a new record in a table; requires baseId, tableId and fields.

update_records

Updates one or more records in a table; requires baseId, tableId and records.

Tags

airtablemcp-serverschema-inspectionread-writerecordsbasestablesfieldscommentsapi