AITable MCP Server

A Model Context Protocol server that provides read and write access to AITable.ai. This server enables LLMs to list spaces, search nodes, list records, create records and upload attachments in AITable.ai.

Tools

Tool Name	Availabe	Description
list_spaces	✅	Fetches all workspaces that the currently authenticated user has permission to access.
search_nodes	✅	Retrieve nodes based on specific types, permissions, and queries.
list_records	✅	Read the records from a specified database with support for pagination, field filtering, and sorting options.
get_fields_schema	✅	Returns the JSON schema of all fields within the specified database
create_record	✅	Create a new record in the database.
upload_attachment_via_url	✅	Upload an attachment to the AITable server using its web URL.
update_record	❌	TODO

Environment Variables

AITABLE_API_KEY: Your AITable personal access token.
AITABLE_BASE_URL: The base URL of the AITable API. Defaults to https://aitable.ai/fusion. You can set it to {YOUR_CUSTOM_BASE_URL} if you are using the APITable(the open-source version of AITable).

Usage

You can use this server in MCP client such as Claude Desktop, CherryStudio, etc.

Claude Desktop In the case of Claude Desktop, you need to add the following configuration information to the "mcpServers" section of the claude_desktop_config.json file:

For Linux, MacOS:

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

For Windows:

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

Replace YOUR_API_KEY with your AITable personal access token and /ABSOLUTE/PATH/TO/PARENT/FOLDER/aitable-mcp-server with the absolute path to the parent folder of this repository.

CherryStudio If you are using the CherryStudio as MCP client and Windows system, your configuration should look like this:

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

Debug

The MCP inspector is a developer tool for testing and debugging MCP servers.

To inspect an MCP server implementation, there's no need to clone the MCP inspector repo. Instead, use npx. For example, AITable MCP server is built at dist/index.js. Arguments are passed directly to your server, while environment variables can be set using the -e flag:

npx @modelcontextprotocol/inspector -e AITABLE_API_KEY={YOUR_API_KEY} node build/index.js

The other way is to clone the MCP inspector repo and connect the AITable MCP server in the inspector interface.

cd path/to/inspector/
npm start -- -e AITABLE_API_KEY={YOUR_API_KEY}

Install Server

HTTP connection URL

security – no known vulnerabilities

license - permissive license

quality - confirmed to work

How are these scores calculated?

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

Tools

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

Related MCP Servers

MCP MySQL Server
Atomzzm
-
security
-
license
-
quality
A Model Context Protocol server that enables AI models to interact with MySQL databases, providing tools for querying, executing statements, listing tables, and describing table structures.
Last updated -
MIT License
MCP Toolkit
zxfgds
-
security
F
license
-
quality
A comprehensive Model Context Protocol server implementation that enables AI assistants to interact with file systems, databases, GitHub repositories, web resources, and system tools while maintaining security and control.
Last updated -
16
TypeScript
MySQL MCP Server
michael7736
A
security
F
license
A
quality
A Model Context Protocol server that allows AI agents to execute SQL queries against a MySQL database, supporting operations like reading data, creating tables, inserting, updating, and deleting records.
Last updated -
6
419
1
JavaScript
CodeAlive MCPofficial
CodeAlive-AI
-
security
A
license
-
quality
A Model Context Protocol server that enhances AI agents by providing deep semantic understanding of codebases, enabling more intelligent interactions through advanced code search and contextual awareness.
Last updated -
48
Python
MIT License

View all related MCP servers

AITable MCP Server