Skip to main content
Glama
Sign In
deenesjakoruzh

TiDB MCP Server

by l1806858547
npmGitHub
JavaScript
16
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue
Integrations

  • Runs as a Node.js application, requiring Node.js 16+ to function.

TiDB MCP-Server

Ein Model Context Protocol (MCP)-Server für TiDB, der die Ausführung von SELECT-Abfragen über MCP-Tools ermöglicht.

Merkmale

  • Führen Sie SELECT-Abfragen auf TiDB aus
  • Sichere Verbindung über Umgebungsvariablen
  • Leicht und einfach zu bedienen

Voraussetzungen

  • Node.js 16+
  • TiDB-Instanz

Installation

Installation über Smithery

So installieren Sie den TiDB-Server für Claude Desktop automatisch über Smithery :

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

Über npx

npx tidb-mcp-server

Globale Installation

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

Konfiguration

Legen Sie vor dem Ausführen diese Umgebungsvariablen fest:

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.

Verwendung

  1. Starten Sie den Server:
tidb-server
  1. Zur MCP-Konfiguration hinzufügen (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. Verwenden Sie das MCP-Tool:
const result = await use_mcp_tool({ server_name: 'tidb-server', tool_name: 'tidb_query', arguments: { sql: 'SELECT * FROM your_table LIMIT 10' } });

Entwicklung

  1. Klonen Sie das Repo:
git clone https://github.com/l1806858547/tidb-server.git cd tidb-server
  1. Installieren Sie Abhängigkeiten:
npm install
  1. Bauen:
npm run build
  1. Laufen:
node build/index.js

Lizenz

MIT

You must be authenticated.

A
security – no known vulnerabilities
F
license - not found
A
quality - confirmed to work

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

Ein Model Context Protocol-Server, der die Ausführung von SELECT-Abfragen in TiDB-Datenbanken ermöglicht, mit optionaler Unterstützung für INSERT-, UPDATE- und DELETE-Operationen, wenn diese explizit aktiviert sind.

  1. Merkmale
    1. Voraussetzungen
      1. Installation
        1. Installation über Smithery
        2. Über npx
        3. Globale Installation
      2. Konfiguration
        1. Verwendung
          1. Entwicklung
            1. Lizenz

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

              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