
Lark Bitable
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.
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
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.
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-mcpvia 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
Alternatives
Related Skills
Browse all skillsConduct 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.).
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.
Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive presentations.
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
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.
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.
