Airtable

Lightweight, dependency-free, in-memory Airtable REST API emulator for testing code that uses the real airtable npm client or the Airtable REST API directly.

Default port: 4611

Quick Start

import Airtable from "airtable";
import { AirtableServer } from "./services/airtable/src/server.js";

const server = new AirtableServer(4611);
await server.start();

const base = new Airtable({
  apiKey: "keyParlel",
  endpointUrl: "http://127.0.0.1:4611",
}).base("appParlel");

const created = await base("Tasks").create({ Name: "Test locally" });
const records = await base("Tasks").select({ pageSize: 10 }).all();

await server.stop();

Implemented Operations

Table records, compatible with the airtable npm client's public table methods:

• GET /v0/:baseId/:tableName — list/select records with query params (fields[], filterByFormula, maxRecords, pageSize, offset, sort[0][field], sort[0][direction], view, cellFormat, timeZone, userLocale).
• POST /v0/:baseId/:tableName/listRecords — list records with parameters in JSON body (mirrors GET list with long query strings).
• POST /v0/:baseId/:tableName?method=list — legacy list alias accepted by older airtable client versions.
• GET /v0/:baseId/:tableName/:recordId — find one record by ID.
• POST /v0/:baseId/:tableName — create one record ({ "fields": { ... } }) or up to 10 records ({ "records": [{ "fields": { ... } }] }).
• PATCH /v0/:baseId/:tableName/:recordId — update one record by merging fields.
• PUT /v0/:baseId/:tableName/:recordId — replace one record's fields (destructive).
• PATCH /v0/:baseId/:tableName — update up to 10 records in batch.
• PUT /v0/:baseId/:tableName — replace up to 10 records in batch (destructive).
• DELETE /v0/:baseId/:tableName/:recordId — delete one record.
• DELETE /v0/:baseId/:tableName?records[]=recA&records[]=recB — delete up to 10 records by ID.

Service endpoints:

• GET / — service metadata.
• GET /health — { "status": "ok" }.
• OPTIONS * — 204 (CORS preflight).
• POST /__reset — clear all in-memory state.
• server.reset() — clear all in-memory state when used in-process.

Access via MCP / preview URL

Not currently exposed via MCP or preview URL. Use the REST endpoint at http://127.0.0.1:4611.

Surface coverage

Legend: ✅ supported · ◐ accepted-not-enforced · ✓ by design · ⟳ roadmap

Error codes & shapes

All JSON errors use Airtable-style framing:

{
  "error": {
    "type": "NOT_FOUND",
    "message": "Could not find record"
  }
}

Manifest

{
  "name": "airtable",
  "version": "0.1",
  "port": 4611,
  "protocol": "http",
  "healthcheck": "/health"
}

Configuration — test.env

Copy these into your test.env (used by the bridge sidecar flow). Tokens are Parlel's seeded test credentials — any non-empty value is accepted by the emulator, so you rarely need to change them. Swap in real credentials only when pointing at the live service in prod.env.

AIRTABLE_API_KEY=parlel
AIRTABLE_ENDPOINT_URL=http://parlel-bridge:4611
AIRTABLE_BASE_ID=appParlel