home / mcp / aitable mcp server

AITable MCP Server

AITable.ai Model Context Protocol Server enables AI agents to connect and work with AITable datasheets.

Installation

Add the following to your MCP client configuration file.

Configuration

{
  "mcpServers": {
    "apitable-aitable-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "/ABSOLUTE/PATH/TO/PARENT/FOLDER/aitable-mcp-server"
      ],
      "env": {
        "AITABLE_API_KEY": "YOUR_API_KEY"
      }
    }
  }
}

AITable MCP Server is a Model Context Protocol endpoint that lets language models read and write data in AITable.ai. It enables you to list spaces, search nodes, manage records, and upload attachments directly from MCP-enabled clients.

How to use

Connect your MCP client (such as Claude Desktop or CherryStudio) to the AITable MCP Server by configuring the MCP client’s mcpServers section with the following stdio configurations. You will provide your API key and point the client to the local MCP server you run or host.

How to install

Prerequisites you need before using the AITable MCP Server:

- Node.js installed on your machine (Node 14+ recommended). You will use npm or npx to run MCP server integrations.

- An AITable personal access token to access AITable.ai via the MCP server.

Configuration and usage notes

The MCP server provides a ready-made JSON configuration snippet you can place in your MCP client. There are two equivalent examples shown for different operating systems to start the server via npx.

{
  "mcpServers": {
    "aitable": {
      "command": "npx",
      "args": [
        "-y",
        "/ABSOLUTE/PATH/TO/PARENT/FOLDER/aitable-mcp-server"
      ],
      "env": {
        "AITABLE_API_KEY": "YOUR_API_KEY"
      }
    }
  }
}

Windows configuration example

{
  "mcpServers": {
    "aitable": {
      "command": "npx",
      "args": [
        "-y",
        "D:\\ABSOLUTE\\PATH\\TO\\PARENT\\FOLDER\\aitable-mcp-server"
      ],
      "env": {
        "AITABLE_API_KEY": "YOUR_API_KEY"
      }
    }
  }
}

Security and troubleshooting

Keep your AITable API key secure. Do not share the key or publish it in logs or screenshots. If you need to rotate keys, update the key in your MCP client configuration and reload the MCP server connection.

If the MCP client cannot connect, verify that the AITable_API_KEY environment variable is correctly supplied in the client configuration and that the path to the AITable MCP server is accessible from your environment.

Supported actions with the AITable MCP Server

Using the configured server, you can perform the following actions through MCP-enabled clients: list spaces, search nodes, list records, get field schemas, create records, and upload attachments.

Available tools

list_spaces

Fetches all workspaces the authenticated user can access.

search_nodes

Retrieves nodes based on types, permissions, and queries.

list_records

Reads records from a specified database with pagination, filtering, and sorting.

get_fields_schema

Returns the JSON schema of all fields within a database.

create_record

Creates a new record in the database.

upload_attachment_via_url

Uploads an attachment to AITable via a web URL.