Skip to main content
Glama
deenesjakoruzh

TiDB MCP Server

by l1806858547
npmGitHub
JavaScript
3
OverviewInspectNewEndpointsSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

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.

용법

  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

특허

MIT

Deploy Server
A
security – no known vulnerabilities
F
license - not found
A
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 데이터베이스에서 SELECT 쿼리를 실행할 수 있는 모델 컨텍스트 프로토콜 서버로, 명시적으로 활성화된 경우 INSERT, UPDATE, DELETE 작업을 선택적으로 지원합니다.

  1. 특징
    1. 필수 조건
      1. 설치
        1. Smithery를 통해 설치
        2. npx를 통해
        3. 글로벌 설치
      2. 구성
        1. 용법
          1. 개발
            1. 특허

              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 -

              • 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 -
                37

              • MSSQL MCP Server

                knight0zh
                A
                security
                A
                license
                A
                quality
                A Model Context Protocol server that enables executing SQL queries and managing connections with Microsoft SQL Server databases.
                Last updated -
                1
                56
                5
                MIT License

              • MSSQL MCP Server

                jensenloke
                -
                security
                F
                license
                -
                quality
                A 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 -
                7

              View all related MCP servers

              New MCP Servers

              MCP directory API

              We provide all the information about MCP servers via our MCP API.

              curl -X GET 'https://glama.ai/api/mcp/v1/servers/l1806858547/tidb-server'

              If you have feedback or need assistance with the MCP directory API, please join our Discord server