Bitable MCP

What is Bitable MCP about?

Bitable MCP enables interaction with Lark Bitable spreadsheets through a set of predefined tools. Users can list available tables, retrieve column definitions, and execute SQL‑like read queries, all returned as JSON.

How to use Bitable MCP?

1. One‑click installation (Smithery)

   npx -y @smithery/cli install @lloydzhou/bitable-mcp --client claude
   

2. Manual installation (Python/uvx)

   # Using uvx (recommended)
   uv run --with uv --with bitable-mcp bitable-mcp-install
   # Or via pip
   pip install bitable-mcp
   

3. Configure environment variables

   {
     "PERSONAL_BASE_TOKEN": "your-personal-base-token",
     "APP_TOKEN": "your-app-token"
   }
   

4. Add to Claude (or Zed) settings – refer to the README for the exact JSON structure.
5. Invoke tools through the MCP client (e.g., Claude) using the tool names list_table, describe_table, and read_query.

Key Features

• list_table: Returns a JSON array of all table names in the current Bitable.
• describe_table: Accepts a table name and returns its column schema as JSON.
• read_query: Executes arbitrary SQL‑style read queries against the Bitable data and returns results in JSON.
• Supports both uvx and pip installation methods.
• Ready‑to‑use with Claude Desktop, Zed, and other MCP‑compatible clients.

Use Cases

• Quickly extract structured data from Bitable for downstream analytics.
• Build AI agents that need to reference or manipulate spreadsheet data without manual API calls.
• Automate reporting by querying Bitable tables with familiar SQL syntax.
• Integrate Bitable data into custom workflows within Claude or other AI assistants.

FAQ

Q: Which tokens are required? A: PERSONAL_BASE_TOKEN (your Lark personal base token) and APP_TOKEN (the Bitable app token).

Q: Can I run the server locally? A: Yes. After installation, start the server via the provided CLI command (bitable-mcp or python -m bitable_mcp).

Q: Is there support for other clients like Cursor or Windsurf? A: The README notes “Coming soon” for those clients.

Q: How do I debug the server? A: Use the MCP inspector, e.g., npx @modelcontextprotocol/inspector uvx bitable-mcp.

Q: Do I need Node.js? A: No. The core package is Python‑based; Node.js is only required for the optional Smithery installer.

Bitable MCP Server

This MCP server provides access to Lark Bitable through the Model Context Protocol. It allows users to interact with Bitable tables using predefined tools.

One click installation & Configuration

Installing via Smithery

To install Bitable Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @lloydzhou/bitable-mcp --client claude

Claude

To install and configure the server, use the following command:

PERSONAL_BASE_TOKEN=your_personal_base_token APP_TOKEN=your_app_token uv run --with uv --with bitable-mcp bitable-mcp-install

Replace your_personal_base_token and your_app_token with your actual tokens.

Cursor

Coming soon

Windsurf

Coming soon

Available Tools

• list_table - List tables for the current Bitable.

  • Returns: A JSON-encoded list of table names.

• describe_table - Describe a table by its name.

  • Parameters:
    • name (str): The name of the table to describe.
  • Returns: A JSON-encoded list of columns in the table.

• read_query - Execute a SQL query to read data from the tables.

  • Parameters:
    • sql (str): The SQL query to execute.
  • Returns: A JSON-encoded list of query results.

Manual installation and configuration

Please make sure uvx is installed before installation.

Add to your Claude settings:

1. Using uvx

"mcpServers": {
  "bitable-mcp": {
    "command": "uvx",
    "args": ["bitable-mcp"],
    "env": {
        "PERSONAL_BASE_TOKEN": "your-personal-base-token",
        "APP_TOKEN": "your-app-token"
    }
  }
}

2. Using pip installation

1. Install bitable-mcp via pip:

pip install bitable-mcp

2. Modify your Claude settings

"mcpServers": {
  "bitable-mcp": {
    "command": "python",
    "args": ["-m", "bitable_mcp"],
    "env": {
        "PERSONAL_BASE_TOKEN": "your-personal-base-token",
        "APP_TOKEN": "your-app-token"
    }
  }
}

Configure for Zed

Add to your Zed settings.json:

Using uvx

"context_servers": [
  "bitable-mcp": {
    "command": "uvx",
    "args": ["bitable-mcp"],
    "env": {
        "PERSONAL_BASE_TOKEN": "your-personal-base-token",
        "APP_TOKEN": "your-app-token"
    }
  }
],

Using pip installation

"context_servers": {
  "bitable-mcp": {
    "command": "python",
    "args": ["-m", "bitable_mcp"],
    "env": {
        "PERSONAL_BASE_TOKEN": "your-personal-base-token",
        "APP_TOKEN": "your-app-token"
    }
  }
},

Debugging

You can use the MCP inspector to debug the server. For uvx installations:

npx @modelcontextprotocol/inspector uvx bitable-mcp