Advertise
MCP.so
Sign In

TiDB MCP Server

@l1806858547

Repository

Basic information

Category

Other

Transports

stdio

Author

l1806858547

About TiDB MCP Server

TiDB MCP Server

TiDB MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "tidb-server": {
      "command": "npx",
      "args": [
        "tidb-mcp-server"
      ]
    }
  }
}

TiDB MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

What is TiDB MCP Server?

A Model Context Protocol (MCP) server that enables AI assistants to execute SELECT queries on a TiDB database through MCP tools. It uses environment variables for secure connection and is intended for developers integrating TiDB querying into MCP-compatible clients.

How to use TiDB MCP Server?

Install via Smithery, npx, or global npm. Set required environment variables (TIDB_HOST, TIDB_PORT, TIDB_USER, TIDB_PASS, TIDB_DB); optionally enable INSERT/UPDATE/DELETE by setting the respective variables to "true". Start the server with tidb-server, add it to your MCP client configuration (e.g., cline_mcp_settings.json), then call the tidb_query tool with an SQL argument.

Key features of TiDB MCP Server

  • Execute SELECT queries on TiDB via MCP tools.
  • Secure connection through environment variables.
  • Lightweight and easy to set up.
  • Optional support for INSERT, UPDATE, DELETE (disabled by default).
  • Compatible with Claude Desktop via Smithery.

Use cases of TiDB MCP Server

  • Query a TiDB database from within an AI assistant conversation.
  • Enable read-only data exploration for LLM applications.
  • Perform safe database lookups with default read-only mode.
  • Quickly prototype MCP-based integrations with TiDB.

Frequently asked questions

1

What runtime is required?

Node.js version 16 or higher, and a running TiDB instance.

2

How do I configure connection credentials?

Set the environment variables `TIDB_HOST`, `TIDB_PORT`, `TIDB_USER`, `TIDB_PASS`, and `TIDB_DB`. These are read at startup.

3

Can the server perform write operations?

By default, only SELECT queries are allowed. To enable INSERT, UPDATE, or DELETE, set the corresponding environment variable (e.g., `ALLOW_INSERT_OPERATION`) to `"true"`. These are disabled by default to prevent accidental modifications.

4

How do I integrate this server with an MCP client?

Add the server to your MCP

Comments

More Other MCP servers

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

Codelf

unbug

A search tool helps dev to solve the naming things problem.

14.2K

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Advertise