mcp-server-tidb
MCP server implementation for TiDB (serverless) database.
Prerequisites
- uv (Python package installer)
Installation
# Clone the repository
git clone https://github.com/c4pt0r/mcp-server-tidb
cd mcp-server-tidb
# Install the package and dependencies using uv
uv venv
uv pip install -e .
Configuration
Go tidbcloud.com to create a free TiDB database cluster
Configuration can be provided through environment variables, or using .env:
TIDB_HOST- TiDB host address, e.g. 'gateway01.us-east-1.prod.aws.tidbcloud.com'TIDB_PORT- TiDB port (default: 4000)TIDB_USERNAME- Database username, e.g. 'xxxxxxxxxx.\<username\>'TIDB_PASSWORD- Database passwordTIDB_DATABASE- Database name, default is test
Run with Claude Desktop
Config Claude Desktop, HOWTO
claude_desktop_config.json:
{
"mcpServers": {
"tidb": {
"command": "uv",
"args": [
"--directory",
"/path/to/mcp-server-tidb",
"run",
"src/main.py"
]
}
}
}
If you're running mcp-server-tidb in WSL, the claude_desktop_config.json should look like this:
{
"mcpServers": {
"tool-with-env-vars": {
"command": "wsl.exe",
"args": [
"bash",
"-c",
"/path/to/uv --directory /path/to/mcp-server-tidb run python src/main.py"
]
}
}
}
Recommend MCP Servers 💡
benborla/mcp-server-mysql
A Model Context Protocol server enabling LLMs to inspect MySQL database schemas and execute SQL queries.
mcp-trino
A high-performance MCP server for Trino implemented in Go, enabling AI assistants to interact with Trino's distributed SQL query engine through standardized MCP tools.
mcp-odbc-server
Typescript based Model Context Procotol (MCP) Server for Open Database Connectivity (ODBC)
@xexr/mcp-libsql
A secure Model Context Protocol (MCP) server for libSQL databases, offering comprehensive tools, connection pooling, and transaction support, built with TypeScript for various MCP clients.
go-mcp-mysql
A zero-burden, ready-to-use Model Context Protocol (MCP) server written in Go for interacting with MySQL databases, supporting CRUD operations and automation without Node.js or Python.
mcp-server-vikingdb
a mcp server for vikingdb store and search