mcp-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.
