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 💡
@CaesarYangs/prometheus_mcp_server
An MCP server that enables LLMs to query, analyze, and interact with Prometheus databases through predefined routes.
mcp-snowflake-reader
A read-only MCP server providing secure access to Snowflake databases via MCP protocol
xiangmy21/iotdb-mcp-server-TreeModel
A Model Context Protocol (MCP) server implementation for IoTDB that enables SQL query capabilities including metadata and select queries
@bytebase/dbhub
Universal database MCP server connecting to MySQL, PostgreSQL, SQL Server, MariaDB.
mcp-mysql-server
A Python-based MCP server for interacting with a local MySQL database via stdio, offering query execution, schema inspection, and data manipulation.
@niledatabase/nile-mcp-server
MCP server for Nile Database - Manage and query databases, tenants, users, auth using LLMs