mcp-server-tidb

What is mcp-server-tidb?

mcp-server-tidb is an MCP (Model Context Protocol) server implementation that connects AI assistants (like Claude) to TiDB Serverless databases. It enables natural language interactions with TiDB by exposing database operations as tools through the MCP standard. This server is for developers who want to query and manage TiDB databases via AI chat interfaces.

How to use mcp-server-tidb?

To use, first install the package using uv (Python package installer): clone the repository, create a virtual environment, and install dependencies with uv pip install -e .. Then configure environment variables (or a .env file) with your TiDB connection details (host, port, username, password, database). Finally, add the server configuration to Claude Desktop’s claude_desktop_config.json, pointing uv to the src/main.py entry point.

Key features of mcp-server-tidb

• MCP server for TiDB (serverless) database integration
• Easy installation with uv package manager
• Configuration via environment variables or .env file
• Works with Claude Desktop out of the box
• Supports WSL (Windows Subsystem for Linux) setups

Use cases of mcp-server-tidb

• Query TiDB databases using natural language through Claude
• Manage database records with conversational AI assistants
• Develop AI-powered data analysis tools backed by TiDB

FAQ from mcp-server-tidb

What is mcp-server-tidb?

It is an MCP server that provides a bridge between AI assistants (such as Claude) and TiDB Serverless databases, allowing database operations to be performed through natural language conversations.

How do I install mcp-server-tidb?

Clone the repository, create a Python virtual environment with uv venv, then install the package using uv pip install -e .. You need uv installed on your system.

How do I configure the server to connect to my TiDB database?

Set the environment variables TIDB_HOST, TIDB_PORT, TIDB_USERNAME, TIDB_PASSWORD, and TIDB_DATABASE (or create a .env file with these values). You must first create a free TiDB Serverless cluster at tidbcloud.com.

How do I run mcp-server-tidb with Claude Desktop?

Add a entry to claude_desktop_config.json with the command uv and arguments --directory /path/to/mcp-server-tidb run src/main.py. See the MCP quickstart guide for details.

What if I’m using WSL (Windows Subsystem for Linux)?

Use wsl.exe as the command in the configuration, then pass the bash command that activates the environment, e.g., bash -c "/path/to/uv --directory /path/to/mcp-server-tidb run python src/main.py".