The TiDB MCP Server enables executing SQL queries against a TiDB database instance via the Model Context Protocol (MCP).
- Execute SQL Queries: Run SELECT statements by default on a TiDB database
- Additional Operations: Optionally perform INSERT, UPDATE, and DELETE operations when configured
- Secure Configuration: Configure connections securely using environment variables
- Lightweight: Simple installation and configuration process, supporting npx or global npm installation
Runs as a Node.js application, requiring Node.js 16+ to function.
TiDB MCP Server
A Model Context Protocol (MCP) server for TiDB that allows executing SELECT queries through MCP tools.
Features
- Execute SELECT queries on TiDB
- Secure connection via environment variables
- Lightweight and easy to use
Prerequisites
- Node.js 16+
- TiDB instance
Installation
Installing via Smithery
To install TiDB Server for Claude Desktop automatically via Smithery:
Via npx
Global installation
Configuration
Set these environment variables before running:
Usage
- Start the server:
- Add to MCP configuration (cline_mcp_settings.json):
- Use the MCP tool:
Development
- Clone the repo:
- Install dependencies:
- Build:
- Run:
License
MIT
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
Tools
A Model Context Protocol server that allows executing SELECT queries on TiDB databases, with optional support for INSERT, UPDATE, and DELETE operations when explicitly enabled.
Related MCP Servers
- -securityFlicense-qualityA Model Context Protocol server that enables SQL query execution, database management, and business intelligence capabilities through MySQL connections.Last updated -JavaScript
- -securityFlicense-qualityA Model Context Protocol server that enables SQL operations (SELECT, INSERT, UPDATE, DELETE) and table management through a standardized interface with SQLite databases.Last updated -45JavaScript
- AsecurityAlicenseAqualityA Model Context Protocol server that enables executing SQL queries and managing connections with Microsoft SQL Server databases.Last updated -1425TypeScriptMIT License
- -securityFlicense-qualityA Model Context Protocol server that provides comprehensive access to Microsoft SQL Server databases, enabling Language Models to inspect schemas, execute queries, manage database objects, and perform advanced database operations.Last updated -6Python