Lets agents inspect Airtable base schemas and read and write records.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add airtable --env AIRTABLE_API_KEY='<AIRTABLE_API_KEY>' --env MCP_TRANSPORT='<MCP_TRANSPORT>' --env PORT='<PORT>' -- npx -y airtable-mcp-server~/.codex/config.toml
[mcp_servers.airtable]
command = "npx"
args = ["-y", "airtable-mcp-server"]
env = { AIRTABLE_API_KEY = "<AIRTABLE_API_KEY>", MCP_TRANSPORT = "<MCP_TRANSPORT>", PORT = "<PORT>" }
# codex mcp add airtable --env AIRTABLE_API_KEY='<AIRTABLE_API_KEY>' --env MCP_TRANSPORT='<MCP_TRANSPORT>' --env PORT='<PORT>' -- npx -y airtable-mcp-server~/.cursor/mcp.json
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "<AIRTABLE_API_KEY>",
"MCP_TRANSPORT": "<MCP_TRANSPORT>",
"PORT": "<PORT>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"airtable": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "<AIRTABLE_API_KEY>",
"MCP_TRANSPORT": "<MCP_TRANSPORT>",
"PORT": "<PORT>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "<AIRTABLE_API_KEY>",
"MCP_TRANSPORT": "<MCP_TRANSPORT>",
"PORT": "<PORT>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "<AIRTABLE_API_KEY>",
"MCP_TRANSPORT": "<MCP_TRANSPORT>",
"PORT": "<PORT>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"airtable": {
"command": "npx",
"args": [
"-y",
"airtable-mcp-server"
],
"env": {
"AIRTABLE_API_KEY": "<AIRTABLE_API_KEY>",
"MCP_TRANSPORT": "<MCP_TRANSPORT>",
"PORT": "<PORT>"
}
}
}
}Environment variables
AIRTABLE_API_KEYMCP_TRANSPORTPORT
Replace the placeholders with your own credentials and keep them out of version control.