home / mcp / aitable mcp server

AITable MCP Server

Provides MCP integration to query and manage AITable datasheets, records, fields, views, attachments, and embed links.

Installation

Add the following to your MCP client configuration file.

Configuration

{
  "mcpServers": {
    "hamchowderr-aitable-mcp": {
      "url": "https://your-project.vercel.app/mcp",
      "headers": {
        "SPACE_ID": "YOUR_SPACE_ID",
        "AITABLE_API_TOKEN": "YOUR_API_TOKEN"
      }
    }
  }
}

You can run an MCP server that connects the AITable platform to external clients. This server lets you query and manage data, including records, fields, views, attachments, and embeddable links, through an MCP-compatible interface. It supports both a local stdio transport for fast, on-device usage and an HTTP transport suitable for cloud-based clients.

How to use

You can access AITable data via two transport methods. For quick local use with Claude Desktop, run the stdio version and communicate directly through the process. For centralized access or integration with web clients, run the HTTP transport hosted on your deployment platform.

How to install

Prerequisites you need before installing: Node.js >= 18.0.0, npm or pnpm, and an AITable account with an API access token.

Option 1: Install via npm (Recommended) run directly with npx.

npx aitable-mcp

Option 2: Install from Source.

# Clone the repository
git clone https://github.com/hamchowderr/aitable-mcp.git
cd aitable-mcp

# Install dependencies
npm install

# Build the project
npm run build

Additional configuration and usage details

Environment variables needed by the server are AITABLE_API_TOKEN (your AITable API token) and SPACE_ID (your AITable space ID). You can set these via your shell or put them in a .env file at the project root.

# Windows
set AITABLE_API_TOKEN=your-api-token-here
set SPACE_ID=your-space-id

# macOS/Linux
export AITABLE_API_TOKEN="your-api-token-here"
export SPACE_ID="your-space-id"

Example MCP server configurations

The MCP server can be accessed in two ways. The HTTP transport runs as a hosted endpoint, while the stdio transport runs locally via the CLI. Use both configs if you plan to support both access methods.

{
  "mcpServers": {
    "aitable_http": {
      "type": "http",
      "name": "aitable_http",
      "url": "https://your-project.vercel.app/mcp",
      "args": []
    },
    "aitable_stdio": {
      "type": "stdio",
      "name": "aitable_stdio",
      "command": "npx",
      "args": ["-y", "aitable-mcp"]
    }
  }
}

Security and best practices

Keep your AITable API token secret and rotate it periodically. Use the stdio transport for personal use to minimize exposure, and disable deployment protection when using HTTP with MCP clients. Monitor access and use environment variables securely without committing tokens to version control.

Architecture

This MCP server supports dual transport modes: a Stdio Transport for direct, low-latency local use and an HTTP Transport deployed as a serverless function. Both share the same core business logic but communicate with clients through different mechanisms.

Development

Common development tasks include cleaning, building, and running in development mode.

# Clean build artifacts
npm run clean

# Build TypeScript
npm run build

# Watch mode for development
npm run dev

# Test HTTP server locally
npm run dev:http

# Test with Vercel dev server
npm run dev:vercel

Available tools

get_records

Query records with filtering, sorting, and pagination.

create_records

Create new records (up to 10 per request).

update_records

Update existing records (up to 10 per request).

delete_records

Delete records (up to 10 per request).

get_fields

Get field metadata from datasheets.

create_field

Create new fields in datasheets.

delete_field

Delete fields from datasheets.

get_views

Get views from datasheets.

create_datasheet

Create new datasheets with custom fields.

upload_attachment

Upload files to datasheets.

get_node_list

Get list of files in workspace.

search_nodes

Search nodes by type, permissions, and keywords.

get_node_detail

Get detailed information about specific nodes.

create_embed_link

Create embeddable links for nodes.

get_embed_links

List all embed links for a node.

delete_embed_link

Delete embed links.

formula_overview

Formula reference overview for quick guidance.

formula_operators

Operators used in AITable formulas.

formula_numeric

Numeric functions for AITable formulas.

formula_string

String functions for AITable formulas.

formula_logical

Logical functions for AITable formulas.

formula_date

Date/time functions for AITable formulas.

formula_array

Array functions for AITable formulas.

field_colors

Reference for field color options.