TiDB
An MCP server for TiDB, a serverless, distributed SQL database.
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"
]
}
}
}
Related Servers
qmcp Server
An MCP server for integrating with and querying q/kdb+ databases.
Education Data MCP Server
Provides access to the Urban Institute's Education Data API for comprehensive education data.
MySQL MCP Server
Provides tools for AI assistants to interact with a MySQL database.
StockFlow
Provides real-time stock data and options analysis from Yahoo Finance, enabling market data access, stock analysis, and options strategy evaluation.
ODBC MCP Server
Enables LLM tools to query databases using ODBC connections.
Supabase MCP Server
A server for querying and managing data in a Supabase database.
Supabase Memory Service
A memory service using Supabase PostgreSQL with pgvector for semantic search and knowledge graph storage.
MySQL MCP Server
A MySQL server that connects to a database using environment variables for configuration.
Hasura GraphQL
Interact with a Hasura GraphQL endpoint, enabling schema introspection, queries, mutations, and data aggregation.
SQL Server
Enables AI assistants to access and query SQL Server databases.