Spreadsheet-database hybrid meets AI — inspect schemas, query records and update bases conversationally.
Airtable bases grow the way gardens do — enthusiastically and without consultation — until "which table has the client contacts, and what do these fields mean?" is a genuine research question. The Airtable MCP server (domdomegg's implementation is the community standard) gives your assistant both the map and the hands: full schema inspection across bases and tables, plus record-level read, create, update, delete and search.
Schema-awareness is what separates this from generic spreadsheet chat. The assistant first learns your actual structure — tables, field types, select options, linked records — then works within it correctly: records land with valid select values, links point at real rows, dates arrive formatted. "Add Globex to the CRM as a qualified lead, linked to yesterday's intro call" touches three tables correctly because the assistant read the schema first.
Queries handle the reporting layer Airtable's own interface makes you build views for: "deals closing this month over $10k", "content pieces with no assigned writer", "which projects reference this client?" — answered directly, no view-building required. Schema evolution is covered too (create tables, add fields), handy when a base needs to grow mid-conversation.
Setup is one personal access token with scopes you choose — schema read plus record read/write is typical — and granting base access at token creation is your blast-radius control. The npx one-liner makes this one of the fastest data integrations to stand up: token to talking-to-your-base in under five minutes.
schema.bases:write off unless you want tables and fields created; read scopes plus data.records:write cover every CRM-shaped workflow.Leads logged, stages updated and calls linked — by sentence rather than by form.
Filtered questions answered directly without building Airtable views first.
Inherited bases explained: what tables exist, how they link, what fields mean.
| Tool | What it does |
|---|---|
| list_bases / list_tables | Enumerate accessible bases and their tables |
| describe_table | Field-level schema: types, options, linked records |
| list_records / search_records | Query and text-search records with filters |
| create_record / update_records | Add and modify records with schema-valid values |
| delete_records | Remove records |
| create_table / create_field | Evolve the schema when a base needs to grow |
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": ["-y", "airtable-mcp-server"],
"env": { "AIRTABLE_API_KEY": "pat_your_token" }
}
}
}Create a personal access token at airtable.com/create/tokens with schema.bases:read and data.records scopes, granting only the bases you need.
An Airtable account and a personal access token scoped to the bases you want exposed. Node.js 18+.
| Variable | Description | Required |
|---|---|---|
| AIRTABLE_API_KEY | Personal access token with schema read + record read/write scopes on chosen basese.g. pat... | 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.