Bitable
Interact with Lark Bitable tables and data using the Model Context Protocol.
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
"mcpServers": {
"bitable-mcp": {
"command": "uvx",
"args": ["bitable-mcp"],
"env": {
"PERSONAL_BASE_TOKEN": "your-personal-base-token",
"APP_TOKEN": "your-app-token"
}
}
}
- Using pip installation
- Install
bitable-mcp
via pip:
pip install bitable-mcp
- 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
Related Servers
Cloudera Iceberg MCP Server (via Impala)
Provides read-only access to Apache Iceberg tables using Apache Impala.
MCP Snowflake Reader
Read-only access to Snowflake databases. Requires Snowflake connection information provided via MCP client configuration.
CData CSV Files
A read-only MCP server for CSV files from CData, requiring an external JDBC driver for connection.
Unofficial Human Protein Atlas MCP Server
Access Human Protein Atlas data, including protein expression, localization, and pathology.
Google Directory by CData
A read-only MCP server for querying live Google Directory data using the CData JDBC Driver.
OceanBase
MCP Server for OceanBase database and its tools
Neon MCP Server
Interact with Neon Postgres databases using natural language to manage projects, branches, queries, and migrations via the Neon API.
Odoo Accounting MCP Server
Integrates with Odoo Accounting via XML-RPC, allowing AI tools to query and analyze account journal entries for auditing purposes.
MySQL MCP Server
Provides AI agents with direct access to query, search, and analyze MySQL databases.
FrankfurterMCP
MCP server acting as an interface to the Frankfurter API for currency exchange data.