Advanced AI-powered Airtable MCP server with TypeScript support, intelligent analytics, predictive modeling, and enterprise automation capabilities
Connect Airtable to Claude, Cursor or any other MCP client and it stops being a tab you switch to. Advanced AI-powered Airtable MCP server with TypeScript support, intelligent analytics, predictive modeling, and enterprise automation capabilities. The airtable mcp server is what makes that connection.
A Model Context Protocol (MCP) server for Airtable with full CRUD operations, schema management, record comments, webhooks, batch operations, governance controls, and AI-powered analytics.
This server provides comprehensive Airtable integration through the Model Context Protocol, enabling natural language interactions with your Airtable data. It includes 42 tools covering every Airtable PAT scope and 10 AI prompt templates for intelligent analytics.
The toolset is worth reading before you wire it up, because it tells you what the integration is really for:
list_bases — List all accessible bases with permissionsdescribe — Describe base or table schema (supports detail levels)query — Query records with filtering, sorting, and paginationsearch_records — Advanced search with Airtable formulaslist_records — List records with field selection and paginationget_record — Retrieve a single record by IDcreate — Create new records (requires dryRun diff review)update — Update existing records (requires dryRun diff review)delete_record — Remove a record from a tableupsert — Update or create records based on merge fieldsbatch_upsert_records — Batch upsert with merge-on fieldslist_tables — Get all tables in a base with schema infoConfiguration is passed through the environment: AIRTABLE_TOKEN, AIRTABLE_BASE_ID, YOUR_AIRTABLE_TOKEN, YOUR_BASE_ID, BASE_ID, YOUR_TOKEN. Treat anything key-shaped as a real credential — scope it to the minimum the server needs, and rotate it if it ever lands in a shared config.
list_bases tool) ---Because this one is hosted, setup is mostly authentication — you point your client at the endpoint and approve access. Nothing runs on your machine, so there is no runtime to keep patched.
This sits in the planning and project tracking group, where several servers overlap in what they claim to do but differ sharply once you actually set them up. Airtable's toolset — list_bases, describe, query and 11 more — is a fair guide to whether it matches your workflow. It is maintained by rashidazarang; worth a glance at recent repository activity before you build anything load-bearing on it.
SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.
| Tool | What it does |
|---|---|
| list_bases | List all accessible bases with permissions |
| describe | Describe base or table schema (supports detail levels) |
| query | Query records with filtering, sorting, and pagination |
| search_records | Advanced search with Airtable formulas |
| list_records | List records with field selection and pagination |
| get_record | Retrieve a single record by ID |
| create | Create new records (requires dryRun diff review) |
| update | Update existing records (requires dryRun diff review) |
| delete_record | Remove a record from a table |
| upsert | Update or create records based on merge fields |
| batch_upsert_records | Batch upsert with merge-on fields |
| list_tables | Get all tables in a base with schema info |
| get_base_schema | Get complete schema for any base |
| list_field_types | Reference guide for available field types |
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["-y", "@rashidazarang/airtable-mcp"],
"env": {
"AIRTABLE_TOKEN": "YOUR_AIRTABLE_TOKEN",
"AIRTABLE_BASE_ID": "YOUR_BASE_ID"
}
}
}
}Configuration as documented by the project. Restart the client after saving.
list_bases tool) ---| Variable | Description | Required |
|---|---|---|
| AIRTABLE_TOKEN | Credential the server authenticates with. | Yes |
| AIRTABLE_BASE_ID | Configuration value read at startup. | Optional |
| YOUR_AIRTABLE_TOKEN | Credential the server authenticates with. | Yes |
| YOUR_BASE_ID | Configuration value read at startup. | Optional |
| BASE_ID | Configuration value read at startup. | Optional |
| YOUR_TOKEN | Credential the server authenticates with. | Yes |
Your workspace, on speaking terms with AI — search, read and write Notion pages and databases.
Issue tracking at the speed of conversation — Linear's official hosted server with OAuth and zero install.
Search and read your Drive — Docs, Sheets and files become context your assistant can actually use.
Your assistant inside the workspace — read channels, search history, post messages and tame the noise.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Stop letting your assistant hallucinate n8n node parameters — this server hands it the real schemas, templates and validation.