TiDB FAQs

Question 1

What is TiDB MCP Server?

Accepted Answer

It's a Model Context Protocol (MCP) server that enables you to execute SELECT queries on your TiDB instance through MCP tools, providing a lightweight and secure way to interact with your database.

Question 2

Does TiDB MCP Server integrate with Smithery?

Accepted Answer

Yes, it's designed to integrate seamlessly with Smithery. You can even install it automatically using the Smithery CLI.

Question 3

What are the prerequisites for using TiDB MCP Server?

Accepted Answer

You'll need Node.js 16+ and a running TiDB instance. Make sure to configure your environment variables (TIDB_HOST, TIDB_PORT, etc.) to connect to your database.

Question 4

How do I configure the server to allow INSERT, UPDATE, or DELETE operations?

Accepted Answer

You can set the environment variables ALLOW_INSERT_OPERATION, ALLOW_UPDATE_OPERATION, and ALLOW_DELETE_OPERATION to 'true'. However, be extremely cautious as enabling these operations can expose your database to security risks. Ensure proper access controls are in place.

Question 5

How do I install TiDB MCP Server?

Accepted Answer

You can install it via Smithery, using npx, or globally with npm. The README provides detailed installation instructions for each method.

TiDB

主な機能

ユースケース

TiDB

主な機能

ユースケース