Loading...
Airtable MCP server enables LLMs to read, write, and manage Airtable databases, providing access to data and schema via API key authentication.
Boost this tool
Subscribe to listing upgrades or segmented pushes.
Airtable MCP server enables LLMs to read, write, and manage Airtable databases, providing access to data and schema via API key authentication.
This server offers significant utility but requires careful API key management. Limiting scopes and deploying behind a reverse proxy are crucial for mitigating risks. The HTTP transport option should only be used in secured environments.
Performance depends on Airtable's API response times and the complexity of queries. Consider using filters and limiting the number of records returned.
Airtable charges based on API usage and storage. Be mindful of the number of API calls, especially when performing write operations or large data retrievals.
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "pat123.abc123",
}
}
}
}MCP_TRANSPORTlist_recordsLists records from a specified Airtable table.
Read-only operation.
search_recordsSearches for records containing specific text.
Read-only operation.
list_basesLists all accessible Airtable bases.
Read-only operation.
list_tablesLists all tables in a specific base.
Read-only operation.
describe_tableGets detailed information about a specific table.
Read-only operation.
get_recordGets a specific record by ID.
Read-only operation.
create_recordCreates a new record in a table.
Creates new data.
update_recordsUpdates one or more records in a table.
Modifies existing data.
delete_recordsDeletes one or more records from a table.
Destructive operation.
create_tableCreates a new table in a base.
Modifies the database schema.
update_tableUpdates a table's name or description.
Modifies the database schema.
create_fieldCreates a new field in a table.
Modifies the database schema.
update_fieldUpdates a field's name or description.
Modifies the database schema.
create_commentCreates a comment on a record.
Adds new data.
list_commentsLists comments on a record.
Read-only operation.
API Key
hybrid
schema.bases:readdata.records:readschema.bases:writedata.records:writedata.recordComments:readdata.recordComments:writeThis server offers significant utility but requires careful API key management. Limiting scopes and deploying behind a reverse proxy are crucial for mitigating risks. The HTTP transport option should only be used in secured environments.
Autonomy level depends on the scopes granted to the API key. Exercise caution when granting write or delete permissions.
Production Tip
Monitor Airtable API usage to prevent rate limiting and unexpected costs.
Use `schema.bases:read` and `data.records:read`.
Store it securely using environment variables or a secrets manager. Avoid hardcoding it in your application.
Yes, the API key needs access to all the bases you want to use.
The server will return an error. Implement retry logic in your client to handle rate limiting.
Only use it behind a reverse proxy or in a secured environment, as it lacks built-in authentication.
Use the `filterByFormula` parameter in the `list_records` tool.
Yes, you can read and write attachment fields.