domdomegg/airtable-mcp-server

npx -y airtable-mcp-server (the install-mcp page generates the right config for your client, with AIRTABLE_API_KEY env)
HTTP mode: MCP_TRANSPORT=http PORT=3000 npx airtable-mcp-server (runs a stateless HTTP server at http://localhost:3000/mcp)

Usage

• •Create an Airtable personal access token (looks like pat123.abc123) with scopes schema.bases:read and data.records:read (optionally schema.bases:write, data.records:write, data.recordComments:read, data.recordComments:write) and access to the bases you want; set it as AIRTABLE_API_KEY
• •Inspect schema with list_bases / list_tables / describe_table (detailLevel: tableIdentifiersOnly/identifiersOnly/full)
• •Read/write records with list_records, search_records, get_record, create_record, update_records, delete_records
• •Manage tables/fields with create_table, update_table, create_field, update_field; handle record comments with create_comment and list_comments

Key features

• ✓15 tools covering schema inspection, record CRUD, table/field management, and record comments (with threaded replies)
• ✓search_records with optional fieldIds scoping and maxRecords (default 100)
• ✓list_bases returns base ID, name, and permission level
• ✓HTTP transport mode for remote MCP clients
• ✓list_comments returns comments newest-to-oldest with author, text, timestamps, reactions, and mentions

Caveats

• ⚠HTTP transport has no built-in authentication — a malicious website can use DNS rebinding against localhost; only run it behind a reverse proxy or gateway requiring a credential, or use stdio for same-machine clients
• ⚠Requires an Airtable personal access token with the appropriate scopes and base access