aitable

This MCP server exposes a set of read and write tools for AITable.ai, enabling large language models and clients to discover spaces, search for nodes, read and filter records, retrieve field schemas, create new records, and upload attachments. The available tools include: list_spaces to enumerate workspaces accessible by the authenticated user; search_nodes to query nodes by type, permissions, and other criteria; list_records to fetch records from a database with pagination and optional field filtering and sorting; get_fields_schema to obtain the JSON schema for all fields in a database; create_record to insert a new record; and upload_attachment_via_url to attach a file from a URL. The update_record tool is currently marked as TODO and not available.

Prerequisites:

• Node.js and npm installed on your machine
• Access token for AITable (AITABLE_API_KEY)

Option A: Run directly with npx (no local install required)

• Ensure you have your AITable API key ready.
• Use the MCP runner config snippet provided in the documentation to point npx at this MCP server folder. Example:

# Replace with your absolute path to the parent folder of aitable-mcp-server
# and ensure your API key is available in the environment where you run it
npx -y /ABSOLUTE/PATH/TO/PARENT/FOLDER/aitable-mcp-server

Option B: Install locally (if you want to run from a local clone)

• From the repository root, install dependencies and build if applicable, then run the server entry point (the README indicates a dist/index.js is used by inspector tooling). Example steps:

# Clone the repository
git clone https://github.com/@apitable/aitable-mcp-server.git
cd aitable-mcp-server

# Install dependencies
npm install

# Start the server (adjust to your build output, e.g., node dist/index.js)
AITABLE_API_KEY=YOUR_API_KEY node dist/index.js

Note: The MCP inspector tooling can connect to this server directly via npx, as shown in the Debug section of the README. If you use a local clone, ensure you build the project (e.g., npm run build) if required by the repository setup.

Environment variables: AITABLE_API_KEY is required for authentication. AITABLE_BASE_URL defaults to https://aitable.ai/fusion but can be overridden if you are using the open-source APITable variant. The server supports several MCP tools, but remember that update_record is currently not implemented (marked as TODO). When running from different MCP clients (Claude Desktop, CherryStudio, etc.), you typically add an mcpServers entry under the client’s configuration with the appropriate command (npx for direct use, or cmd on Windows as demonstrated in the docs). If you encounter issues, verify that the absolute path to the server folder is correct and that your API key has the necessary permissions for the requested operations.