Lark Bitable

by lloydzhou

2 stars
4.4k downloads
Not rated
GitHub

About

Connects to Lark Bitable for SQL-like querying of structured data, enabling table listing, schema inspection, and read operations using Lark API credentials.

Details

Author
lloydzhou
Repository
lloydzhou/bitable-mcp
GitHub stars
2
Downloads
4,361
Categories
Database, Other, Productivity, Developer Tools, Design, AI, Search, Infrastructure, API

- list_table – list tables in the current Bitable.
- describe_table – describe a table by name with column info.
- read_query – execute SQL queries

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:

  1. Download and install Highlight from highlightai.com/download
  2. Navigate to the plugins tab and select "Add Custom Plugin"
  3. Configure the plugin with the settings below
    Plugin Name Lark Bitable
    Command (node, npx, python, etc.) uvx
    Arguments
    • Argument 1 bitable-mcp
    Environment
    • APP_TOKEN your-app-token
    • PERSONAL_BASE_TOKEN your-personal-base-token

    Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.

  4. Enable "Start Automatically" if you want the plugin to start when Highlight launches

From the repository

To install Bitable Server for Claude Desktop automatically via Smithery:

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

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"
    }
  }
}

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"
    }
  }
},

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.

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

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

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

Linux

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

Macos

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

Windows

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

MseeP.ai Security Assessment Badge

Bitable MCP Server

smithery badge

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

<a href="https://glama.ai/mcp/servers/@lloydzhou/bitable-mcp">
Bitable Server MCP server
</a>

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
No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.