Airtable

liveSaaSProductivity

List, get, create, and query records across Airtable bases and tables via the Airtable REST API.

5tools
0msauth
free tier50 calls/day

Tools

airtable_list_records

Fetch records from an Airtable table with optional filtering by formula (e.g., "{Status} = 'Done'"). Returns record IDs, field values, and metadata.

No parameters required.

▶Try it
airtable_get_record

Fetch a single Airtable record by its record ID (recXXXXXXXXXXXX) from a specified base and table. Returns all field values and record metadata including created/modified timestamps.

No parameters required.

▶Try it
airtable_create_record

Add a new record to an Airtable table with specified field values. Returns the created record ID and full record data.

No parameters required.

▶Try it
airtable_list_bases

List all Airtable bases the provided personal access token can access. Returns base IDs, names, and workspace info — use to discover baseId values needed by other airtable tools.

No parameters required.

▶Try it
airtable_get_base_schema

Get the structure of an Airtable base—all tables, field names, field types, and configurations. Use first to understand available data before querying or creating records.

No parameters required.

▶Try it

Test with curl

The gateway speaks JSON-RPC 2.0 over HTTP POST. You can test any pack directly from the terminal.

List available tools
bash
curl -X POST https://gateway.pipeworx.io/airtable/mcp \
  -H "Content-Type: application/json" \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/list"}'
Call a tool
bash
curl -X POST https://gateway.pipeworx.io/airtable/mcp \
  -H "Content-Type: application/json" \
  -d '{"jsonrpc":"2.0","id":2,"method":"tools/call","params":{"name":"airtable_list_records","arguments":{}}}'

Use with the SDK

Install @pipeworx/sdk to call tools from any TypeScript/Node project.

TypeScript
import { Pipeworx } from '@pipeworx/sdk';
const px = new Pipeworx();
const result = await px.call("airtable_list_records", {});
ask_pipeworx
// Or ask in plain English:
const answer = await px.ask("list, get, create, and query records across airtable bases and tables via the airtable rest api");