Mcp Server Tidb
What is Mcp Server Tidb
mcp-server-tidb is an implementation of an MCP server designed specifically for the TiDB (serverless) database, enabling seamless integration and management of database operations.
Use cases
Use cases for mcp-server-tidb include developing serverless applications that require a scalable database solution, managing data in cloud environments, and integrating with machine learning models that utilize TiDB for data storage.
How to use
To use mcp-server-tidb, clone the repository from GitHub, install the required packages using the uv package installer, and configure the necessary environment variables for your TiDB database. Finally, run the server with the appropriate command in your environment.
Key features
Key features include easy installation via uv, configuration through environment variables, support for running in various environments (including WSL), and integration with Claude Desktop for enhanced functionality.
Where to use
undefined
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Mcp Server Tidb
mcp-server-tidb is an implementation of an MCP server designed specifically for the TiDB (serverless) database, enabling seamless integration and management of database operations.
Use cases
Use cases for mcp-server-tidb include developing serverless applications that require a scalable database solution, managing data in cloud environments, and integrating with machine learning models that utilize TiDB for data storage.
How to use
To use mcp-server-tidb, clone the repository from GitHub, install the required packages using the uv package installer, and configure the necessary environment variables for your TiDB database. Finally, run the server with the appropriate command in your environment.
Key features
Key features include easy installation via uv, configuration through environment variables, support for running in various environments (including WSL), and integration with Claude Desktop for enhanced functionality.
Where to use
undefined
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
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" ] } } }
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
