mcp-tm 0.2.0

Add your description here

MySQL + Feishu MCP Tool

This package provides a Model Context Protocol (MCP) server with:

• Read-only MySQL query capability.
• Feishu remote MCP connection capability.

Features

• Read-only Access: Only allows SELECT and SHOW statements for SQL safety.
• MySQL SSL Support: Supports SSL connections for cloud databases.
• Feishu Remote MCP: Supports initialize, tools/list, and tools/call against Feishu MCP endpoint.
• Env-based Config: Uses .env for all credentials and endpoint settings.

Installation

1. Clone this repository.
2. Install dependencies:

   uv sync
   

Configuration

1. Copy .env.example to .env:

   cp .env.example .env
   

2. Edit .env with your MySQL and Feishu credentials:

   MYSQL_HOST=localhost
   MYSQL_PORT=3306
   MYSQL_USER=your_username
   MYSQL_PASSWORD=your_password
   MYSQL_DATABASE=your_database
   
   # Optional: MySQL SSL
   MYSQL_USE_SSL=false
   MYSQL_SSL_CA=/path/to/ca-cert.pem
   
   # Feishu MCP
   FEISHU_MCP_URL=https://mcp.feishu.cn/mcp
   FEISHU_MCP_APP_ID=cli_xxx
   FEISHU_MCP_APP_SECRET=xxx
   FEISHU_MCP_ALLOWED_TOOLS=search-doc,fetch-doc,create-doc,update-doc
   

FEISHU_MCP_APP_ID and FEISHU_MCP_APP_SECRET are used to request tenant access token dynamically before each Feishu MCP call.

Usage

Run the MCP server:

mcp-tm

Tools

read_sql

Executes a SQL query and returns the results as JSON.

• Arguments:
  • query_sql (string): The SQL query to execute (e.g., "SELECT * FROM users LIMIT 10").
• Returns:
  • JSON string of the query results.

feishu_list_tools

Lists available Feishu MCP tools under the configured credentials and allowed tool set.

• Arguments:
  • allowed_tools (string, optional): Comma-separated tool names for this call only.
• Returns:
  • JSON-RPC response string from Feishu MCP.

feishu_call_tool

Calls a specific Feishu MCP tool.

• Arguments:
  • tool_name (string): Tool name to call, for example fetch-doc.
  • arguments_json (string): JSON object string for tool arguments.
  • allowed_tools (string, optional): Comma-separated tool names for this call only.
• Returns:
  • JSON-RPC response string from Feishu MCP.