Airtable MCP Server

MCPOpen SourceMIT19.5

by alexbruf • APIs & Integration

A local Model Context Protocol (MCP) server that lets AI agents (e.g., Claude for Desktop) interact with Airtable bases via natural language and exposed tools.

Example Use Cases

1
List and inspect available Airtable bases and tables to decide where to read or write data.
2
Perform CRUD operations on Airtable records (create, read, update, delete) programmatically via natural language tooling.
3
Integrate Airtable access into Claude for Desktop workflows so the assistant can query or modify your base in-context.

Description

This project runs a local MCP server exposing Airtable functionality (list bases/tables/records, fetch, create, update, delete records) as MCP tools. It is designed to be installed and run via pipx and integrates with Claude for Desktop so agents can call Airtable operations directly. Authentication is handled with an Airtable Personal Access Token and an optional default base ID, keeping credentials local to the environment. The server simplifies automating Airtable workflows and enabling agents to manipulate data without building a custom API bridge.

Capabilities(8 total)

Tools (8)

list_bases

List all accessible Airtable bases.

list_tables

List all tables in the specified base or the default base.

base_id_param:any

list_records

List records from a table. Specify table by name or ID. Can filter by view, formula, or select specific fields. Max 100 records. Args: table_name_or_id: The name or ID of the table. base_id_param: Optional Base ID to use, overrides default. max_records: Maximum records to return (default 10, max 100). view: Name or ID of a view to use for filtering/sorting. filter_formula: Airtable formula to filter records. fields: List of field names to return. If None, returns all. Returns: A string listing the records or an error message.

table_name_or_id:string*base_id_param:anymax_records:integerview:anyfilter_formula:anyfields:any

get_record

Get a specific record from a table by its ID.

table_name_or_id:string*record_id:string*base_id_param:any

create_records

Create one or more records in a table. Input is a JSON string. Args: table_name_or_id: The name or ID of the table. records_json: JSON string representing a single record object (fields only) or a list of record objects. Example for single: '{"Name": "New Task", "Status": "Todo"}' Example for multiple: '[{"fields": {"Name": "Task 1"}}, {"fields": {"Name": "Task 2"}}]' base_id_param: Optional Base ID to use, overrides default. typecast: Attempt automatic data type conversion (e.g., string to number). Defaults to False. Returns: A string confirming creation or an error message.

table_name_or_id:string*records_json:string*base_id_param:anytypecast:boolean

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

LOW

Reads external data but no write or execute capability

Trust Score

C56/100

6/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities8 Tools / 0 Prompts / 0 Resources

Owneralexbruf

CategoryAPIs & Integration

DependenciesStandalone

Set Your Username