TiDB MCP 서버

MCP 도구를 통해 SELECT 쿼리를 실행할 수 있는 TiDB용 MCP(Model Context Protocol) 서버입니다.

특징

TiDB에서 SELECT 쿼리 실행
환경 변수를 통한 보안 연결
가볍고 사용하기 쉬움

필수 조건

노드.js 16+
TiDB 인스턴스

설치

Smithery를 통해 설치

Smithery를 통해 Claude Desktop용 TiDB 서버를 자동으로 설치하려면:

지엑스피1

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.

용법

서버를 시작합니다:

tidb-server

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"
      }
    }
  }
}

MCP 도구를 사용하세요:

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

개발

저장소를 복제합니다.

git clone https://github.com/l1806858547/tidb-server.git
cd tidb-server

종속성 설치:

npm install

짓다:

npm run build

달리다:

node build/index.js

특허

MIT

Install Server

HTTP connection URL

security – no known vulnerabilities

license - not found

quality - confirmed to work

How are these scores calculated?

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

tidb_query

TiDB 데이터베이스에서 SELECT 쿼리를 실행할 수 있는 모델 컨텍스트 프로토콜 서버로, 명시적으로 활성화된 경우 INSERT, UPDATE, DELETE 작업을 선택적으로 지원합니다.

Related MCP Servers

MySQL-MCP
zajTools
-
security
F
license
-
quality
A Model Context Protocol server that enables SQL query execution, database management, and business intelligence capabilities through MySQL connections.
Last updated -
JavaScript
Database MCP Server
georgi-terziyski
-
security
-
license
-
quality
A Model Context Protocol server that provides tools for connecting to and interacting with various database systems (SQLite, PostgreSQL, MySQL/MariaDB, SQL Server) through a unified interface.
Last updated -
Python
SQLite MCP Server
isaacgounton
-
security
F
license
-
quality
A Model Context Protocol server that enables SQL operations (SELECT, INSERT, UPDATE, DELETE) and table management through a standardized interface with SQLite databases.
Last updated -
393
JavaScript
MSSQL MCP Server
knight0zh
-
security
A
license
-
quality
A Model Context Protocol server that enables executing SQL queries and managing connections with Microsoft SQL Server databases.
Last updated -
3
TypeScript
MIT License

View all related MCP servers

TiDB MCP Server

TiDB MCP 서버

특징

필수 조건

설치

Smithery를 통해 설치

npx를 통해

글로벌 설치

구성

용법

개발

특허

Tools

Related MCP Servers

MySQL-MCP

Database MCP Server

SQLite MCP Server

MSSQL MCP Server

New MCP Servers

MCP directory API