MCP Server Tidb

1# mcp-server-tidb
2 
3MCP server implementation for TiDB (serverless) database.
4 
5## Prerequisites
6 
7- uv (Python package installer)
8 
9## Installation
10 
11```
12# Clone the repository
13git clone https://github.com/c4pt0r/mcp-server-tidb
14cd mcp-server-tidb
15 
16# Install the package and dependencies using uv
17uv venv
18uv pip install -e .
19```
20 
21## Configuration
22 
23Go [tidbcloud.com](https://tidbcloud.com) to create a free TiDB database cluster
24 
25Configuration can be provided through environment variables, or using .env:
26- `TIDB_HOST` - TiDB host address, e.g. 'gateway01.us-east-1.prod.aws.tidbcloud.com'
27- `TIDB_PORT` - TiDB port (default: 4000)
28- `TIDB_USERNAME` - Database username, e.g.  'xxxxxxxxxx.\<username\>'
29- `TIDB_PASSWORD` - Database password
30- `TIDB_DATABASE` - Database name, default is test
31 
32## Run with Claude Desktop
33 
34Config Claude Desktop, [HOWTO](https://modelcontextprotocol.io/quickstart/user)
35 
36`claude_desktop_config.json`:
37 
38```
39{
40  "mcpServers": {
41      "tidb": {
42          "command": "uv",
43          "args": [
44              "--directory",
45              "/path/to/mcp-server-tidb",
46              "run",
47              "src/main.py"
48          ]
49      }
50  }
51}
52```
53 
54 
55If you're running mcp-server-tidb in WSL, the `claude_desktop_config.json` should look like this:
56 
57```
58{
59  "mcpServers": {
60    "tool-with-env-vars": {
61      "command": "wsl.exe",
62      "args": [
63        "bash",
64        "-c",
65        "/path/to/uv --directory /path/to/mcp-server-tidb run python src/main.py"
66      ]
67    }
68  }
69}
70```
71