Bitable MCP

What is bitable-mcp?

bitable-mcp is an MCP (Model Context Protocol) server that provides access to Lark Bitable, a collaborative online database, allowing users to interact with Bitable tables using predefined tools. It acts as a bridge between applications like Claude Desktop and Lark Bitable.

How to use bitable-mcp?

bitable-mcp can be installed and configured in several ways:

• One-click installation via Smithery: Use the provided npx command to automatically install for Claude Desktop.
• Direct installation for Claude: Set PERSONAL_BASE_TOKEN and APP_TOKEN environment variables and run the uv run command.
• Manual installation (uvx): Add bitable-mcp to your Claude or Zed settings with uvx as the command.
• Manual installation (pip): Install bitable-mcp via pip and configure your Claude or Zed settings to use python -m bitable_mcp as the command.

Key Features of bitable-mcp

• Lark Bitable Integration: Seamlessly connects with Lark Bitable for data access.
• Model Context Protocol (MCP) Server: Enables interaction with Bitable through a standardized protocol.
• Predefined Tools: Offers tools for common Bitable operations:
  • list_table: Lists tables in the current Bitable.
  • describe_table: Describes a table by its name, returning column information.
  • read_query: Executes SQL queries to read data from tables.
• Multiple Installation Options: Supports Smithery, direct command-line, uvx, and pip installations.
• Configuration for various clients: Provides configuration examples for Claude and Zed.

Use Cases of bitable-mcp

• Automated Data Retrieval: Programmatically access and retrieve data from Lark Bitable tables.
• Integration with AI Assistants: Allow AI models (like those using Claude or Cursor) to interact with and query Bitable data.
• Custom Application Development: Build applications that leverage Bitable as a backend database through the MCP.
• Data Analysis and Reporting: Extract data from Bitable for further analysis or to generate reports.

FAQ about bitable-mcp

• What is Lark Bitable? Lark Bitable is a collaborative online database that allows users to create, manage, and share structured data.
• What is MCP? MCP stands for Model Context Protocol, a protocol that allows models (like AI models) to interact with external tools and services.
• How do I get PERSONAL_BASE_TOKEN and APP_TOKEN? These tokens are specific to your Lark Bitable application and need to be obtained from your Lark Bitable account settings.
• How can I debug bitable-mcp? You can use the MCP inspector with npx @modelcontextprotocol/inspector uvx bitable-mcp for debugging uvx installations.

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