AITable Mcp Server

Name: AITable Mcp Server
Author: apitable

@apitable

Repository

About AITable Mcp Server

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

#aitable #mcp #datasheets

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "aitable": {
      "command": "npx",
      "args": [
        "-y",
        "@apitable/aitable-mcp-server"
      ],
      "env": {
        "AITABLE_API_KEY": "YOUR_API_KEY"
      }
    }
  }
}

Tools

Fetches all workspaces that the currently authenticated user has permission to access.

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.

Read the records from a specified datasheet with support for pagination, field filtering, and sorting options.

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 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 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.

Overview

What is AITable Mcp Server?

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

How to use AITable Mcp Server?

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.

Key features of AITable Mcp Server

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.

Use cases of AITable Mcp Server

An LLM managing an AITable workspace by listing spaces and searching for relevant nodes.
Automatically creating records and uploading attachments from external URLs.
Querying database records with filters and sorting to answer user questions.
Inspecting the field schema of a database before performing write operations.