Airtable Query

Lightweight TypeScript MCP server for Airtable base discovery, table/view queries, record CRUD, and validated filterByFormula construction. It exposes nine tools, a status resource, and a read-first workflow prompt over stdio or Cloudflare Workers Streamable HTTP.

Install and run

git clone https://github.com/TTaoGaming/mcp-airtable-query.git
cd mcp-airtable-query
npm ci
npm run build
AIRTABLE_API_KEY=pat... npm run dev

Point an MCP client at node dist/src/stdio.js. For hosted mode, set AIRTABLE_API_KEY with wrangler secret put AIRTABLE_API_KEY, then run npm run deploy; the MCP route is /mcp.

Live credential-free demo: https://mcp-airtable-query.tommytai3.workers.dev/mcp. Discovery and status work; Airtable calls fail closed until a Worker secret is bound.

Tools

airtable_status, list_bases, get_base_schema, list_records, get_record, create_records, update_records, delete_records, and build_filter_formula.

Verification

npm run check compiles both transports, runs tests, and performs a Worker dry-run. npm run inspector:list asserts MCP discovery with the official Inspector CLI. npm and MCP Registry publication require explicit operator approval.