Airtable MCP server
Provides an authenticated MCP integration for Airtable, enabling discovery of Airtable tools and schemas, authorized read-only data access, and lead data quality review such as identifying incomplete lead records and reading selected tables to prepare customer briefings.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
Prepare a customer briefing from a selected table
Airtable + your AI assistant · powered by PipMCP
You want to prepare a customer briefing from a selected table, using the account your team has actually connected.
Made for: Client service teams
For real use, you will need PipMCP and access to Airtable.
Ask your AI to set this up
Paste this into a coding assistant that can open project files and run commands, such as Codex, Claude Code or Grok Build. You do not need to understand the code first.
Help me use this project: https://github.com/jannikco/airtable-mcp
I'm not a programmer. My goal is: Prepare a customer briefing from a selected table.
Read the project instructions and set it up in a new folder without overwriting my work.
Guide me through PipMCP and its private key setup; never ask me to paste secrets into this
chat. Run a documented sample-data demo if available, then help me get a first small
result from my connected app. Explain the result in plain English. Ask before changing
records, sending messages or publishing anything.Related MCP server: Airtable MCP Server
Three useful things to ask for
Show my accessible bases, then read the table I choose.Summarize the selected records for an upcoming customer call and identify missing
information. Do not edit the table.Turn the selected table records into a short customer-call briefing with the key facts we
should discuss.Your path to a real result
flowchart LR
A["Ask your AI"] --> B["Connect PipMCP"] --> C["Prepare a customer<br/>briefing from a…"] --> D["Review together"]Open PipMCP setup and sign in or create your account.
Connect the app in PipMCP with the permissions you want to grant.
Create the product API key through the official setup, add it privately to your AI project's environment, and ask your AI to try a small read.
What to expect: Connect Airtable in your PipMCP account, then use your PipMCP key for the supported actions. Review proposed changes before they are sent. Results depend on the connected account and its permissions; check the returned outcome before relying on it.
Add your PipMCP key privately in your project settings. Keep keys out of chat and public repositories.
Keep going
Airtable MCP server
Find Airtable leads missing contact data
Review incomplete lead records before any campaign or CRM update.
Try the task with synthetic data
No product key is needed for this demo. Requires Node.js 22+.
npm ci --ignore-scripts
npm run demo
# Optional: save a private report to a new file.
npm run demo -- --output ./synthetic-report.jsonOutput: a task-specific JSON review report selecting 1 of 2 invented records. It includes the completed fixture receipt and a request trace; no provider request or write occurs.
The synthetic records use normalized review fields. Review and map your actual provider schema before applying the same selection to live data.
Use your authorized account
Activate this task, then set PIPMCP_API_KEY in your process environment. Provider credentials stay in PipMCP. Configure the provider connection and explicitly select integration/connection IDs when your account has several.
npm run preflightPreflight checks access/discovery only; it does not count as a completed provider task. For an explicitly reviewed read, use the returned live schema and the exact operation/tool, arguments and stable idempotency key:
npm run verify:read -- --tool '<actual discovered read-only tool>' --arguments '<reviewed argument JSON>' --idempotency-key '<stable request key>' --confirm-read-onlyDiscovery/calls require connectors:read and connectors:call on the PipMCP key. The verification command performs only the selected authorized read; it refuses writes and never selects a customer operation automatically. Only a completed receipt establishes a live read. Missing access, pending jobs and uncertain outcomes remain explicit blockers. Reports contain receipt digests rather than customer payloads. No prices, trials or account allowances are changed.
Use Airtable from Claude Code, Codex, Grok Build and MCP clients through PipMCP. One PipMCP API key connects this package to private execution.
Activate with PipMCP · Integration directory
Build something useful
Find an accessible base and read one selected table to prepare a customer briefing.
The package is an authenticated client: discovery, schemas, policy decisions and execution come from PipMCP. Provider implementation remains on the server.
Quick start
Requires Node.js 22+. Clone this repository, then:
npm ci --ignore-scripts
npm test
npm start
# After configuring your provider in PipMCP and setting PIPMCP_API_KEY:
npm start -- --live
# Launch the stdio MCP bridge:
npm run serverCreate a PipMCP API key with explicit connectors:read and connectors:call scopes. Set PIPMCP_API_KEY in the calling process environment. Provider credentials are configured in PipMCP. Multiple accounts require explicit PIPMCP_INTEGRATION_ID and PIPMCP_CONNECTION_ID from discovery. Existing keys do not gain scopes automatically.
Built for coding agents
Install this repository's skill into your project:
node lib/cli.mjs agents install --client codex --scope project --project /path/to/project
# Use claude or grok for those clients.Connect AI agents to Airtable using one PipMCP API key and actual hosted tool discovery. Native AGENTS.md, CLAUDE.md and project skills support the current coding session. No additional AI model key is required. capabilities.json describes the package; llms.txt indexes its instructions.
Inspect actual tools before calling
import {PipMCPGatewayClient} from './lib/index.mjs';
const client = new PipMCPGatewayClient(); // PIPMCP_API_KEY
const inventory = await client.getTools("airtable");
console.log(inventory.data.tools);
// Select a real tool and validate your arguments against its returned schema.
// client.callTool(provider, actualToolName, reviewedArguments, {idempotencyKey});PipMCP enforces workspace, role, connection, policy/approval and usage controls. Preserve the original idempotency key when retrieving/resuming a receipt. Pending and confirmation_required are not completed provider results; uncertain writes are held for reconciliation. The bridge never auto-approves a hosted action.
Version 1 migration
This release uses the authenticated PipMCP gateway for real discovery/execution. Upgrade your MCP launch command and configure PIPMCP_API_KEY before reconnecting. Historical local runtimes remain available under their original MIT license in Git history.
Evidence and support
Transport, package and agent fixtures are tested. Authentication/provider access must be checked in your own configured workspace; synthetic fixtures do not establish live provider execution. Do not include credentials or customer records in public issues. MIT covers this public client.
Provider setup reference
Official provider documentation. Credentials are entered in PipMCP; this package does not accept or store provider secrets.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Hosted Airtable MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
MCP gateway: one connection for your AI apps, with tool policies, PII redaction and audit logs.
Build and run AI workflows, agents, data tables and 1000+ API integrations from any MCP client.
Connect any AI agent to 1,000+ apps and 27,000+ actions through one remote MCP server (OAuth).
Related MCP Servers
- AlicenseBqualityDmaintenanceEnables AI assistants and applications to interact with Airtable bases through a secure OAuth-authenticated MCP interface, providing complete API coverage for all Airtable operations.10MIT
- AlicenseBqualityBmaintenanceEnables AI-powered interaction with Airtable bases, supporting CRUD operations, schema management, webhooks, and natural language queries through the MCP protocol.11148 npmMIT
- AlicenseNot gradedqualityBmaintenanceEnables AI agents and MCP clients to discover and call hosted CRM tools through a single PipMCP API key, with governed execution, schema validation, policy controls, and idempotency keys.21 npmMIT
- AlicenseNot gradedqualityBmaintenanceEnables AI agents and MCP clients to work with shared pages and notes through one PipMCP API key, with hosted tool discovery, schemas, and governed execution.MIT