Bitable
What is Bitable
Bitable MCP Server is a server that provides access to Lark Bitable through the Model Context Protocol, enabling interaction with Bitable tables using predefined tools.
Use cases
This server can be used for managing and querying data in Bitable tables, making it useful for applications requiring data management, reporting, and data-driven decision making within collaborative environments.
How to use
Users can install the Bitable MCP Server easily via Smithery using a single command. Configuration requires setting personal base and app tokens to authenticate the server. After installation, users can utilize various commands to list tables, describe tables, or execute SQL queries.
Key features
Key features include listing available tables, providing detailed descriptions of table columns, and executing read queries via SQL to retrieve data from the tables in a structured format.
Where to use
The Bitable MCP Server can be used in environments where Lark Bitable is integrated, such as collaborative project management tools, data analysis platforms, and applications that require seamless data interaction and manipulation.
Overview
What is Bitable
Bitable MCP Server is a server that provides access to Lark Bitable through the Model Context Protocol, enabling interaction with Bitable tables using predefined tools.
Use cases
This server can be used for managing and querying data in Bitable tables, making it useful for applications requiring data management, reporting, and data-driven decision making within collaborative environments.
How to use
Users can install the Bitable MCP Server easily via Smithery using a single command. Configuration requires setting personal base and app tokens to authenticate the server. After installation, users can utilize various commands to list tables, describe tables, or execute SQL queries.
Key features
Key features include listing available tables, providing detailed descriptions of table columns, and executing read queries via SQL to retrieve data from the tables in a structured format.
Where to use
The Bitable MCP Server can be used in environments where Lark Bitable is integrated, such as collaborative project management tools, data analysis platforms, and applications that require seamless data interaction and manipulation.
Content
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.
- Parameters:
-
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.
- Parameters:
Manual installation and configuration
Please make sure uvx is installed before installation.
Add to your Claude settings:
- Using uvx
- Using pip installation
- Install
bitable-mcpvia pip:
pip install bitable-mcp
- Modify your Claude settings
Configure for Zed
Add to your Zed settings.json:
Using uvx
Using pip installation
Debugging
You can use the MCP inspector to debug the server. For uvx installations:
npx @modelcontextprotocol/inspector uvx bitable-mcp