Airtable MCP Server

MCP server for Airtable that lets AI agents read and write records, list bases and tables, inspect field schemas, and run filtered queries. Ideal for turning Airtable into a lightweight backend or knowledge base that agents can manage conversationally.

{
  "mcpServers": {
    "airtable": {
      "command": "npx",
      "args": [
        "-y",
        "airtable-mcp-server"
      ],
      "env": {
        "AIRTABLE_API_KEY": "<YOUR_AIRTABLE_API_KEY>"
      }
    }
  }
}

{
  "type": "object",
  "required": [
    "base_id",
    "table"
  ],
  "properties": {
    "table": {
      "type": "string",
      "description": "Table name or ID"
    },
    "base_id": {
      "type": "string",
      "description": "Airtable base ID"
    },
    "max_records": {
      "type": "integer",
      "description": "Maximum number of records to return"
    },
    "filter_by_formula": {
      "type": "string",
      "description": "Airtable formula to filter records"
    }
  }
}

{
  "type": "object",
  "required": [
    "base_id",
    "table",
    "fields"
  ],
  "properties": {
    "table": {
      "type": "string",
      "description": "Table name or ID"
    },
    "fields": {
      "type": "object",
      "description": "Field name/value pairs for the new record"
    },
    "base_id": {
      "type": "string",
      "description": "Airtable base ID"
    }
  }
}

{
  "type": "object",
  "required": [
    "base_id",
    "table",
    "record_id",
    "fields"
  ],
  "properties": {
    "table": {
      "type": "string",
      "description": "Table name or ID"
    },
    "fields": {
      "type": "object",
      "description": "Field name/value pairs to update"
    },
    "base_id": {
      "type": "string",
      "description": "Airtable base ID"
    },
    "record_id": {
      "type": "string",
      "description": "ID of the record to update"
    }
  }
}