Skip to main content
Glama
Sign In
mcp-airtable-query

mcp-airtable-query

by TTaoGaming
OverviewSchemaSourceRelated ServersDiscussionsAdmin
TypeScript
Hybrid

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.

Related MCP server: Airtable MCP Server

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.

Available Tools

9 tools
airtable_statusAirtable connection statusA
Read-onlyIdempotent

Report non-secret Airtable configuration.

Inputs: no named parameters. Returns: ok, code, data, error, +1 more

build_filter_formulaBuild filter formulaA
Read-onlyIdempotent

Build an Airtable filterByFormula string from a validated AND/OR comparison tree.

Inputs: filter (required). Returns: ok, code, data, error, +1 more

create_recordsCreate recordsA

Create up to ten records in one Airtable request.

Inputs: table (required), baseId (required), records (required), typecast. Returns: ok, code, data, error, +1 more

delete_recordsDelete recordsA
DestructiveIdempotent

Permanently delete up to ten records.

Inputs: table (required), baseId (required), recordIds (required). Returns: ok, code, data, error, +1 more

get_base_schemaGet base schemaA
Read-onlyIdempotent

List tables, fields, and views for a base.

Inputs: baseId (required). Returns: ok, code, data, error, +1 more

get_recordGet recordC
Read-onlyIdempotent

Retrieve one Airtable record.

Inputs: table (required), baseId (required), recordId (required). Returns: ok, code, data, error, +1 more

list_basesList Airtable basesB
Read-onlyIdempotent

List bases available to the token.

Inputs: offset. Returns: ok, code, data, error, +1 more

list_recordsList recordsA
Read-onlyIdempotent

Query records with view, formula, fields, sorting, and pagination.

Inputs: table (required), baseId (required), sort, view, +5 more. Returns: ok, code, data, error, +1 more

update_recordsUpdate recordsA
Idempotent

Update up to ten records by ID.

Inputs: table (required), baseId (required), records (required), replace, +1 more. Returns: ok, code, data, error, +1 more

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Deploy Server
    One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

    TDQS

    A3.8/5.0

    Scored across 9 tools

    Disambiguation5/5

    Each tool targets a distinct resource and action: status, bases, schema, records (list/get/create/update/delete), and filter formula building. There is no overlap or ambiguity between tools.

    Naming Consistency4/5

    Most tools follow a clear verb_noun pattern (e.g., list_bases, create_records), with 'get' for single items and 'list' for collections. The one deviation is 'airtable_status', which reads more like a noun than a verb, but it is still easily understood.

    Tool Count5/5

    With 9 tools, the server is well-scoped for Airtable data operations. Each tool serves a necessary function without unnecessary bloat.

    Completeness5/5

    The CRUD lifecycle for records is fully covered (list, get, create, update, delete), along with base and schema discovery and a filter helper. There are no significant missing operations for a query-focused Airtable server.

    Resources

    Related MCP Connectors

    Related MCP Servers

    • airtable-mcp-server

      domdomegg
      A
      license
      B
      quality
      B
      maintenance
      A Model Context Protocol server that provides read and write access to Airtable databases. This server enables LLMs to inspect database schemas, then read and write records.
      16
      3,545 npm
      456
      TypeScript
      MIT

    • Airtable MCP Server

      felores
      A
      license
      A
      quality
      D
      maintenance
      A Model Context Protocol server that provides tools for programmatically managing Airtable bases, tables, fields, and records through Claude Desktop or other MCP clients.
      12
      362 npm
      75
      MIT

    • Effect Airtable MCP Server

      glassBead-tc
      A
      license
      Not graded
      quality
      D
      maintenance
      A production-ready MCP server for Airtable that enables programmatic management of bases, tables, fields, and records through Claude Desktop or other MCP clients using Effect for type-safe and robust API interactions.
      9 npm
      1
      MIT