mcp-mysql-apifox

mcp-mysql-apifox

MCP server for executing MySQL SQL, managing Apifox API documentation, and parsing/executing curl commands.

Category
Visit Server

README

主要功能

  • 不同项目连接不同
  • 在 Mysql 数据库执行 SQL
  • 添加接口文档到 Apifox
  • 从 Apifox 下载所有API到本地文件
  • 解析并执行 curl 命令

安装与使用

  1. 配置MCP服务
     {
   "mcpServers": {
     "mysql-apifox": {
       "command": "npx",
       "args": [
           "-y",
           "mcp-mysql-apifox"
       ]
     }
   }
 }
  2. 建议在项目规则中定义
       - **必须在完成后调用`help`工具询问是否完成,未完成继续,直到`help`返回完成后再总结**
   - 如果要使用mysql相关功能,使用该DSN: `mysql://user:password@host:port/database`
   - 接口文档管理规范(注意必须在明确"创建/更新接口文档"时才操作)：
     - 使用 import_openapi 工具导入，项目信息：
      - 项目ID: <apiFox项目id>
      - API密钥: <apiFox密钥>
     - 保存接口根路径: `.apiDoc`目录
     - 接口文件规范：
      - 文件位置在保存接口根路径下
      - 目录结构：按 tags 属性数组顺序创建子目录
      - 文件命名：使用 summary 属性值，格式为 JSON
      - 每次仅允许导入单个接口文件。

可用命令

execute_mysql

执行MySQL语句，需要提供DSN连接字符串。

参数：

  • dsn: MySQL数据库连接字符串，格式：mysql://user:password@host:port/database
  • sql: 要执行的SQL语句
  • params: SQL查询参数（可选）

import_openapi

导入OpenAPI数据到Apifox。

参数：

  • input: JSON、YAML或X-YAML格式的OpenAPI数据字符串，或文件路径
  • projectId: Apifox项目ID
  • apiKey: Apifox API密钥

download_apis

从Apifox下载所有API到本地文件。

参数：

  • rootDir: 下载文件的根目录路径
  • projectId: Apifox项目ID
  • apiKey: Apifox API密钥

功能说明：

  • 下载完整的OpenAPI 3.1规范文档

run_curl

解析并执行curl命令，返回HTTP请求结果。

参数：

  • curl: curl命令字符串

功能说明：

  • 自动解析curl命令中的URL、HTTP方法、请求头、请求体等信息
  • 返回完整的响应信息，包括状态码、响应头和响应数据
  • 支持所有标准的curl参数和选项

Recommended Servers

playwright-mcp

playwright-mcp

A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.

Official
Featured
TypeScript
Magic Component Platform (MCP)

Magic Component Platform (MCP)

An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.

Official
Featured
Local
TypeScript
Audiense Insights MCP Server

Audiense Insights MCP Server

Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.

Official
Featured
Local
TypeScript
VeyraX MCP

VeyraX MCP

Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.

Official
Featured
Local
graphlit-mcp-server

graphlit-mcp-server

The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.

Official
Featured
TypeScript
Kagi MCP Server

Kagi MCP Server

An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.

Official
Featured
Python
E2B

E2B

Using MCP to run code via e2b.

Official
Featured
Neon Database

Neon Database

MCP server for interacting with Neon Management API and databases

Official
Featured
Exa Search

Exa Search

A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.

Official
Featured
Qdrant Server

Qdrant Server

This repository is an example of how to create a MCP server for Qdrant, a vector search engine.

Official
Featured