Connect Airtable to AI assistants: bases, tables, fields and records.
Part of the Insightful Pipe MCP Server Collection — use Airtable from Claude, ChatGPT, Cursor, and other AI assistants through the Model Context Protocol (MCP).
https://airtable.insightfulmcp.com/
Airtable MCP is a remote Model Context Protocol server hosted by InsightfulPipe. List Airtable bases, inspect tables, and read records across your connected workspace. The PAT scopes you grant decide what's allowed.
- Copy the MCP Server URL:
https://airtable.insightfulmcp.com/ - Open Claude Connectors Settings
- Scroll to the bottom and click Add custom connector
- Paste the URL and click Add
- Click Connect on the connector to start authorization
- Click Authorize access in the browser to complete the connection
Custom MCP servers are added through ChatGPT's Developer mode. Availability depends on your ChatGPT plan, and workspace admins may need to allow it.
- Turn on Developer mode in ChatGPT settings
- Create a new app for a remote MCP server and paste the URL:
https://airtable.insightfulmcp.com/ - Authorize with your InsightfulPipe account
See OpenAI's guide: Developer mode and MCP apps in ChatGPT
claude mcp add --transport http airtable https://airtable.insightfulmcp.com/Add the server to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (one project):
{
"mcpServers": {
"airtable": {
"url": "https://airtable.insightfulmcp.com/"
}
}
}Then authorize the connection when Cursor prompts you.
24 actions: 10 read, 14 write.
| Action | Description |
|---|---|
count_records |
Count records matching a filter (paginates through, sums lengths) |
describe_table |
Return the schema of a single table from a base |
get_record |
Get a single record by id |
list_bases |
List bases the authorized user has access to |
list_comments |
List comments on a record |
list_fields |
List only the fields of a table (subset of describe_table) |
list_records |
List records from a table |
list_tables |
List tables (with full schema: fields, views) in a base |
list_views |
List only the views of a table (subset of describe_table) |
search_records |
Keyword search across one or more fields |
| Action | Description |
|---|---|
create_comment |
Post a comment on a record |
create_field |
Add a new field to a table |
create_record |
Create a single record |
create_records |
Create up to 10 records in one call |
create_table |
Create a new table in a base |
delete_comment |
Delete a comment |
delete_record |
Delete a single record by id |
delete_records |
Delete up to 10 records by id in one call |
update_comment |
Edit a comment |
update_field |
Rename or re-describe an existing field |
update_record |
PATCH (merge) a single record |
update_records |
PATCH (merge) up to 10 records in one call |
update_table |
Update a table's name or description |
upload_attachment |
Upload an attachment to an attachment field on a record |
You decide what AI agents can do with each connected account:
- Turn individual actions on or off for every connected account, so agents only see the actions you allow.
- Connect as Read-only or Read & Write. A read-only connection can only enable read actions.
- Destructive actions stay off by default. Actions such as deletes are disabled until an admin enables them.
- Team access per account. Restricted team members only use the accounts they are granted, with the read actions enabled on them.
"List records in the Campaigns table where Status is Live"
"How many records are in the Leads table?"
"Create a record for a new lead"
The Airtable MCP server is included in every InsightfulPipe plan, together with all other MCP servers and the CLI. Plans start at $29.99/month with a 7-day free trial. See insightfulpipe.com/pricing for current plans.
Visit insightfulpipe.com/mcp-servers to discover our full collection of MCP servers.
- Documentation: insightfulpipe.com/docs
- All MCP Servers: insightfulpipe.com/mcp-servers
- Email: support@insightfulpipe.com
Insightful Pipe — AI-powered marketing analytics through MCP servers. Explore all integrations →
MIT License - see LICENSE for details.