AITable MCP Server

A Model Context Protocol (MCP) server for AITable with dual transport support:

• stdio - for local use with Claude Desktop

• HTTP (Streamable) - for remote use / deployment

Features

16 Available Tools

Records Management:

• get_records - Get records from datasheets (up to 1000 per request, 11 query parameters)

• 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)

Fields Management:

• get_fields - Get field metadata from datasheets

• create_field - Create new fields in datasheets

• delete_field - Delete fields from datasheets

Views & Datasheets:

• get_views - Get views from datasheets

• create_datasheet - Create new datasheets with custom fields

Attachments:

• upload_attachment - Upload files to datasheets

Nodes & Workspace:

• get_node_list - Get list of files in workspace (Fusion API v3)

• search_nodes - Search nodes by type, permissions, and keywords (v2)

• get_node_detail - Get detailed information about specific nodes

Embed Links:

• create_embed_link - Create embeddable links for nodes

• get_embed_links - List all embed links for a node (up to 30)

• delete_embed_link - Delete/disable embed links

Important Notes

Default Field Names: When creating datasheets without specifying fields, AITable auto-generates 3 default fields with Chinese names (选项, 标题, 附件). To ensure English field names, always specify fields explicitly when using create_datasheet.

File Upload Requirements:

• Use absolute file paths when uploading attachments (e.g., C:/Users/YourName/Documents/file.pdf)

• Maximum file size: 1 GB per attachment

• Only one file can be uploaded per API call

• Supported formats: Images, PDFs, documents, and other common file types

Setup

1. Install dependencies:

2. Configure environment variables:

Copy .env.example to .env:

Then edit .env with your credentials:

3. Build the project:

Usage

Option 1: stdio Server (for Claude Desktop)

Configure Claude Desktop (~/Library/Application Support/Claude/claude_desktop_config.json on macOS or %APPDATA%\Claude\claude_desktop_config.json on Windows):

Production (recommended):

Development mode with tsx:

After configuration:

1. Save the config file

2. Restart Claude Desktop

3. Claude will now have access to all 16 AITable tools

Option 2: HTTP Server (for remote access)

Local Development:

The server will run at http://localhost:3000/mcp.

Test with the client:

Option 3: Deploy to Vercel

1. Install Vercel CLI:

2. Deploy:

3. Set environment variables in Vercel Dashboard:

   • Go to your project settings

   • Add AITABLE_API_TOKEN

   • Add SPACE_ID

4. Your MCP server will be available at:

Health check endpoint:

Development

Build TypeScript:

Run stdio server (development):

Run HTTP server (development):

Test with client:

Project Structure

API Rate Limits

AITable has different rate limits based on your plan:

• Free: 2 QPS

• Plus: 5 QPS

• Pro: 10 QPS

• Enterprise: 20 QPS

License

MIT