Lark Bitable

Lark Bitable

lloydzhou

Connects to Lark Bitable (a collaborative database platform) and lets you query structured data using SQL-like syntax through the Lark API.

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

2455 views5Local (stdio)

What it does

  • List tables in Lark Bitable workspaces
  • Inspect table schemas and columns
  • Execute SQL queries on Bitable data
  • Read structured data from collaborative tables

Best for

Teams using Lark for collaborative data managementAnalyzing data stored in Bitable tablesIntegrating Lark workspace data into workflows
SQL-like querying interfaceOne-click installation via Smithery

About Lark Bitable

Lark Bitable is a community-built MCP server published by lloydzhou that provides AI assistants with tools and capabilities via the Model Context Protocol. Connect to Lark Bitable for SQL-like queries on structured data. Easily list tables, inspect schemas, and read data with It is categorized under databases, analytics data.

How to install

You can install Lark Bitable in your AI client of choice. Use the install panel on this page to get one-click setup for Cursor, Claude Desktop, VS Code, and other MCP-compatible clients. This server runs locally on your machine via the stdio transport.

License

Lark Bitable is released under the MIT license. This is a permissive open-source license, meaning you can freely use, modify, and distribute the software.

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.

Bitable Server MCP server

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"
    }
  }
}
  1. Using pip installation
  1. Install bitable-mcp via pip:
pip install bitable-mcp
  1. 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

Alternatives

Related Skills

Browse all skills
literature-review

Conduct comprehensive, systematic literature reviews using multiple academic databases (PubMed, arXiv, bioRxiv, Semantic Scholar, etc.). This skill should be used when conducting systematic literature reviews, meta-analyses, research synthesis, or comprehensive literature searches across biomedical, scientific, and technical domains. Creates professionally formatted markdown documents and PDFs with verified citations in multiple citation styles (APA, Nature, Vancouver, etc.).

377
postgresql-psql

Comprehensive guide for PostgreSQL psql - the interactive terminal client for PostgreSQL. Use when connecting to PostgreSQL databases, executing queries, managing databases/tables, configuring connection options, formatting output, writing scripts, managing transactions, and using advanced psql features for database administration and development.

38
data-storytelling

Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.

27
content-trend-researcher

Advanced content and topic research skill that analyzes trends across Google Analytics, Google Trends, Substack, Medium, Reddit, LinkedIn, X, blogs, podcasts, and YouTube to generate data-driven article outlines based on user intent analysis

23
data-scientist

Expert data scientist for advanced analytics, machine learning, and statistical modeling. Handles complex data analysis, predictive modeling, and business intelligence. Use PROACTIVELY for data analysis tasks, ML modeling, statistical analysis, and data-driven insights.

13
google-analytics

Analyze Google Analytics data, review website performance metrics, identify traffic patterns, and suggest data-driven improvements. Use when the user asks about analytics, website metrics, traffic analysis, conversion rates, user behavior, or performance optimization.

13