Skip to main content
Glama
TiDB MCP Server

TiDB MCP Server

by l1806858547

Сервер TiDB MCP

значок кузнеца

Сервер Model Context Protocol (MCP) для TiDB, позволяющий выполнять запросы SELECT с помощью инструментов MCP.

Функции

  • Выполнение запросов SELECT на TiDB

  • Безопасное соединение через переменные среды

  • Легкий и простой в использовании

Related MCP server: MCP Server for MySQL

Предпосылки

  • Node.js 16+

  • Экземпляр TiDB

Установка

Установка через Smithery

Чтобы автоматически установить TiDB Server для Claude Desktop через Smithery :

npx -y @smithery/cli install @l1806858547/tidb-server --client claude

Через npx

npx tidb-mcp-server

Глобальная установка

npm install -g tidb-mcp-server
tidb-mcp-server

Конфигурация

Перед запуском установите следующие переменные среды:

export TIDB_HOST="your_tidb_host"
export TIDB_PORT="your_tidb_port" 
export TIDB_USER="your_username"
export TIDB_PASS="your_password"
export TIDB_DB="your_database"

# Optional operation permissions (default: false)
export ALLOW_INSERT_OPERATION="false"  # Set to "true" to allow INSERT operations
export ALLOW_UPDATE_OPERATION="false"  # Set to "true" to allow UPDATE operations 
export ALLOW_DELETE_OPERATION="false"  # Set to "true" to allow DELETE operations

WARNING: Enabling these operations may expose your database to modification risks.
Only enable what you need and ensure proper access controls are in place.

Использование

  1. Запустите сервер:

tidb-server
  1. Добавьте в конфигурацию MCP (cline_mcp_settings.json):

{
  "mcpServers": {
    "tidb-server": {
      "command": "npx",
      "args": ["-y", "tidb-mcp-server"], # Also adding the -y flag for consistency
      "env": {
        "TIDB_HOST": "your_tidb_host",
        "TIDB_PORT": "your_tidb_port",
        "TIDB_USER": "your_username",
        "TIDB_PASS": "your_password",
        "TIDB_DB": "your_database"
      }
    }
  }
}
  1. Используйте инструмент MCP:

const result = await use_mcp_tool({
  server_name: 'tidb-server',
  tool_name: 'tidb_query', 
  arguments: {
    sql: 'SELECT * FROM your_table LIMIT 10'
  }
});

Разработка

  1. Клонируйте репозиторий:

git clone https://github.com/l1806858547/tidb-server.git
cd tidb-server
  1. Установить зависимости:

npm install
  1. Строить:

npm run build
  1. Бегать:

node build/index.js

Лицензия

Массачусетский технологический институт

Available Tools

1 tool
tidb_queryC

Execute SQL queries against TiDB

Inputs: sql (required).

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3/5.0

    Scored across 1 tool

    Disambiguation5/5

    With only one tool, there is no possibility of ambiguity or overlap between tools. The tool's purpose is clearly defined and distinct by default.

    Naming Consistency5/5

    A single tool inherently has perfect naming consistency, as there are no other tools to compare it against. The naming pattern is straightforward and clear.

    Tool Count2/5

    A single tool is too few for a database server like TiDB, which typically requires operations beyond just querying (e.g., schema management, data manipulation, administration). This minimal set severely limits functionality.

    Completeness1/5

    The tool surface is severely incomplete for a TiDB server. It only supports query execution, missing essential operations like creating/dropping tables, inserting/updating/deleting data, managing indexes, or handling transactions.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      A Model Context Protocol server that enables SQL query execution, database management, and business intelligence capabilities through MySQL connections.
      1,462 npm
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      A Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
      20,882 npm
      2,222
      MIT
    • A
      license
      B
      quality
      C
      maintenance
      A Model Context Protocol server that enables SQL operations (SELECT, INSERT, UPDATE, DELETE) and table management through a standardized interface with SQLite databases.
      7
      1
      ISC