AITable Mcp Server
About
AITable.ai Model Context Protocol Server enables AI agents to connect and work with AITable datasheets.
Details
- Author
- apitable
- Downloads
- 322
- Categories
- Database, Other, Communication, Project Management
Jump to
- List all workspaces accessible to the authenticated user.
- Search nodes by type, permission, and query.
- Read records with pagination, field filtering, and sorting.
- Get the JSON schema of all fields in a database.
- Create new records in a database.
- Upload attachments via a web URL.
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
AITable Mcp ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Set the AITABLE_API_KEY environment variable with your personal access token, and optionally AITABLE_BASE_URL (defaults to https://aitable.ai/fusion). Then add a configuration entry for the server in your MCP client (e.g., Claude Desktop or CherryStudio) using the npx command with the path to the server folder.
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. Nodes in AITable can be of several types: datasheets (also known as sheets, or spreadsheets), form, dashboard, and folders.
list_records
Read the records from a specified datasheet with support for pagination, field filtering, and sorting options.
get_fields_schema
Returns the JSON schema of all fields within the specified database, This schema will be sent to LLM to help the AI understand the expected structure of the data.
create_record
Create a new record in the datasheet. Extract key information from user-provided text based on a predefined Fields JSON Schema and create a new record in the datasheet as a JSON object.
upload_attachment_via_url
Upload an attachment to the AITable server using its web URL. Returns storage information that can be passed to create_record or update_record tools to associate with a specific records.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"aitable mcp server": {
"aitable": {
"command": "npx",
"args": [
"-y",
"@apitable/aitable-mcp-server"
],
"env": {
"AITABLE_API_KEY": "YOUR_API_KEY"
}
}
}
}
}McpServers
{
"aitable": {
"command": "npx",
"args": [
"-y",
"@apitable/aitable-mcp-server"
],
"env": {
"AITABLE_API_KEY": "YOUR_API_KEY"
}
}
}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}
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
